April 24, 2022 at 12:15 pm
Hi All,
Thanks for the input in advance. I’ve created a main report which features multiple sub reports. Each sub report is in a box so that it can have a page break at the end of each report. This is so that each report can appear on a separate sheet in Excel once it’s been exported. Side note – is there a better way to force a page break without the box?
The problem is that each sub report has its page header stripped once rendered. Apparently this is a feature rather than a bug and according to these answers:
https://www.sqlservercentral.com/forums/topic/headerfooter-not-showing-up-in-subreport
the solution is to remove the page headers from the individual reports and then add them to the main report or move the 'header' to the body of the individual report. However this is undesirable for our application.
There is however one link which mentions that there is another way to force the sub reports to be displayed:
"Ok, just solved this...the solution was simple (& didn't involved any grouping spoken of in all the solutions I googled).
In the main report, withing Design View, select the 'detail' section at the top of the properties box ...there's an option in the to select "Show Page Header & footer" - select yes, voila, the page header in the sub report is now visible in the main report"
The problem is that I can’t seem to find the menu this person is referring to. Can anyone else give any extra information on this? Ideally with screenshots?
Many Thanks
April 25, 2022 at 1:10 pm
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
April 25, 2022 at 3:28 pm
The problem is that I can’t seem to find the menu this person is referring to. Can anyone else give any extra information on this? Ideally with screenshots?
The link you posted is from an MS Access forum, not SSRS!
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply