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!

Control Group Footer Printing 1

Status
Not open for further replies.

NEmacGuy

Instructor
Sep 1, 2004
421
US
I have inherited a crystal report (an invoice form) that is printed to plan paper. This report has an issue when it spans more than one page as the totals print in the Group Footer. Everthing is grouped by Inv No. I would like the Group footer to print on every page ( with blank totals) to keep the pages sized correct.

Possible ?

If not I know I will have to move the totals to a page footer, and redo so passed parameters from sub-reports that zero after the group footer.
 
I don't think there is a way to create repeating group footers, so you'll have to go the page footer route.

Or, another option might be to create a page break after x number of records, so that you always reserve the necessary amount of space at the bottom of the page. You could create a running total {#cntwingrp} using the expert, with a count on a recurring field, evaluate for each record, reset on change of group (Invoice). Then go to the section expert->details->new page after->x+2 and enter:

if {#cntwingrp} <> count({table.groupfield},{table.groupfield}) then
remainder({#cntwingrp},30) = 0

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top