Freeze Panes in Reports

Question

Freeze Panes in Reports

April 5, 2022 at 7:11 am

This was removed by the editor as SPAM

Viewing 4 posts - 16 through 18 (of 18 total)

You must be logged in to reply to this topic. Login to reply

sgmunson SSC Guru Points: 110640 More actions · Answer 1

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) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)

Jeff Moden SSC Guru Points: 1004323 More actions · Answer 2

sgmunson - Friday, March 15, 2019 11:33 AM
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.

Awesome!

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

RonMexico Hall of Fame Points: 3474 More actions · Answer 3

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.