Report formatting Disappears on Some Items when Output to PDF in Code

Hi -

I have a report that is 14 columnar sub-reports (Line up: Position-
holders in each of our 14 locations - Manager, Assistant Manager,
Receiving, Office, etc).

I output directly to PDF (using ConvertReportToPDF from this site -
Stephan Lebans)

The formatting - Outlines on some fields - do not appear on subreports
12-14 (Columns 12 - 14).

I tried removing some of the boxes around some fields, thinking that
it was just "too much" somewhere, but that didn't work.


Any ideas? I don't know if I have to email the mdb and data for
someone to figure this out. I have used the code to write to PDF
before - no problem. And this writes to PDF, just loses some
formatting lines.

thanks -
sara

Re: Report formatting Disappears on Some Items when Output to PDF in Code

On Tue, 22 Apr 2008 08:09:50 -0700 (PDT), sara
wrote:

Was it really necessary to create all these subreports, or could you
just as well have used a single report with a Grouping Level by
Position?

-Tom.


>Hi -
>
>I have a report that is 14 columnar sub-reports (Line up: Position-
>holders in each of our 14 locations - Manager, Assistant Manager,
>Receiving, Office, etc).
>
>I output directly to PDF (using ConvertReportToPDF from this site -
>Stephan Lebans)
>
>The formatting - Outlines on some fields - do not appear on subreports
>12-14 (Columns 12 - 14).
>
>I tried removing some of the boxes around some fields, thinking that
>it was just "too much" somewhere, but that didn't work.
>
>
>Any ideas? I don't know if I have to email the mdb and data for
>someone to figure this out. I have used the code to write to PDF
>before - no problem. And this writes to PDF, just loses some
>formatting lines.
>
>thanks -
>sara

Re: Report formatting Disappears on Some Items when Output to PDF in Code

Sara forget about my code for a moment. Manually open the report and export
it to Snapshot format. Is the formatting correct in the Snapshot?

