We help IT Professionals succeed at work.

Freezing Top Row and first Column in a Table

dplowman
dplowman asked
on
Trying to figure out to freeze the top row and first column in a table from scrolling in SSRS.
Comment
Watch Question

from
http://technet.microsoft.com/en-us/library/ee240753.aspx

To repeat or freeze column headings in the first row, set properties for column headers on the tablix data region. Column headers for nested column groups are automatically included.

To repeat or freeze row headings in the first column, set properties for row headers on the tablix data region. Row headers for nested row groups are automatically included

Author

Commented:
I set the fixed data property to try for teh first static row group and the first static column group. Now when I scroll to the right, the data in the daily rows are bleeding over. See attached pic.
example.bmp

Commented:
Try doing the same thing for the sub report you are calling. You can do it in the sub-report itself.

Author

Commented:
There is no sub report. I just have one table with groups and drilldown enabled. The data is grouped by associate and can be drilled down by date. As you can see, only the data in the date rows are causing the issue.

Commented:
okay, I am supposing while drill down, you are calling another report inside, aren't you?

Commented:
Just had to fill the background to white!

Author

Commented:
Figured out on own.

Explore More ContentExplore courses, solutions, and other research materials related to this topic.