Remove the Last PageBreak for a Report Group
|Product||Progress® Telerik® Reporting|
In many reporting scenarios, you would like to have page breaks between report groups. You may easily achieve this, for example, by setting the PageBreak property of the Group Footer section to 'After'. However, the page break will occur also after the last Group Footer. Here we explain how to avoid the last page break.
For example, in the following Expression, we compare the last value in the group with the last value of the entire report data, and if they coincide, the Group Footer PageBreak is set to "None".
=IIF(Last(Fields.value) = Exec("Report1", Last(Fields.value)), "None", "After")
The Expression assumes that the data sorting/filtering is not modified in the group. If there is sorting or additional filtering in the data, you must take this into account in the Expression. The Expression assumes also that the last data values don't repeat among the groups. We use the Exec data function to access the data scope of the Report that is parent for the Report Group.