I'm using Reporting Services 2008 and Report Builder 2.0. I've used a tablix to display my data in a simple way - essentially each row in the database receives a row in the tablix - nothing fancy. I have a header row with a name for each column. I also have a super-header which groups together a few of the columns into logical groups (e.g. basics, address related, etc.). Now when I generate the report everything looks beautiful - but if I page to the next page it doesn't show the headers. I've tried setting the Repeat Header Rows on Each Page but it doesn't seem to help?
3 Answers
1
votes
1
votes
In the Tablix properties check the boxes for: Repeat header rows on each page and Keep header visible while scrolling.
Make sure that the column headers check boxes are NOT checked.
In the Group pane on the left (Row Groups), the first line is static. Set the following for this first static only
set its: "ReapetOnNewPage" property to TRUE set its: "FixedData" property to TRUE set its: "KeepWithGroup" property to AFTER
It will work surely!
Source : Answer by ambk on this MSDN