Thursday, February 18, 2016

Repeat Column Header In Every Page of ReportViewer

Step by step tutorial of repeating column header in correct way.
Repeating column header in ReportViewer is very easy. But most beginner will find it very confused because they setting in Tablix property : "Repeat header row in each page" or "Repeat header column in each page", which is not correct.


You wondered why? Because the meaning of "header rows/columns" in tablix property is not what you expected (see more at https://msdn.microsoft.com/en-us/library/cc281227.aspx).

The correct steps to repeat header column on each page is as follows,

1On column groups, click arrow icon and enable “Advanced mode”

2Click on “static” row that make visal studio highlight leftmost column

3Press F4 to open the property pane, then select “RepeatOnNewPage”=“true” and “KeepWithGroup”=“After”

4If you have many header row, make sure you repeat step 2-3 in every header row

5Try running your report, you will see that the header is repeat in every page like this



Happy Coding!

1 comment:

  1. Thanks a lot
    Many forums says how to, but with a mistake in the way of explain.
    The trick is select rows group for column headers.
    Your post very helpful.

    ReplyDelete