Subreport Header/Footer Visibility

Just curious if in the katmai version the subreport header/footer will be avaliable as a toggle item?
[102 byte] By [kevjoh] at [2008-2-17]
# 1

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

BrianWelcker-MS at 2007-10-2 > top of Msdn Tech,SQL Server Katmai,SQL Server Katmai Reporting Services...
# 2

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. Problem now (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.

kevjoh at 2007-10-2 > top of Msdn Tech,SQL Server Katmai,SQL Server Katmai Reporting Services...
# 3

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

ChrisBaldwin-MSFT at 2007-10-2 > top of Msdn Tech,SQL Server Katmai,SQL Server Katmai Reporting Services...
# 4
Thank you Chris. You wouldn't have a fix for page numbers to get into those subreports up yoru sleeve would you?
kevjoh at 2007-10-2 > top of Msdn Tech,SQL Server Katmai,SQL Server Katmai Reporting Services...
# 5

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

ScanIAm at 2007-10-2 > top of Msdn Tech,SQL Server Katmai,SQL Server Katmai Reporting Services...
# 6

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.

TeoLachev at 2007-10-2 > top of Msdn Tech,SQL Server Katmai,SQL Server Katmai Reporting Services...
# 7

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

SriRupan at 2007-10-2 > top of Msdn Tech,SQL Server Katmai,SQL Server Katmai Reporting Services...
# 8

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

TeoLachev at 2007-10-2 > top of Msdn Tech,SQL Server Katmai,SQL Server Katmai Reporting Services...

SQL Server Katmai

Site Classified