SAP Netweaver Business Intelligence BI / BW

Symptom
A user wants to design a report where there are multiple virtual pages on a single physical page.
For example: Two virtual 8.5" x 5.5" index cards on an 8.5" x 11" physical page.
Each index card represents one member of a group, and holds header information, footer information, and a maximum number of detail records. If the number of detail records for that group member exceeds the maximum, then further detail records should print on the next index card, and so on.

Resolution
Place the header information in the group header (GH1).Place the footer information in the group footer (GF1).Insert new sections below the Details section to create Details a, Details b, Details c, and Details d.Create a formula to initialize a counter variable to 0, and put that formula into GH1.Create a formula to increment that same counter variable, and put that formula into Details a.Put the data for each details line into Details b.In Details c, copy the footer information from GF1.In Details d, copy the header information from GH1.In the Section Expert, for both Details c and Details d, click the formula icon to the right of Suppress and enter the following formula:WhilePrintingRecords;
NumberVar counter; //the counter variable discussed above
NumberVar LinesPerCard := 12; //use the actual number of desired detail records per virtual page
remainder(counter,LinesPerCard) <> 0;
The result will be that, within a given group, every 12th record the footer and header will be printed before the next record. This will push the 13th and following records onto the next virtual page. It will be necessary to experiment with the sizes of sections in Design view (especially Details c) to ensure that the right sections appear on the right pages.

See Also
This is similar to燦ote1211107. However, 1211107 only works when爑sing "real" pages. This applies when爏ubdividing the physical pages into smaller virtual pages as described. This should work with燼ny version of Crystal Reports: tested in CR10.

Keywords
CR , 129438