I got a request from a user to freeze a column in a report, just like in XL. This is because users are so used to XL reports they expect such features from other reporting systems.
Thanks toy RS2005 its just a click away to freeze a column in a matrix report.
Select the column you want to freeze and select edit group.
Then in the property window select option group header should be remain visible while scrolling.
That’s all. We are done.