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

[sara]

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 ConvertReportTo PDF 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

[Tom van Stiphout]

On Tue, 22 Apr 2008 08:09:50 -0700 (PDT), sara <sa*******@yaho o.com>
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 ConvertReportTo PDF 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

[Stephen Lebans]

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" <sa*******@yaho o.comwrote in message
news:b4******** *************** ***********@t54 g2000hsg.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 ConvertReportTo PDF 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

[sara]

On Apr 23, 8:40*am, "Stephen Lebans" <ForEmailGotoMy .WebSite.-
WWWdotlebansdot [e-mail] mwrote:

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" <saraqp...@yaho o.comwrote in message

news:b4******** *************** ***********@t54 g2000hsg.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 ConvertReportTo PDF 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

[sara]

On Apr 23, 1:29*am, Tom van Stiphout <no.spam.tom7.. [e-mail]:

On Tue, 22 Apr 2008 08:09:50 -0700 (PDT), sara <saraqp...@yaho o.com>
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 ConvertReportTo PDF 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 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

[Stephen Lebans]

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" <sa*******@yaho o.comwrote in message
news:3e******** *************** ***********@c58 g2000hsc.google groups.com...
On Apr 23, 8:40 am, "Stephen Lebans" <ForEmailGotoMy .WebSite.-
WWWdotlebansdot [e-mail] mwrote:

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" <saraqp...@yaho o.comwrote in message

news:b4******** *************** ***********@t54 g2000hsg.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 ConvertReportTo PDF 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

[sara]

On Apr 23, 12:06*pm, "Stephen Lebans" <ForEmailGotoMy .WebSite.-
WWWdotlebansdot [e-mail] mwrote:

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 Lebanshttp://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

"sara" <saraqp...@yaho o.comwrote in message

news:3e******** *************** ***********@c58 g2000hsc.google groups.com...
On Apr 23, 8:40 am, "Stephen Lebans" <ForEmailGotoMy .WebSite.-

WWWdotlebansdot [e-mail] mwrote:

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" <saraqp...@yaho o.comwrote in message

news:b4******** *************** ***********@t54 g2000hsg.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 ConvertReportTo PDF 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- 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

[Stephen Lebans]

Then it is bug in my code. Your only solution until I publish the next
release is to set your Default printer to match the requried Paper
Size/Orientation for the report.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"sara" <sa*******@yaho o.comwrote in message
news:10******** *************** ***********@26g 2000hsk.googleg roups.com...
On Apr 23, 12:06 pm, "Stephen Lebans" <ForEmailGotoMy .WebSite.-
WWWdotlebansdot [e-mail] mwrote:

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 Lebanshttp://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

"sara" <saraqp...@yaho o.comwrote in message

news:3e******** *************** ***********@c58 g2000hsc.google groups.com...
On Apr 23, 8:40 am, "Stephen Lebans" <ForEmailGotoMy .WebSite.-

WWWdotlebansdot [e-mail] mwrote:

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" <saraqp...@yaho o.comwrote in message

news:b4******** *************** ***********@t54 g2000hsg.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 ConvertReportTo PDF 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- 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

[sara]

On Apr 24, 9:28*pm, "Stephen Lebans" <ForEmailGotoMy .WebSite.-
WWWdotlebansdot [e-mail] mwrote:

Then it is bug in my code. Your only solution until I publish the next
release is to set your Default printer to match the requried Paper
Size/Orientation for the report.

--

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

"sara" <saraqp...@yaho o.comwrote in message

news:10******** *************** ***********@26g 2000hsk.googleg roups.com...
On Apr 23, 12:06 pm, "Stephen Lebans" <ForEmailGotoMy .WebSite.-

WWWdotlebansdot [e-mail] mwrote:

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 Lebanshttp://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

"sara" <saraqp...@yaho o.comwrote in message

news:3e******** *************** ***********@c58 g2000hsc.google groups.com...
On Apr 23, 8:40 am, "Stephen Lebans" <ForEmailGotoMy .WebSite.-

WWWdotlebansdot [e-mail] mwrote:

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" <saraqp...@yaho o.comwrote in message

>news:b4******* *************** ************@t5 4g2000hsg.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 ConvertReportTo PDF 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- 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- Hide quoted text -

- Show quoted text -

Thanks. Do you need a version of my database/code to help find/
resolve the bug (if there is indeed one?) I can zip and email to you
if it will help you. I love the solution - this is the first time
I've had any sort of problem!

Much appreciate the help and advice -
Sara

[Stephen Lebans]

I have already fixed the bug Sara. I got bogged down the last 2 weeks adding
better Unicode support. BiDi landguages are tough.

I've finished the Unicode stuff for now and am trying to post the new
release this weekend.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"sara" <sa*******@yaho o.comwrote in message
news:51******** *************** ***********@d45 g2000hsc.google groups.com...
On Apr 24, 9:28 pm, "Stephen Lebans" <ForEmailGotoMy .WebSite.-
WWWdotlebansdot [e-mail] mwrote:

Then it is bug in my code. Your only solution until I publish the next
release is to set your Default printer to match the requried Paper
Size/Orientation for the report.

--

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

"sara" <saraqp...@yaho o.comwrote in message

news:10******** *************** ***********@26g 2000hsk.googleg roups.com...
On Apr 23, 12:06 pm, "Stephen Lebans" <ForEmailGotoMy .WebSite.-

WWWdotlebansdot [e-mail] mwrote:

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 Lebanshttp://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

"sara" <saraqp...@yaho o.comwrote in message

news:3e******** *************** ***********@c58 g2000hsc.google groups.com...
On Apr 23, 8:40 am, "Stephen Lebans" <ForEmailGotoMy .WebSite.-

WWWdotlebansdot [e-mail] mwrote:

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" <saraqp...@yaho o.comwrote in message

>news:b4******* *************** ************@t5 4g2000hsg.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 ConvertReportTo PDF 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- 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- Hide quoted text -

- Show quoted text -

Thanks. Do you need a version of my database/code to help find/
resolve the bug (if there is indeed one?) I can zip and email to you
if it will help you. I love the solution - this is the first time
I've had any sort of problem!

Much appreciate the help and advice -
Sara