Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

rdlc report in vs2010, how do i repeat column header on every page?

How do I repeat column header (captions) in RDLC reports?

It says here http://msdn.microsoft.com/EN-US/library/735D1EE7-3C89-46D8-A346-504DB10F33E1.aspx#TableNoGroups:

To repeat or freeze column headings for the tablix member, select the static row that is labeled (Static). The properties pane displays the properties for the selected tablix member. By setting properties for this tablix member, you can control how the first row repeats or stays in view.

However I've tried turning "RepeatOnNewPage" and "FixedData" on and off, and nothing happened (the column header still showed up only in first page). I'm using VS2010, thanks!

like image 661
deerchao Avatar asked Aug 11 '10 10:08

deerchao


People also ask

How do I repeat the header on each page in Rdlc?

Right-click the column or corner handle of a tablix data region, and then click Tablix Properties. In Column Headers, select Repeat header columns on each page.

How do I get the header to show on all pages in SSRS?

To display row headers on multiple pagesRight-click the row, column, or corner handle of a tablix data region, and then click Tablix Properties. In Row Headers, select Repeat header rows on each page. Select OK.


1 Answers

I just had this same problem and found that you likely need to go a bit further from the standard properties (right-side dialog) into the Advance properties.

After selecting your Tablix, there should be a frame at the bottom showing Row Groups and Column Groups, with an arrow at the far right. Click the arrow and select advanced mode.

Now, the RowGroups section should show (Static) and (Details1), maybe more depending upon your Tablix. Select the static row and in the right-side properties window, there will be an option to RepeatOnNewPage.

After I did this, my column headers displayed as I expected.

Good Luck!

like image 127
KDrewiske Avatar answered Sep 17 '22 09:09

KDrewiske