ssrs - repeat tablix at top of every page

reporting-services header ssrs-2008 ssrs-tablix
Luke K. picture Luke K. · Oct 21, 2013 · Viewed 9.8k times · Source

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.

Answer

bombus1700 picture bombus1700 · Oct 22, 2013

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

Related questions

The permissions granted to user ' are insufficient for performing this operation. (rsAccessDenied)"}

I created a report model using SSRS (2005) and published to the local server. But when I tried to run the report for the model I published using report builder I get the following error. Report execution error:The permissions granted …

Read More
How do I format date and time on ssrs report?

on SSRS report I need to show todays date and current time i tried this =FormatDateTime(Now,"MM/dd/yyyy hh:mm tt") but this is not working for me giving an error. Anyone please help me for expression ? I …

Read More
SQL variable to hold list of integers

I'm trying to debug someone else's SQL reports and have placed the underlying reports query into a query windows of SQL 2012. One of the parameters the report asks for is a list of integers. This is achieved on the report …

Read More