Subreport Headers/footers

Question

How to display the subreport Headers/footers in Main report (in SSRS SQL server 2008 r2)?

Thanks In Advance

Answer 1

Hi, You cannot display subreport Headers/footers in main report.

Instead of that what ever you would like to display as Headers/Footers , put the same information by creating a row in table/Matrix tools.

header information in a  row

subreport

Footer information in a rpw

Finally, remove Headers / footers in subreport as you are already displaying in the main report itself.

---

Maruthi... http://www.msbimaru.blogspot.com/

Answer 2

Thank You! Your response is greatly appreciated.

As per your solution, I have implemented in my report 

But now the problem is subreport content others 12 tables which render data into two pages ( PDF) and table which treated as header not repeating on second page.

Is there a solution for it...

Answer 3

Please try to enable tablix option in the main report and as well as in sub reports : Keep together in one page if possible 

---

Maruthi... http://www.msbimaru.blogspot.com/

Answer 4

Hi Esha2nk,

Per my understanding that you have add page footer and page header on the subreport, you have insert this subreport into the main report and now you want the page footer and header repeat of the subreport to repeat on each page page of the main report, right?

I have tested on my local environment and I will suggest you to add the subreport's page header and page footer on the main report's page header and footer area, then you add page break on the main report's row group, we can hide the subreport's page header and page footer is the page only display the information of the main report or the page header and footer will show.

Details information for your reference:

1. I have design an sample report as below which have add page break on the row group:
   
2. Add expression on the textbox "Subreport Page Header" if you want only the page include the subreport to display the page header and footer:
   example:
   page1:main report information
   Page2 and page3 will display subreport's information
   Expression:
   =switch(Globals!PageNumber=1,true,Globals!PageNumber=2 or Globals!PageNumber=3,false)
3. Preview like below:
   

If you still have any problem, please feel free to ask.

Regards,
Vicky Liu

---

Vicky Liu
TechNet Community Support