SSRS 2008: How to repeat on new page one row of table header

Question

I have table with 3 rows of header, and I needed repeat on new page only second row, first and third is not needed in the pages, excepts first page. If I set the properies "RepeatOnNewPage" in the second row only, SSRS show the error: "The TablixMember must have the same value set for the RepeatOnNewPage property as those following or preceding the dynamic TablixMember"

If I set this property in the all (3) rows of header - all ok, but I need only one :)

How to repeat only second row on new page?

No, this is not good variant for my report - table is very complicated, and split a header it will be difficult — ABarto, Sep 29 '11 at 11:56

score 14 · Answer 1 · answered Jul 18 '12 at 13:30

14

I am not sure why, but this seemed to work for me. For your 3 header rows advanced properties,

(Static) KeepTogether= false, KeepWithGroup=None, RepeatOnNewPage= TRUE
(Static the one you want) KeepTogether= True, KeepWithGroup=After, RepeatOnNewPage= TRUE
(Static) KeepTogether= false, KeepWithGroup=None, RepeatOnNewPage= TRUE

When i tried this with the top and bottom rows repeat on new page False it gave me the error you described. I changed these to true just to try. I expected them to Repeat on new page but they didnt. My first page had all 3 and the rest just had the middle.

Hope this works for you!

answered Jul 18 '12 at 13:30

Aheinlein

480
2
7
19

2

This comment saved my life today :) – Master_T Jan 21 '16 at 19:49
Great example!! – joetinger May 14 '20 at 02:05
I have two headers, I want to show first header on every page but not the second one, second one should only be on first page, any help regard this? – M A K Aug 17 '20 at 08:18

score 3 · Answer 2 · edited May 21 '18 at 07:19

3

Go at Column Groups
Click on the black arrow at the last
Select advanced mode.
Go at "Row Group"..
In row group you will get LOTS of "static", out of which just select TOP MOST
Go to properties

A. For VS: press F4

B. For report builder... View->Properties
In that select for row headers

a. Fixed Data: True

b. Keepwithgroup: After

c. Repeatonpage: True...

And for main headers

a. Fixed Data: True

b. Keepwithgroup: Before

c. Repeatonpage: True

edited May 21 '18 at 07:19

kvantour

25,269
4
47
72

answered Jul 14 '16 at 10:49

Dhananjaya

39
1

Thanks for "click on the little arrow by Column Groups", never would have found that – codeulike Oct 14 '19 at 14:40

score 1 · Answer 3 · answered Jul 20 '16 at 06:49

Set property RepeatOnNewPage = True for all rows of table. Select static row from Row Groups window.

You must have to set RepeatOnNewPage property for all static rows.

If any static row is not set RepeatOnNewPage property than it dosen't work and give error.

score 0 · Answer 4 · answered Apr 25 '14 at 19:20

So just to help clarify the answer based on success from working on my table. When I did the above action on the top-most static row, I got an error message. My table has three headers that are grouped and all need to be included in the repeatOnNewPage function. In order to successfully run my report, needed to repeat the step for all the static row headers.

Static (for each row): FixedData = True, Keepwithgroup = After, and RepeatOnNewPage = True

I also went into Tablix properties and checked both boxes under Row Headers for Repeat header rows on each page & Keep header visible while scrolling.

It was a very happy moment when i did not receive an error message after completing this scenario. good luck.

not working for me... could you please suggest other option? — Pedram, Feb 09 '16 at 06:11

SSRS 2008: How to repeat on new page one row of table header

4 Answers4

Linked