CODEWITHSUNDEEP
sqlreporting-services
vldmrrdjcc
vldmrrdjcc

Reputation: 2112

Keep SSRS report row groups visible while horizontal scroling

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.

Upvotes: 1

Views: 3279

Answers (1)

vldmrrdjcc
vldmrrdjcc

Reputation: 2112

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. "

Upvotes: 1

Related Questions