Problems getting header row to stay visible (SQL2008R2, Report Builder 3, up to date)
Our report is a very, very simple one. The data set is from SQL2008R2 and is a single table. The report was built using the Table wizard. The report is basic information about each store. So store name, address, city, state, zip, manager, etc. make up each column. Each store is on its own row. In the Arrange fields section of the wizard I simply put the StoreName in the Row groups. Then all of the information I just dropped into Values. This generated the report just fine. In the Tablix properties I'm able to keep the row headers (store name) locked as you scroll left and right. However, the column headers will not lock in place. I have set the option in the Tablix propertiesI have enabled Advanced Mode and then gone into the (Static) properties and set RepeatOnNewPage to True. I've tried all mixes of having Fixed Data set to True or not and Keep with group being set to None Before and After. Nothing seems to make a difference there. If I need to build my table differently, I can do that. We just need to make sure that the far left column and the top headers are locked in place as people scroll left and right and up and down.
June 21st, 2012 6:20pm

Hi There Please have a look on this blog that might help you http://blogs.msdn.com/b/robertbruckner/archive/2008/10/13/repeat-header-and-visible-fixed-header-table.aspx http://www.bidn.com/blogs/hardikabhavsar/bidn-blog/1638/keep-column-headers-visible-while-scrolling-in-ssrs-2008 Many thanks Syed
Free Windows Admin Tool Kit Click here and download it now
June 21st, 2012 6:42pm

Thanks for the suggestion but I already looked at that blog entry and many that are very similar (and the MSDN article http://msdn.microsoft.com/en-us/library/cc281227%28SQL.105%29.aspx). In my original post I noted that I enabled Advanced Mode and went to the (Static) properties and set RepeatOnNewPage to True along with every other combination -- including the ones in that blog entry. However, just to make sure, I did go back and confirm that I tried those specific settings and they did not work. However, I was able to make it work 1) Row Headers were already scrolling, so in the Tablix Properties I left "Keep header visible while scrolling" for Row Headers. 2) I had to uncheck Keep header visible while scrolling for Column headers, even though I wanted to keep them visible. If you leave that option on and do everything else here then you get an error "The tablix 'Tablix1' has an incorrectly set FixedHeader property on the opposite hierarchy, based on the property FixedColumnHeaders of tablix. 3) The blog you posted, the MSDN article, etc. all say to select the (Static) row group and set Fixed Data to true and other options, etc. etc. I chose the top Static and it worked. So again, Static but not (Static). 4) For the advanced properties of the Static group I set FixedData to True and nothing else. KeepTogether and Repeatonnewpage are both false, toggling them does nothing. KeepWithGroup is set to None, but changing it to anything else doesn't change anything.
June 21st, 2012 7:23pm

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

Other recent topics Other recent topics