I use a GroupFooterBand to display a cumulative page sum (subtotal) for a table with order positions. I use a custom summary funtion to display this cumulative page sum.
Below the table with the order positions, other tables with data like service cost, VAT and discounts follow. For this reason, I would like to hide the GroupFooterBand with the subtotal on the last page of the order. The same applies if the table with order positions is short and everything fits on a single page.
However, I can't access the page information in the BeforePrint event of the band. When I set e.cancel true in the PrintOnPage event of the table or table cell, the line with the GroupFooterSum is not printed but a blank line appers instead.
How can I hide the band at the end of the table?
Thank you for the additional clarification. I believe that you can use the CurrentRowIndex and RowCount properties of your DetailReportBand to define whether the group footer should be shown. Attached is an updated sample illustrating this approach. Let me know whether it meets your requirements.