limiting number of records per page in Crystal 10

[jj1576]

Hi,

I have a report that has 2 headers and 2 footers (a&b) and is a maximum of 2 pages. I have it set up so header a and footer a appear on page 1, and header b and footer b on page 2.

I need to limit the number of records on the first page to 4 in the details section, and if there is a 5th record, I want it & all subsequent records to appear on page 2.

The problem is, that if I use the "new page after" box in the section expert, it doesn't show the page one footer. Is there a way to put the fifth record (and beyond) on page 2 without effecting the footers?

I do have a variable "val" that counts each record (I have some details suppressions in place), so I assume there must be something that works on if val > 4 then on next page?

 

[lbass]

If your footer is a Page Footer, then the page break should not affect it. I'm assuming you have built criteria into your variable so that it doesn't count suppressed records. You should then be able to go into the section expert->details->new page after->x+2 and enter something like:

whileprintingrecords;
numbervar val;
remainder(val,5) = 0

-LB

 

[jj1576]

Thanks lbass.

This worked, but now because I have two page footers it is telling me that it can't format the objects in the report because the page size is too small.

The report is a maximum of 2 pages, and I have one footer suppressed on the 1st page and the other suppressed on the second page. I have the same format for the 2 headers. I figured because only one header and footer could show up per page that there would be enough space. Apparently it includes suppressed sections too? Is there a way around this?

Thanks

 

[lbass]

What report objects do you have that are so large and in what section are they located? Please use the full description of the section, not just "footer".

-LB

 

[jj1576]

lbass,

I think I figured out a solution by using the underlay following sections in report footer a. It is a questionnaire style report, so I had a lot of text boxes and lines in each page footer as well as each page header. It has to be a specific length which was why it took up so much space. Anyhow, Thanks for your help!