Wednesday, February 13, 2013 12:43 PM
I have 3 Table Headers in my SSRS Report.I need to display second Table header only in first Page and First and Third Table header on Every Page.Can you Please advise me.
- Edited by vitthal bhovi Wednesday, February 13, 2013 12:47 PM
Wednesday, February 13, 2013 12:50 PM
Set the below table properties
Set repeat Column header property for table1 and table3 as True
Set repeat Column header property for table2 as False
Wednesday, February 13, 2013 1:04 PM
Unfortunatelly, global variables can be used only in the page header and footer. So you can not use pageNumber in table header hide expression. You can add 3 table header text in the report header and use below expression.
=IIF(Globals!PageNumber=2, false, true)Thanks, Rana
- Edited by Rana_Hasan Wednesday, February 13, 2013 1:05 PM
Wednesday, February 13, 2013 1:10 PMI have One report Table(Tablix) with 3 headers.I guess we have to set repeat Column header =true or false for all 3 table headers or else it will give error.
- Edited by vitthal bhovi Wednesday, February 13, 2013 1:26 PM
Wednesday, February 13, 2013 1:24 PMHi Vitthal, Please go through the below link http://www.sqlchick.com/entries/2011/8/20/repeating-column-headers-on-every-page-in-ssrs-doesnt-work-o.html
Thursday, February 14, 2013 7:08 AMModerator
From your description, there are three columns in your report table, and you want to set the first and the third column header repeat on each page, and the second column header only show on the second page, right? In Reporting Services, when we set the table header repeat on each page, the table header was as a whole, we cannot set some items of the table header to repeat on each page. So I am afraid your requirement cannot be achieved.
Thank you for your understanding.
If you have any feedback on our support, please click here.
TechNet Community Support
- Marked As Answer by Charlie LiaoMicrosoft Contingent Staff, Moderator Monday, February 25, 2013 1:19 AM