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]
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.
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.
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.
November 7th, 2012 7:39am