CODEWITHSUNDEEP
reporting-servicesssrs-2008
Dannydust
Dannydust

Reputation: 773

SSRS 2008: Tablix header in Subreport not repeating

enter image description hereI have a subreport which is usually bigger than one page. The subreport has a heading which should repeat if the subreport is more than one page.

My solution was creating a Tablix Control and put the heading in the first row. In the details row I put the subreport.

First I tried to check Repeat header rows on each page in the Tablix properties to achieve the repeating header, but with no success.

After some research on the internet I found an approach that was already in discussion on stackoverflow and many other sites.

It's about using the "Advanced Mode" but this approach does not work for me either

Here is the link to the second approach on stackoverflow: Stackoverflow Solution

Helps very appreciated...

Upvotes: 5

Views: 5269

Answers (2)

Sobhan
Sobhan

Reputation: 816

I searched in many articles and found that the problem exists in BIDS 2008. Later Microsoft released a fix regarding this.

But, the report designed earlier won't repeat the header. It needs to be redesigned from the beginning

Upvotes: -1

Christopher M. Brown
Christopher M. Brown

Reputation: 2210

There are two solutions that should work:

The Simplest

Open your subreport and move the header row into a textbox in the header of the subreport

Slightly more Complicated

  1. Enter the Advanced Mode for the tablix containing the header row.
  2. Click on the "(Static)" row that is your header row; it's probably the first/top "(Static)" row.
  3. In the properties panel, you should see the row identified as "Tablix Member". If it says textbox1 or nothing at all then you need to repeat step 2.
  4. Change Keep with Group property to "After".
  5. Make sure Repeat on New Page to "True"

That should do it!

Upvotes: 3

Related Questions