Keep SSRS report row groups visible while horizontal scroling

1
votes

I have made SSRS drilldown report. I added row groups, so I can toggle visibility of the row group. But my report also have large number of columns, so I want to freeze first 3 columns of the report for horizontal scrolling. I know I can do this with fixed data property of the column group, but this first 3 columns in the table are row group columns, so I don't know is it possible to make them fixed while horizontal scrolling.

1
sqlreporting-services
possible duplicate of SSRS 2008 Fixing the Row Header – Paolo
I don't want to fix row header, I want to fix first 3 columns, with their header and data, for right-left scrolling, but that columns does not belongs to column groups, but in row groups, so I can not set fixed data to true. – vldmrrdjcc

1 Answers

1
votes

Well, I have found an answer: here:

"1. Right-click the gray handle above the row group name, then select “Tablix Properties”. 2. Check “Header should remain visible while scrolling” in the Row Headers pane.

After complete the steps above, we find that the row group remains on left side of screen when we scroll horizontally.

Note: If Month-Year row group is put before the SalesDate row group, the Month-Year group will freeze with SalesDate together. "