CODEWITHSUNDEEP
visual-studioreporting-servicesssrs-tablixrdl
Laura Bryngelson
Laura Bryngelson

Reputation: 131

Reporting Services tablix will not allow me to freeze column header AND Rows

Trying to modify an existing rdl RS report in Visual Studio 2017. It currently freezes the column header when scrolling down, but when I try freeze the four left-most columns so they will stay in view when scrolling right, I get an error that the report definition is invalid. We've successfully done this on another report, and as far as I can tell, the basic setup between the two reports is the same. The only difference I can see is that the report that works doesn't have any grouping on it. Is that the culprit? (I just started a new job... I will be more specific in details once I actually get my own system/logins/etc - it would seem that Higher Ed works a leeeetle more slowly that K-12! - I just wanted to see if there was a quick yes/no answer out there! PS: a "veteran" already gave up on this, so it would be super awesome to fix this as a noob in my new position! ;-))

Upvotes: 3

Views: 5789

Answers (2)

Joseph Macharia
Joseph Macharia

Reputation: 11

For tablix properties Remove the "Keep header visible while scrolling" then static group make Fixed Data True. That worked for me

Upvotes: 0

Laura Bryngelson
Laura Bryngelson

Reputation: 131

Figured it out! Removed the "Keep header visible while scrolling" from the Tablix properties. Then changed FixedData to True for the Static Column Groups (Advanced mode). Tested, the column (first name) was frozen. Then in Row Groups, changed FixedData to True for my static header record. Tested. First Name column was frozen, and my headers stayed visible when scrolling H or V. So the Tablix "Keep header visible while scrolling" property was what was gumming up the works.

Upvotes: 7

Related Questions