Just curious if in the katmai version the subreport header/footer will be avaliable as a toggle item?

Not a toggle, but you could hide the contents based on a parameter to the subreport.

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.

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

Thank you Chris. You wouldn't have a fix for page numbers to get into those subreports up yoru sleeve would you?

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

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.

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

Not in SSRS 2005 and it seems that this won't change in SSRS 2008. Sorry.

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.

> is there any other way around like custom code or any other.No. -- Robert

That is bullshit!

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

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.

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.