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?

Answer 1

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!