How to Freeze page header SSRS 2008
Hi All, Can someone tell me how to repeat page header on each page, i am using SSRS 2008. Thanks in advance.
November 17th, 2009 11:35am

for SSRS 2008, If a report with a table is created using the wizard feature (In Solution Explorer, right click on Reports --> Add New Report) Table Headers will repeat on every page.Instead if a report is created without using the wizard (In Solution Explorer, right click on Reports --> Add --> New Item) Table Headers will not repeat on every page. Setting Repeat Header (Rows/Columns) on each Page for the Tablix will not help either. If you have already built the report and cannot rebuild using the steps above and if and only if you are comfortable altering the xml behind the rdl, do the following. (Save a Backup rdl first)View Code.Look for TablixRowHierarchyBelow that there will be a TablixMember that corresponds to the header row.to that header and any other header rows ( Tablix Member) add the three element properties.KeepWithGroup After /KeepWithGroupRepeatOnNewPage true /RepeatOnNewPageKeepTogether true /KeepTogetherYou should see the header rows repeating. Balaji Baskar [Please mark the post as answer if it answers your question]
Free Windows Admin Tool Kit Click here and download it now
November 17th, 2009 11:47am

Hi Balaji,Sorry my question was wrong, I can see page header oneeach page,i want to freeze the page header while scrolling up and down.I am using SSRS 2008.Thanks in advance
November 18th, 2009 5:28pm

The following blog posting may help: http://blogs.msdn.com/robertbruckner/archive/2008/10/13/Repeat-Header-And-Visible-Fixed-Header-Table.aspxHTH,RobertRobert Bruckner http://blogs.msdn.com/robertbruckner This posting is provided "AS IS" with no warranties, and confers no rights.
Free Windows Admin Tool Kit Click here and download it now
November 18th, 2009 9:32pm

Hi,If the items on your report page header can be embeded into the data region(Table, Matrix...)'s cells(can addonw additionalrows for the data region), it will be possible because only the static memberon the reportcan set to being freezed while scrolling up and down. For static members, click on the small triangle and select "Advanced Mode" to show static members in the grouping pane, select the corresponding(static) item in the row group hierarchy and set FixedData to true and RepeatOnNewPage to true in the Properties grid.Hope it helps,thanks,Jerry
November 18th, 2009 9:56pm

Hi Jerry, Thans for your response, i have lots of data in page header i have8 text boxes and a image in the page header, is it not possible to freeze the page header? Thanks.
Free Windows Admin Tool Kit Click here and download it now
November 19th, 2009 11:04am

Freezing the page header is not supported. You can only freeze the header of data regions in the report body.HTH,RobertRobert Bruckner http://blogs.msdn.com/robertbruckner This posting is provided "AS IS" with no warranties, and confers no rights.
November 19th, 2009 2:59pm

Hi Robert, Thanks for the link. It is exactly what i am looking for. Many Thanks, PVSAVSG.Thanks, PVSAVSG.
Free Windows Admin Tool Kit Click here and download it now
November 7th, 2012 7:39am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics