Formatting issue

[DelmarDawg]

I need to have page breaks between groups, but how do I have the Grand totals show on the last data page and not a page of its own? I know there is a way to conditionally add the page break, but I don't know what the formula would be.

 

[synapsevampire]

Instead of just selecting New Page After for the group, place the following in the New Page After formula (X2):

not(onlastrecord)

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[chelseatech]

Two methods I teach on my courses

1) Suppress the Report Header (your page headings should be in the Page Hader section), and set New Page before on Group Header 1

Variation on one is if your break needs to be on Group 3 then, move the Group 1 Name and Group 2 Name to Group Header 3 and supress GH1 and GH2 sections

2) You can do a conditional page break. If your current report is working except for the grand total on the last page by itself then on that group footer use a conditional page break of
NOT OnLastRecord Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm