Geek Answers Handbook

Report group headings that do not repeat on every page

I have an RDLC report with three tables and corresponding datasets. In my second table, I cannot get two header lines to repeat on every printed page. When viewed in interactive mode, each table is on its own page, and this is not a problem. When I switch to print layout, for example. my second table now spans two pages, and the second page does not contain header lines.

Am I missing settings or something else?

ADDED: I have the checkboxes "Repeat column headings on each page."

+7
reporting-services
source share
4 answers

http://vbcity.com/blogs/xtab/archive/2010/06/14/what-to-do-when-the-repeatcolumnheaders-property-in-a-tablix-isn-t-working.aspx

This should help you repeat their repetition. (in some cases)

I still have a problem when I set a hidden value to an expression for the next group title, which will not display my group title on the next page for a while. Very annoying. If anyone knows about this, let me know.

+15
source share

Copied from a Microsoft Technet article . Helped me:

To display a static tablix element (row or column) on multiple pages.

  • On the design surface, click a row or column in the tablix data area to select it. The Grouping panel displays row and column groups.

  • On the right side of the Grouping panel, click the down arrow and select Advanced Mode. The Row Groups panel displays the hierarchical static and dynamic elements of the row group hierarchy, while the Row Groups panel displays a similar screen for the column group hierarchy.

  • Click the static member that corresponds to the static member (row or column) that you want to remain visible while scrolling. The Properties panel displays the properties of the Tablix element.

  • In the Properties panel, set RepeatOnNewPage to True.

  • Repeat this for the number of adjacent elements you want to repeat.

+10
source share

Did you check "Repeat header lines on each page" in the table properties?

(Right click on table> properties)

+1
source share

See link below for the perfect solution.

http://msdn.microsoft.com/en-us/library/cc627566(v=sql.100).aspx

0
source share

More articles:


All Articles