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~!!
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: