Subreport Header/Footer Visibility
Just curious if in the katmai version the subreport header/footer will be avaliable as a toggle item?
August 16th, 2007 8:14pm

Not a toggle, but you could hide the contents based on a parameter to the subreport.
Free Windows Admin Tool Kit Click here and download it now
August 16th, 2007 9:47pm

Thanks Brian. I'm actually more interested in keeping the header/footer of the subreports. I find myself with many multipage reports that I put as subreports for a single instance of one master report. Problemnow (rs2005) is the header/footer gets stripped from the subreports which elminates an easy way of keeping titles and page counts for each of the individual reports.
August 17th, 2007 6:44pm

Hello, This is not something that was changed in SQL 2008. Only the body from Subreports is shown, not headers and footers. Best regards, Chris
Free Windows Admin Tool Kit Click here and download it now
August 17th, 2007 9:30pm

Thank you Chris. You wouldn't have a fix for page numbers to get into those subreports up yoru sleeve would you?
August 17th, 2007 11:09pm

So what is the solution for this? Currently, lets say I have 2 documents, each one showing their separate page counts. How do I get reportserver to display those documents in a single 'report' such that each document has the correct page counts? Asking the user to print out 2 separate documents is not very user friendly
Free Windows Admin Tool Kit Click here and download it now
August 27th, 2007 10:06pm

Assuming you need a continuous page count, you can add both reports as subreports of a master report and add the page count to the master footer.
August 27th, 2007 11:25pm

Good to know atleast continuous page numbering is available. But my situation is that the individual subreports need separate page numbers. Is there a work around? Sri
Free Windows Admin Tool Kit Click here and download it now
August 30th, 2007 5:07pm

Not in SSRS 2005 and it seems that this won't change in SSRS 2008. Sorry.
August 30th, 2007 5:11pm

i agree there is no direct way to display the footer of subreport but is there any other way around like custom code or any other.
Free Windows Admin Tool Kit Click here and download it now
November 21st, 2007 2:13pm

> is there any other way around like custom code or any other.No. -- Robert
November 21st, 2007 8:51pm

That is bullshit!
Free Windows Admin Tool Kit Click here and download it now
January 26th, 2008 8:49pm

I had a similar issue in that I would have liked to have the name of the report, which was in the Page Header, show when it was grouped together with other subreports on another report. Here is what I did... For each subreport... Insert a Group under the Table Header and make the Group By expression = ExecutionTime or Today In the Layout properties of that Group set "RepeatOnNewPage" = True Move Column headers down to that new Group Insert the regular information you would have in your Page Header into the now blank Header row of the table Voila - the report will behave like a regularreport even when it is embedded as a subreport in another report. There are some limitations in formatting, but it works The same could be done i would imagine for Table Footer of the report... the only issue might be consistency of Page Numbers, but for my purpose where I needed to repeat the Report Header information inside the subreport, this worked perfectly. Then I can have the Page numbering in the footer of the master report, and get a complete page number count, while still displaying the header information of the subreport
November 11th, 2008 11:20pm

This is a very serious shortcoming in the product IMO. Batching and chaining reports are pretty basic business concepts, but there seem to be no provision for it.
Free Windows Admin Tool Kit Click here and download it now
October 27th, 2011 9:39am

I am having this same problem even as we speak. It is most frustrating because the Microsoft Reporting Services documentation explicitly states that a report that is imbedded as a subreport will display the same way as if viewing it alone. To me, that implies headers and footers are carried to the subreport, which apparently is not the case. Now I have to do a major rethinking of my report project. I don't know if Reporting Services 2010 (Report Builder 3.0) has the same shortcoming.
December 19th, 2011 1:08pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics