headerreporting-servicesssrs-2008ssrs-tablix
I have a report made up of 2 tablix.
The first tablix just has some basic information in it, and is linked to a dataset.
The second tablix is linked to a different dataset and is made up of a lot of rows and spans multiple pages.
All I am looking to do is have the first tablix be displayed at the top of every page.
I cant add it to a header because you can't add a tablix containing data to a header.
I also don't want to just repeat column headers, because I need the entire tablix repeated.
It depends on the tablix structure you are using. In a table, for example, you do not have column groups, so Reporting Services does not recognize which textboxes are the column headers and setting RepeatColumnHeaders property to True doesn't work.
Instead, you need to:
RepeatOnNewPage property to True.
KeepWithGroup property is set to After.The KeepWithGroup property specifies which group to which the static member needs to stick. If set to After then the static member sticks with the group after it, or below it, acting as a group header. If set to Before, then the static member sticks with the group before, or above it, acting as a group footer. If set to None, Reporting Services decides where to put the static member.
Now when you view the report, the column headers repeat on each page of the tablix.
This video shows how to set it exactly as the answer described.
To repeat rows with column headings for a table with row groups
In Design view, select the table. The Grouping pane displays the row groups.
On right side of the Grouping pane, click the down arrow, and then click Advanced. The Grouping pane displays static and dynamic tablix members for each group. You can only set properties on a static tablix member.
In the Row Groups pane, click the static tablix member for the row that you want to repeat. When you select a static tablix member, the corresponding cell on the design surface is selected, if there is one. The Properties pane displays the properties for the selected tablix member.
Best Answer
Depending on how your Tablix is set up you could do the following:
• Select Tablix Properties and check column Headers > Repeat Header columns on each page In the grouping pane in advanced mode (click on small black down arrow on far right of grouping pane); select the corresponding (static) item in the row group hierarchy. • In the properties grid, set RepeatOnNewPage to true and Keep with Group to After