I am creating a report that is basically an invoice, this invoice has a sub-report at the end to show allowances and charge-backs. Right now it runs through the details and forces a new page with this formula:
not onlastrecord and remainder(recordnumber, 10) = 0
This is in the bottom of my details section to keep from too many items showing up per page and to properly display the "Continued on next page" column which is set to supress unless the same formula is matched.
This works great, but what happens is when there is a total equal to, or it ends on the 10th record for that page, it will hit the last record, then the sub-report kicks in, the sub-report can have multiple columns as well, so it can potentially cause a page-break, when this happens the lines I have defining the columns in my main-reports details will repeat for the entire length of the page and overlap the sub-report.
Does anyone have any idea on a forumla I can use to supress this behavior and let the sub-report break the page cleanly while not repeating the main-reports details section if the last record has already been presented?
Thanks,
not onlastrecord and remainder(recordnumber, 10) = 0
This is in the bottom of my details section to keep from too many items showing up per page and to properly display the "Continued on next page" column which is set to supress unless the same formula is matched.
This works great, but what happens is when there is a total equal to, or it ends on the 10th record for that page, it will hit the last record, then the sub-report kicks in, the sub-report can have multiple columns as well, so it can potentially cause a page-break, when this happens the lines I have defining the columns in my main-reports details will repeat for the entire length of the page and overlap the sub-report.
Does anyone have any idea on a forumla I can use to supress this behavior and let the sub-report break the page cleanly while not repeating the main-reports details section if the last record has already been presented?
Thanks,