Print report and subreport(no data) without blank page

Joined
Aug 17, 2009
Messages
1
Reaction score
0
I have a form to choose which report I want, and when I click the item in the list it will show the main report by using marco.

the main report have 4 sub-reports in it, I used a ref number to link them together. some ref number have data only in some sub-reports

eg
ref no. 1 --> Main report + sub-report 1, 2, 3
ref no. 2 --> Main report + sub-report 1, 3
ref no. 3 --> Main report + sub-report 1, 2, 3, 4

I want to print and output the report, I want to have a new page for each sub-report.

AND

if there is data, open a new page to print the sub-report

eg
ref no. 1
page 1: main report
page 2: sub-report 1
page 3: sub-report 2
page 4: sub-report 3


if no data in any sub-report , then open the others (sub-report) that have data and print

eg
ref no.2
page 1: main report
page 2: sub-report 1
page 3: sub-report 3


I tried the "page break" method, it shows a blank page
eg
page 1: main report
page 2: sub-report 1
page 3: blank page
page 4: sub-report 3

I don't want any blank page


the main report format are as follow (no any Header and Footer of the Main report)

Detail
(some textfields of the main report)
Sub-Report 1
GroupHeader
Detail
GroupFooter
PageFooter
Sub-Report 2
GroupHeader
Detail
GroupFooter
PageFooter
:
:

I try the "force to new page" and "group" method (I don't know if I used it in wrong way) I can't do what I want

can anyone tell me how to use the "force to new page" and "group" method in my case?? Are there any other methods I could try? can you suggest some ????

Millions thanks~!!
 
Last edited:
Back
Top