Kbase P4889: How to create a break page in Report Builder every n records
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Verified
GOAL:
How to create a break page in Report Builder every n records
GOAL:
Counting records in Report Builder
FIX:
The following steps show how to create a break page every N records:
1) Some versions of Report Builder have the calculated field 'Recno_rb' already defined. If this calculated field does not exist, create a new calculated field with the expression 'RECORD-NUMBER()'.
2) Create a calculated field with the following expression:
IIF(Recno_rb Modulo 3 = 0,0,Recno_rb)
The number '3' is the records to print in each page.
3) Create a new Record band line with the 'New Page Line' property set to true.
4) Edit the Band Line Properties for the new band line and check the 'Enable Condition Option', then choose the calculated field created in the step 2 then choose the 'Print when field is zero, empty or unknown' option.