How to repeat table's header rows on each page in Reportviewer11 with Visual Studio 2010

Question

I am trying to create some reports on ReportViewer 11 with VisualStudio2010. And I want to repeat table header in each page in export execl. I Set “RepeatOnNewPage” to “True” and “KeepWithGroup” to “After” in Row Groups list. But it still not work.

Thanks

Answer 1

This is most probably a result of not using the default header that comes with the table, but instead adding a row outside the detail group and use it as your header.

Unfortunatly I have not found a way to declar a row as the table header using the designer, the only working option that I have found so far for the RDLC report is via the XML editor as follows:

1. Open up the the RDLC file in the xml editor (right click on the file in VS and select "Open With.." and then "XML Editor")

2. Search for the entry <Tablix Name="your table name"> (if you have only one table you can emit this step)

3. Search for the entry (before the closing </tablix> for the table)
   <TablixRowHierarchy>
  <TablixMembers>

4. In the first <TablixMember> node (if your headers are on the first row in the table) add the following entry "<RepeatOnNewPage>true</RepeatOnNewPage>", so the entry will generally look like this:

   <TablixMember>
   <KeepWithGroup>After</KeepWithGroup>
   <RepeatOnNewPage>true</RepeatOnNewPage>
   <KeepTogether>true</KeepTogether>
</TablixMember>

Answer 2

click on the black upside down triangle to the left of the column groups and go to Advance Mode

you have to change some of the values for static rows:

1)      FixedData        True
2)      KeepTogether     True
3)      KeepWithGroup    After
4)      RepeatOnNewPage  True

ok now you may need to read a little more details

link 1 link 2 last link

all the above links solve this issue the same way