How to suppress a report header for report footers
I have a report that includes two subreports, which are located in report footers. (Those subreports are not linked to the main report, and contain completely different data.)
The main report includes a page header that contains column headings, but I don't want them to appear on pages that contain report footers. (The columns are different in the main report and the subreports.)
Dell Stinnett-Christy replied
Go to the Section Expert for the page header section. DO NOT check the Suppress checkbox. Instead, click on the formula button to the right of it. In the Formula editor, enter the following:
This will suppress the page header if the report is on it's last record. The only time this might cause a problem is if the last record in the main report is on a page by itself - at that point there will be no page header with the column headings.