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 7:35pm
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 7:47pm
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 19th, 2009 1:28am
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 19th, 2009 5:32am
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 19th, 2009 5:56am
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 7:04pm
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 10:59pm
PDF to EPUB Converter ,
PDF to EPUB Converter for Mac ,
PDF File Transfer ,
Transfer PDF to iPhone 3G ,
PDF Ripper ,
Convert PDF to Image ,
Convert PDF to BMP ,
Convert PDF to Tiff ,
Convert PDF to Office ,
Convert PDF to Excel ,
Convert PDF to Word ,
Convert PDF to Doc ,
Convert PDF to TXT ,
Convert PDF to Text ,
Convert PDF to RTF ,
Convert PDF to Powerpoint
Free Windows Admin Tool Kit Click here and download it now
November 11th, 2010 3:41am