SSRS VS SQL 2008 R2, repeating col header row on each page using tablix object
SSRS SQL 2008 R2, using BIDS 2008 I have found other answers to thisTablix headers not repeating in SSRS 2008, but that fix doesn't work. All I want to do is.. use my simple tablix object, drag fields into the tablix and have the column header row repeat on each page. I have a header section in this report too. But that's it. I have selected the whole tablix object and selected the tablix properties and set repeat header rows on each page, keep header visible while scrolling and ... still doesn't repeat the header row on each page. Thanks
March 9th, 2011 6:42pm

Hi mgrocks, It's bit wierd, some times Reporting Services reports are out of control. I have done something like this. 1) Right Click on the Reports Folder and select Add new report. and type in you query. Try to run the report and see. It will solve your problem but not a convising solution but it's just like quick fix. Hopefully that works n all the bestDasari
Free Windows Admin Tool Kit Click here and download it now
March 9th, 2011 11:06pm

Since you want the column headers to be repeated, I guess you should go to properties of the tablix and then check (tick) options appearing under column headers (Repeat column headers oneach page and Keep header visible while scrolling). Note : As per your comment, you have set for header rows not or header columns. Please try and provide your feedback. Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful. BH
March 9th, 2011 11:07pm

Hi mgrocks, In order to make the column header row repeat on each page, please refer to the steps below: 1. Select the Tablix. 2. In the grouping pane, click on the small triangle and select "Advanced Mode" to show static members. 3. In the row group hierarchy, select the corresponding (static) item of the header row. 4. In the Properties grid: - set KeepWithGroup to After - set RepeatOnNewPage to True For more explanation, please refer to the MSDN blog Repeat Header / Keep Header Visible in Tables in RS 2008 at: http://blogs.msdn.com/b/robertbruckner/archive/2008/10/13/repeat-header-and-visible-fixed-header-table.aspx Thanks, Tony ChainTony Chain [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Free Windows Admin Tool Kit Click here and download it now
March 10th, 2011 2:23am

Please review the post below which talks about same issue http://gauravsqlserver.blogspot.com/2011/03/repeat-tablix-row-header-on-each-page.html Thanks, Gaurav http://gauravsqlserver.blogspot.com
March 23rd, 2011 3:37pm

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

Other recent topics Other recent topics