data Expression in Page header

Question

data Expression in Page header

Viewing 5 posts - 16 through 19 (of 19 total)

You must be logged in to reply to this topic. Login to reply

Daniel Bowlin SSC-Dedicated Points: 34566 More actions · Answer 1

You only see the static rows when you are in the Advanced mode. On the top of the Group Pane on the far right side is a little drop down arrow. Click that drop down arrow and choose Advanced Mode.

ramadesai108 SSChampion Points: 10609 More actions · Answer 2

Hi Daniel,

Who would help so much as you have? Very few. Thanks for keeping at it until I understood exactly how to accomplish the header to print on each page. I learned a lot from you. I tried selecting Advanced mode and then turning on RepeatOnNewPage for the static row, but my report does not have any static column headers. It is not the column headers that I need to repeat, but it is the tablix header I need to repeat on each page. In the preview it shows only 2 pages and both have tablix header, but when i export to PDF, the PDF shows 3 pages and the last page does not have the heading. I think it is a known issue.

Thanks again for all your time.

ramadesai108 SSChampion Points: 10609 More actions · Answer 3

Daniel,

Please read my previous posting and view the attached bmp, which will give you some idea on my report. The area that i have circled in Red is what i am trying to repeat.

Thanks.

Daniel Bowlin SSC-Dedicated Points: 34566 More actions · Answer 4

You probably have to make the RepeatOnNewPage = true setting and the KeepWithGroup = After setting for each of those rows in the grouping pane below. However, there is a known bug in all versions of SSRS 2008 where the repeating row groups do not always work as expected.

You might alwo want to check the Repeat header rows on each page in the Tablix properties. Image attached.

ramadesai108 SSChampion Points: 10609 More actions · Answer 5

Repeat header rows is already checked on. I also tried turning on repeatOnEachPage with KeepWithGroup = After, but it is not going to work. Thanks for spending time on this.