Subreport's page headers missing in main report, SSRS

Question

Hi,

I have a SSRS report having 3 tables, one after the other, showing data from 3 different datasets. All in one RDL now. But now i realized that i need 3 page headers depends up on the table and the dataset in each page's result. Is there any possibility to do so?

i tried creating the there tables as three different rdl with its own page headers. and call those reports as subreports in the main report. the subreports shows the page headers on its own execution but when executed the main report the page headers are missing. Any idea here. is that a right way to get different page headers in to a single report.

your help would be really appreciated.

Thanks, San

Answer 1

This is a pretty well-known limitation of SSRS since 2000.

More here: http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/ba15e779-1de5-4c84-9d14-5739417c0258

and here: http://www.windows-tech.info/15/ddb42d342ca4bda8.php

One solution we are investigating is rendering each report individually as pdfs and then using a custom .net class, outside of SSRS, to programatically combine the pdfs.

Answer 2

I hate to sound like a sales person, but the company I work for has a product that will allow you to do this. It's basically an integration of Excel and Word with SSRS, so you can design your report in Excel or Word including your specific header. You can find more information here: http://officewriter.softartisans.com/default.aspx?pageid=250