I have a report, with a group A header, details, group A footer and a report footer (which I'll cover further down)
I want the header to repeat on each page. I have clicked the "repeat header on each page" option already.
If I have just enough details to push the group A footer to the second page, the header will not show up (and I want it to). If there are enough details so that there is a detail line on the second page, it works as expected and is displayed.
I could put the group A header into the page header, but then there is a problem with the report footer.
My report footer is basically a terms and conditions which takes up the entire last page, with "new page before" checked. If I have a page header at all, it pushes the report footer to a second page. I tried putting in the page header suppression formula: IIF(PageNumber = TotalPageCount, true, false) - but it seems at runtime it puts the page header on, then checks to see if it should suppress, which still makes the report footer 2 pages.
Hope this makes sense, and any input is appreciated!