I know this is 10 years old, but a quick update is in order. The solution to having Excel have any frozen panes, is somehow involved in the use of a Matrix, and not a tablix. While you can have the display in SSRS have fixed header rows, that just doesn't make it into Excel when exported. I've tried mightily with every solution out there on the web today, and all for naught. A relatively recent assignment of mine required a matrix with a column group, and that actually worked. Nothing I've ever tried either before or after has ever worked in Excel, and I'm talking for at least the past 10 years... fyi in case you are banging your head against a wall like I did today.
Steve (aka sgmunson) 🙂 🙂 🙂
Health & Nutrition
Rent Servers for Income (picks and shovels strategy)
sgmunson - Friday, March 15, 2019 11:33 AM
Change is inevitable... Change for the better is not.
Hall of Fame
Steve - Are you saying you were able to add fixed header rows after exporting to Excel by using a matrix or are you saying you were able to freeze other panes by using a matrix? I'm trying to do both but need to start with the fixed header rows. The only thing I've been able to do is create text boxes in the header of the report which match the tablix header names and then delete the tablix header. It works but makes me worry about the amount of maintenance if the layout needs to change.
This was removed by the editor as SPAM
Viewing 4 posts - 16 through 18 (of 18 total)