SSRS 2008 - Fixed headers while scrolling - works fine for Matrix - but not for Table??!!
Hi I have this feature working fine for matrix, but it does not work as expected for Table (Tablix).I tried all over, and setting both check boxes in the 'Tablix Properties' dialog page 'Repeat header rows on each page' and 'Header should remain visible while scrolling' for both row header and column header, but none of it is working. Am I missing something?In the properties table (F4) for text box of tablix, under 'Other' there is 'RepeatWith' - none / tablix: what is this used for? I tried this property also but I cannot get the headers fixed / visible while scrolling. I cannot get the 'column headers' repeat on each page of the report. Very frustrating...Does anyone face similar issue? Can anyone help please? Do I need any update / download any fix? For now I have the following version installed for Visual Studio 2k8:Microsoft SQL Server Reporting Services Designers Version 10.0.1600.22ThanksShailesh
May 12th, 2009 7:06pm

Hello,This is definitley possible, but it's a little more complicated to get it set-up right in SSRS 2008 than it was in 2005. We are going to make efforts to make this better. For now, however, please see this blog post. I think it will have everything you need to know to get this to work:http://blogs.msdn.com/robertbruckner/archive/2008/10/13/Repeat-Header-And-Visible-Fixed-Header-Table.aspxBest regards,ChrisThis posting is provided "AS IS" with no warranties, and confers no rights.
Free Windows Admin Tool Kit Click here and download it now
May 12th, 2009 10:24pm

Hi Chris,Thanks a bunch!!I followed the steps in the link and I could set up this feature.Thanks again,Shailesh
May 13th, 2009 8:39pm

thanks chris, it works...dont know its fixed by now in sql 2008
Free Windows Admin Tool Kit Click here and download it now
September 22nd, 2010 12:33pm

Hi Chris, I am having the same issue, after reading your post i have managed to solve it but not completely. Some of my reports are more complecated, i am using number of tables and on each table i am using a different stored procedur. The first table contains the header to all tabples in the current report. After the tables i have some charts. I would like to show the user the header of the first table cross all the tables (without the charts). Is it possible? Thank you Ori
January 24th, 2011 5:42am

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

Other recent topics Other recent topics