Freeze column headers in browser while scrolling
I am trying to freeze all column headers in a report when scrolling down. I have read numerous articles about how to go to Advanced Mode, select the header and set FixedData to True, KeepWithGroup to After, RepeatOnNewPage to True. That works when previewing a report, but it does not work in a browser. I have tried using IE 11, Chrome, and other browsers, but none of them fix the column headers while scrolling.
I have spent hours trying to get this to work and have read articles such as: Freeze column header while scrolling and Freezing column headers while scrolling in SSRS, but none of them accomplish this in a browser.
I tried creating a simple table report from the report wizard and following these instructions, but it still does not work. This is very critical to get working in order to use SSRS. I am using SSRS 2012. Any help would be greatly appreciated.
Answer
It's crucial to select the correct "Static" member before setting those properties. For your scenario I think you want the Static member within the Row Groups list.
If there are several "Static" members, select them in turn and note where the selection box moves to in your tablix - this can help pick the right one - usually the last.
My favourite post on this is from Robert B:
Good luck - this is still such an unbeleivable mess after 5 years and 3 releases ...