Page break issue. I am using CR8.5.
I have two groups in my report. Say Group1 and Group2. Under each Group1 group there are multiple Group2 groups. I want a page break between each Group1 group along with a page break between Group2 groups.
For exp:
HR (Group1) Salary
VP (Group2) 1000
-------------------
Totals for VP 1000
-------need a page break------(say page 1)
HR
SVP 2000
-------------------
Totals for SVP 2000
-------need a page break------(page 2)
HR
Dir 10000
-------------------
Total for SVP 10000
Total for HR = 13000
-------need a page break------(page 3)
Finance
VP 5000
-----------------
Totals forVP 5000
------need a page break-------(page 4)
Finance
SVP 6000
-----------------
Totals SVP 6000
Total for Finance = 11000
Grand Totals for Group1 groups = 24000 (page 5)
-End of Report-
I hope this sample makes sense. If not let me know and I will clarify it. As of now I am using following logic it works fine, but the last page is listing multiple Group2 groups just before Grand Totals line.
New Page Before of Group1 group header = 'Not (OnFirstRecord)'
New Page Before of Group2 group header = 'Previous(Table1.Group1)=({Table1.Group1}) And
Not (OnLastRecord) And
Not (OnFirstRecord)'
Thanks.
I have two groups in my report. Say Group1 and Group2. Under each Group1 group there are multiple Group2 groups. I want a page break between each Group1 group along with a page break between Group2 groups.
For exp:
HR (Group1) Salary
VP (Group2) 1000
-------------------
Totals for VP 1000
-------need a page break------(say page 1)
HR
SVP 2000
-------------------
Totals for SVP 2000
-------need a page break------(page 2)
HR
Dir 10000
-------------------
Total for SVP 10000
Total for HR = 13000
-------need a page break------(page 3)
Finance
VP 5000
-----------------
Totals forVP 5000
------need a page break-------(page 4)
Finance
SVP 6000
-----------------
Totals SVP 6000
Total for Finance = 11000
Grand Totals for Group1 groups = 24000 (page 5)
-End of Report-
I hope this sample makes sense. If not let me know and I will clarify it. As of now I am using following logic it works fine, but the last page is listing multiple Group2 groups just before Grand Totals line.
New Page Before of Group1 group header = 'Not (OnFirstRecord)'
New Page Before of Group2 group header = 'Previous(Table1.Group1)=({Table1.Group1}) And
Not (OnLastRecord) And
Not (OnFirstRecord)'
Thanks.