Problem printing Report with Sub-reports - but print preview looks fine!

M

Marty L

I have a main report that contains two subreports. The sub reports are
placed in the main reports 'Detail Section'.
The Main report is not bound to any data source.

I invoke the report in preview mode in my code with DoCmd.OpenReport
"rptDemoRptMain", acViewPreview

The report looks perfect in preview mode and is only one page. But when I
actually print the report to my printer or to acrobat distiller I get
something weird.

1. I get 3 pages - the first page has the main report 'Page Header' and
the 2'nd sub-reports 'Report Header' section. I do not get any 'Detail
Section' content found in the sub-report.

2. The second page appears to be a repeat of the first page, containing the
2'nd sub-report 'Report Header' section, and no 'Detail Section' data

3. The third page is just the main reports Page Header with no sub report at
all.

Any ideas why this would look perfect in print preview but give me such
weird results when I actually try to print?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Detail_Format works in Print Preview but Not When Printing 0
Printing of sub-report skips to second page. 7
Gouping In Sub Reports Leaving Windowed Headings 2
DB Documentation Report Crashes 0
Box around my sub report 1
My Sub Report Headers do not no print? 5
page header on second page of invoice. 3
Reset page number on invoice forms 0

Top