Posted 15 December 2023, 2:45 am EST - Updated 15 December 2023, 3:32 am EST
I am trying to create a section report that consists of several other reports compiled together. The user would otherwise have to run them one by one and manually collate.
The issue I am running into is that the page headers are different on these reports, and the report uses the page header of the main report instead of the page headers of the sub report that the page is currently on. And the amount of reports per “member” is dynamic - so I can’t swap the page header based on page number.
Ideally, I would like for the subreport to include the page headers and page footers as well. In my case, there should never be more than one subreport on the same page.
Is there a way to do this, or is there a better approach to accomplish what I am trying to do?
If I could string together PDF exports, this would work great as well but I can’t figure out how to do that.