I have a SSRS report with 2 Tablix in it, I used a page break property to export the data into 2 different tabs in excel itβs works fine, After exporting the report into excel I need to see 2 different headers in 2 tabs?
1
votes
Can you just add a row above each tablix with your header info in it?
β Bostaevski
Thank you for the reply, the requirement is to show the heading in the report header only
β Narendra
The way I might try it would be to remove the page header altogether and create "fake" page headers in the top rows of each tablix.
β Bostaevski
1 Answers
1
votes
In the header section you can use a placeholder and set the contents dynamically using an expression. Following expression should get the desired result:
=IIF(Globals!PageNumber=1,"Heading1","Heading2")
Taking into consideration you are using excel export you will most likely have only two pages so the above code should work.