I am using SSRS 2008. I am displaying data in a table with row groups. For each of the detail line, I want to freeze the first two columns so the users can still see them while they scroll horizontally. I could only freeze the group header, but the actual coulmn I want the freeze is in the detail line.
This is exactly what I did:
For each row group, I have deleted the group column on the left side, and I am using the group header to display the group item. - otherwise, the extra group column takes unnecesary space and doesn't look good.
Now, for the details line, I need to freeze the first three columns, but this also has to be in line with the group headers. At the bottom of the design page, you get the "Row Groups" and "Columns Groups" with (Static) groups if you select the advanced mode. I set the fixeddata property to true for all group headers(which are also static) and the first three static column groups.
Let me know if any of the above is not clear.