Freeze Panes in Reports

  • sgmunson

    SSC Guru

    Points: 110411

    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

  • Jeff Moden

    SSC Guru

    Points: 993401

    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.
    "If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
    "Change is inevitable... change for the better is not."
    When you put the right degree of spin on it, the number 3|8 is also a glyph that describes the nature of a DBAs job. 😉

    Helpful Links:
    How to post code problems

  • RonMexico

    SSCrazy

    Points: 2963

    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.

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

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