# of line items per page

[kmPremier]

I have a report that is printing on pre-printed 81/2" x 5" paper, I am trying to modify an exiting report to fit this, however the Number of line items printing is going over the spacing on the pre-printed form. I would like to reduce the number of lines by about 2 lines - Does anyone know how to do this????

Thanks!

 

[bdreed35]

if there is a set number of records to be printed per page you can force the new page after property when the desired number of records is reached.

For instance, lets say that you want 12 lines per page.

Go to Report, Section Expert.
Highlight the Details section.
Click the X+2 button to the right of "New Page After"
Enter the following line of code into the editor:

recordnumber mod 12 = 0

Save and Close and Test.

Modify the code for the number of lines you desire.

~Brian

 

[lbass]

You can create conditional page breaks by going to the section expert->details->new page after->x+2 and entering:

remainder(recordnumber, 25) = 0

//if you want only 25 records per page

If you have multiple groups, then you would want to create a running total {#cntwingrp} by selecting count of a recurring field, evaluate for each record, reset on change of group, and changing the formula to:

remainder({#cntwingrp}, 25) = 0

You would also have new page after set for the group footer.

-LB

 

[synapsevampire]

This would depend on your printer, as Crystal is printer based.

If your printer supports it, change the File->Printer Setup->Paper Size to Statement, and select landscape.

That will net a 8.5x5

It works with a Cannon iR2200-3300 PCL5e.

Test the different configurations available for you printer, or just use a letter size and add in a large margin at the bottom.

-k