To verify it is not a Printer driver issue, setup the Default printer for
your computer to match what is required for your report(Portrait/Landscape
amd Paper Size. Now use my code to putput your Report to PDF.

Let me know.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


"sara" wrote in message
news:b4b349b9-37d1-4943-ab1f-30859585ccab@t54g2000hsg.google groups.com...
> Hi -
>
> I have a report that is 14 columnar sub-reports (Line up: Position-
> holders in each of our 14 locations - Manager, Assistant Manager,
> Receiving, Office, etc).
>
> I output directly to PDF (using ConvertReportToPDF from this site -
> Stephan Lebans)
>
> The formatting - Outlines on some fields - do not appear on subreports
> 12-14 (Columns 12 - 14).
>
> I tried removing some of the boxes around some fields, thinking that
> it was just "too much" somewhere, but that didn't work.
>
>
> Any ideas? I don't know if I have to email the mdb and data for
> someone to figure this out. I have used the code to write to PDF
> before - no problem. And this writes to PDF, just loses some
> formatting lines.
>
> thanks -
> sara

Re: Report formatting Disappears on Some Items when Output to PDF in

On Apr 23, 8:40=A0am, "Stephen Lebans" WWWdotlebansdot...@linvalid.com> wrote:
> Sara forget about my code for a moment. Manually open the report and expor=
t
> it to Snapshot format. Is the formatting correct in the Snapshot?
>
> To verify it is not a Printer driver issue, setup the Default printer for
> your computer to match what is required for your report(Portrait/Landscape=

> amd Paper Size. Now use my code to putput your Report to PDF.
>
> Let me know.
>
> --
>
> HTH
> Stephen Lebanshttp://www.lebans.com
> Access Code, Tips and Tricks
> Please respond only to the newsgroups so everyone can benefit.
>
> "sara" wrote in message
>
> news:b4b349b9-37d1-4943-ab1f-30859585ccab@t54g2000hsg.google groups.com...
>
>
>
> > Hi -
>
> > I have a report that is 14 columnar sub-reports (Line up: Position-
> > holders in each of our 14 locations - Manager, Assistant Manager,
> > Receiving, Office, etc).
>
> > I output directly to PDF (using ConvertReportToPDF from this site -
> > Stephan Lebans)
>
> > The formatting - Outlines on some fields - do not appear on subreports
> > 12-14 (Columns 12 - 14).
>
> > I tried removing some of the boxes around some fields, thinking that
> > it was just "too much" somewhere, but that didn't work.
>
> > Any ideas? =A0I don't know if I have to email the mdb and data for
> > someone to figure this out. =A0I have used the code to write to PDF
> > before - no problem. =A0And this writes to PDF, just loses some
> > formatting lines.
>
> > thanks -
> > sara- Hide quoted text -
>
> - Show quoted text -

I don't think it's the code - I use this code in several places and
have Never had a problem. But this is the first time this has
happened.

It does print in Snapshot format - all perfectly. I should have
posted that yesterday - sorry.

I set my default settings on my printer (Legal and Landscape were the
changes) and it prints fine. I printed an Outlook calendar page and a
page of a Word document - no problem - with the changed settings.

I returned the settings (Letter and Portrait) and the "lines around
the boxes" on the 3 columns on the far right disappeared again.

Also - though I think this is a different problem - (But just in case,
I'll mention it) - when the user ran the report (from her PC, and
would print on her printer) the report went to Letter size paper -
landscape. The PDF file shows 2 pages letter-sized.

Does this help? I am running an MDE (it happens in the MDB also), and
using A2K.

Thanks so very much -
Sara

Re: Report formatting Disappears on Some Items when Output to PDF in

On Apr 23, 1:29=A0am, Tom van Stiphout wrote:
> On Tue, 22 Apr 2008 08:09:50 -0700 (PDT), sara
> wrote:
>
> Was it really necessary to create all these subreports, or could you
> just as well have used a single report with a Grouping Level by
> Position?
>
> -Tom.
>
>
>
> >Hi -
>
> >I have a report that is 14 columnar sub-reports (Line up: Position-
> >holders in each of our 14 locations - Manager, Assistant Manager,
> >Receiving, Office, etc).
>
> >I output directly to PDF (using ConvertReportToPDF from this site -
> >Stephan Lebans)
>
> >The formatting - Outlines on some fields - do not appear on subreports
> >12-14 (Columns 12 - 14).
>
> >I tried removing some of the boxes around some fields, thinking that
> >it was just "too much" somewhere, but that didn't work.
>
> >Any ideas? =A0I don't know if I have to email the mdb and data for
> >someone to figure this out. =A0I have used the code to write to PDF
> >before - no problem. =A0And this writes to PDF, just loses some
> >formatting lines.
>
> >thanks -
> >sara- Hide quoted text -
>
> - Show quoted text -

I can't think of any way to do that. The user chooses a location,
then chooses people (from the entire list of company employees) to put
into each position on a form. People come and go often and change
positions.

THe table is Date, Store, then all the positions: Manager, Asst,
Hardware, etc. Date is a date, Store is a number, and the key to the
EE file is loaded into the position. Many fields are blank - it
varies by date and location.

If there is another way to do this, I'm interested to understand and
try it.

Sara

Re: Report formatting Disappears on Some Items when Output to PDF in Code

Sara I don't see the answer to my question to you. What happens when you set
the Default printer manually(via the Control Panel, to Landscape/Legal and
then use my ReportToPDF code to produce a PDF?

Finally, there are several report related issues with the first release of
Access 2000. Can you check the installs and see what version of Access you
are actually using? Menu - Help -About

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


"sara" wrote in message
news:3e55ea84-f8bb-4b0f-9aca-a0b5352a93b7@c58g2000hsc.google groups.com...
On Apr 23, 8:40 am, "Stephen Lebans" WWWdotlebansdot...@linvalid.com> wrote:
> Sara forget about my code for a moment. Manually open the report and
> export
> it to Snapshot format. Is the formatting correct in the Snapshot?
>
> To verify it is not a Printer driver issue, setup the Default printer for
> your computer to match what is required for your report(Portrait/Landscape
> amd Paper Size. Now use my code to putput your Report to PDF.
>
> Let me know.
>
> --
>
> HTH
> Stephen Lebanshttp://www.lebans.com
> Access Code, Tips and Tricks
> Please respond only to the newsgroups so everyone can benefit.
>
> "sara" wrote in message
>
> news:b4b349b9-37d1-4943-ab1f-30859585ccab@t54g2000hsg.google groups.com...
>
>
>
> > Hi -
>
> > I have a report that is 14 columnar sub-reports (Line up: Position-
> > holders in each of our 14 locations - Manager, Assistant Manager,
> > Receiving, Office, etc).
>
> > I output directly to PDF (using ConvertReportToPDF from this site -
> > Stephan Lebans)
>
> > The formatting - Outlines on some fields - do not appear on subreports
> > 12-14 (Columns 12 - 14).
>
> > I tried removing some of the boxes around some fields, thinking that
> > it was just "too much" somewhere, but that didn't work.
>
> > Any ideas? I don't know if I have to email the mdb and data for
> > someone to figure this out. I have used the code to write to PDF
> > before - no problem. And this writes to PDF, just loses some
> > formatting lines.
>
> > thanks -
> > sara- Hide quoted text -
>
> - Show quoted text -

I don't think it's the code - I use this code in several places and
have Never had a problem. But this is the first time this has
happened.

It does print in Snapshot format - all perfectly. I should have
posted that yesterday - sorry.

I set my default settings on my printer (Legal and Landscape were the
changes) and it prints fine. I printed an Outlook calendar page and a
page of a Word document - no problem - with the changed settings.

I returned the settings (Letter and Portrait) and the "lines around
the boxes" on the 3 columns on the far right disappeared again.

Also - though I think this is a different problem - (But just in case,
I'll mention it) - when the user ran the report (from her PC, and
would print on her printer) the report went to Letter size paper -
landscape. The PDF file shows 2 pages letter-sized.

Does this help? I am running an MDE (it happens in the MDB also), and
using A2K.

Thanks so very much -
Sara

Re: Report formatting Disappears on Some Items when Output to PDF in

On Apr 23, 12:06=A0pm, "Stephen Lebans" WWWdotlebansdot...@linvalid.com> wrote:
> Sara I don't see the answer to my question to you. What happens when you s=
et
> the Default printer manually(via the Control Panel, to Landscape/Legal and=

> then use my ReportToPDF code to produce a PDF?
>
> Finally, there are several report related issues with the first release of=

> Access 2000. Can you check the installs and see what version of Access you=

> are actually using? Menu - Help -About
>
> --
>
> HTH
> Stephen Lebanshttp://www.lebans.com
> Access Code, Tips and Tricks
> Please respond only to the newsgroups so everyone can benefit.
>
> "sara" wrote in message
>
> news:3e55ea84-f8bb-4b0f-9aca-a0b5352a93b7@c58g2000hsc.google groups.com...
> On Apr 23, 8:40 am, "Stephen Lebans" >
>
>
>
>
> WWWdotlebansdot...@linvalid.com> wrote:
> > Sara forget about my code for a moment. Manually open the report and
> > export
> > it to Snapshot format. Is the formatting correct in the Snapshot?
>
> > To verify it is not a Printer driver issue, setup the Default printer fo=
r
> > your computer to match what is required for your report(Portrait/Landsca=
pe
> > amd Paper Size. Now use my code to putput your Report to PDF.
>
> > Let me know.
>
> > --
>
> > HTH
> > Stephen Lebanshttp://www.lebans.com
> > Access Code, Tips and Tricks
> > Please respond only to the newsgroups so everyone can benefit.
>
> > "sara" wrote in message
>
> >news:b4b349b9-37d1-4943-ab1f-30859585ccab@t54g2000hsg.googl egroups.com...=

>
> > > Hi -
>
> > > I have a report that is 14 columnar sub-reports (Line up: Position-
> > > holders in each of our 14 locations - Manager, Assistant Manager,
> > > Receiving, Office, etc).
>
> > > I output directly to PDF (using ConvertReportToPDF from this site -
> > > Stephan Lebans)
>
> > > The formatting - Outlines on some fields - do not appear on subreports=

> > > 12-14 (Columns 12 - 14).
>
> > > I tried removing some of the boxes around some fields, thinking that
> > > it was just "too much" somewhere, but that didn't work.
>
> > > Any ideas? I don't know if I have to email the mdb and data for
> > > someone to figure this out. I have used the code to write to PDF
> > > before - no problem. And this writes to PDF, just loses some
> > > formatting lines.
>
> > > thanks -
> > > sara- Hide quoted text -
>
> > - Show quoted text -
>
> I don't think it's the code - I use this code in several places and
> have Never had a problem. =A0But this is the first time this has
> happened.
>
> It does print in Snapshot format - all perfectly. =A0I should have
> posted that yesterday - sorry.
>
> I set my default settings on my printer (Legal and Landscape were the
> changes) and it prints fine. =A0I printed an Outlook calendar page and a
> page of a Word document - no problem - with the changed settings.
>
> I returned the settings (Letter and Portrait) and the "lines around
> the boxes" on the 3 columns on the far right disappeared again.
>
> Also - though I think this is a different problem - (But just in case,
> I'll mention it) - when the user ran the report (from her PC, and
> would print on her printer) the report went to Letter size paper -
> landscape. =A0The PDF file shows 2 pages letter-sized.
>
> Does this help? =A0I am running an MDE (it happens in the MDB also), and
> using A2K.
>
> Thanks so very much -
> Sara- Hide quoted text -
>
> - Show quoted text -

Sorry - my response "I set my default settings on my printer (Legal
and Landscape were the changes) and it prints fine." should have said
"and the PDF run with that looks fine.

Access 2000 9.0.8981 SP-3

Sara