I have a report with a subreport. The subreport has a page header (not a report header). And I have the "Show Page Header and Page Footer" property set to yes. So the header appears on the first page of the subreport as expected. But it does not appear on any subsequent pages. I need the subreport header to appear on all subsequent pages.
In researching this, I have found that the common solution is to create a dummy group, put the subreport header in the header for the dummy group, and set the dummy group header to repeat.
But I that solution does not works for me. Here's how my report is currently structured (I don't think I need to wrap this in code but I will out of an abundance of caution):
Code:
Report header: blank
Page Header: blank
Group 1 Header: Main report header
Group 2 Header: blank
Detail: Main report data
Group 1 Footer: Contains the sum of one of the fields in the "Detail" seciton
Group 2 Footer: contains my subreport w "Force New Page: Before & After"
Page Footer: blank
Report Footer: blank
I structured it this way because (1) I needed a group footer for the "Sum" filed in my main report, and (2) I needed to put the subreport in a footer so that the subreport would appear after the main report and I could force a page break with the "Force New Page" feature.
If I add a new group (Group 3), the header will appear between Group 2 and Detail. So if I put the subreport header in the Group 3 header, it'll just appear above the detail section.
Code:
Report header: blank
Page Header: blank
Group 1 Header: Main report header
Group 2 Header: blank
Group 3 Header:
Detail: Main report data
Group 1 Footer: Contains the sum of one of the fields in the "Detail" seciton
Group 2 Footer: contains my subreport w "Force New Page: Before & After"
Page Footer: blank
Report Footer: blank
Does anyone have any proposed solutions? I would greatly appreicate any assistance.