Check Stub Overflow spawns continuation of report on next page 1

[RGG55]

I am creating a Crystal Report for a business check with 2 stubs on top and the check on the bottom.
The stubs are subreports which are duplicates of each other and can have many details. If the details are too numerous to fit in the stub section, I want the overflow to go onto the next page, and to leave the check blank on the first page. I am unable to find a way to print the overflow details from the subreports on the second page. Can anyone offer help with this issue? I will also need to know how to make sure that when there is an overflow that the bottom portion of the first page (the check itself) is blank with the check printing on the page where the last detail record exists on the stub.

 

[lbass]

I think you would have to do something like place the sub in two group header sections, GH_a, and GH_b, with the check in the report footer section, and then place the sub again in two group footer sections. Add a blank GH_c section that is the same height as the check that is now in the report footer. In the group header sections, you would need to create a formula that counts lines/records and then suppress results above a certain line count, so that the sub does not grow beyond the desired space. In the group footer subs, you would need to suppress results equal to or below the same line count, so you can display the balance of the results. To count "lines" you could create a formula like this:

whileprintingrecords;
numbervar cnt := cnt + 1;

Place this in each visible section of the subreport. This assumes that each report section within the sub is the same height. You would also need to format the first group footer section to "new page before", and format the subs to "suppress blank subreport" and format the group footer sections to "suppress blank sections".

In the sub in GH_b ONLY, add a formula like this to the report footer:

whileprintingrecords;
numbervar cnt;
shared numbervar totcnt := cnt;

Then format the blank GH_c->suppress blank section (do not check)->x+2 and enter:

whileprintingrecords;
shared numbervar totcnt;
totcnt <= 25; //if you are suppressing all records > 25

This should be close to what you need.

-LB

 

[Barb100]

I am using Crystal 10, and could sure use some help.

I have created a crystal report that simulates a form, and Page 1 has different Page Headers and Page Footers than Page 2. I have created grid sections to print, whether or not there is data in them, so if there are 10 grid lines on the first page, and only 3 lines print, the remaining 7 empty lines will print to fill up the page. I have created these as Group Footers, with blank grid lines, and with a formula to suppress the line, depending upon the Page number and the linecounter. So if the report has 12 lines on it, it will print 10 on the first page, and then 2 on the next page, and fill the page with the remaining 38 blank grid lines. (Second page should always print 40 grid lines)

Page 1 prints fine, however, page two will only print 25 lines. So in the scenario above, 2 lines will print on the second page, with data, and the remaining 23 lines will print with blank grids. What I was hoping for was 40 lines.

I have created enough lines to print 40. The remaining footers will print properly, however, the lower section of Page 2, and subsequently every page after 1, with alot of blank space.


Anyone have any ideas as to how to make this work?

Thanks,
-BC

 

[lbass]

What is the formula you are using for suppression? Is this applied to each individual group footer section (40 of them)?

-LB