Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Page break issue

Status
Not open for further replies.

yehong

Programmer
Sep 22, 2003
291
US
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 found the solution. All I needed was to remove the line 'Not(OnLastRecord) from Group2 group header section. I think I should have tried all options before posting this lengthy post. I applogize if it wasted anyones' time,and on the other hand I hope this post might help someone.
Thanks.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top