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!

Crystal 9 Format Grouping

Status
Not open for further replies.

Slimsteve

Technical User
Jun 10, 2003
67
GB

I have a small question relating to grouping on a crystal report.

Here is the report setup:

Page Header : report Header details
Group Header : Customer Number
Details: All records for that customer
Group Footer : Summaries of customer records.

Nothing too special about the report setup, but the problem I have got is that when the grouping runs onto a second page I need to leave about a couple of inches blank on the bottom of the previous page (printing on pre-printed stationary).

Bascially the report grouping break page method works fine, unless the grouping exceeds more than one page, that is when the problem occurrs.

Any ideas??

Slim
 
You could force a page break based on recordnumber or linecount. Place the following in the formula section in format section->details->new page after:

remainder(recordnumber, 40) = 0 //substitute the number of records that work for you

To be even more precise, you could use a formula like {@linecount} to be placed in all group header and footer and detail sections:

whileprintingrecords;
numbervar line := line + 1;

Then use {@linecount} instead of "recordnumber" in the formula above.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top