Keep Column Headers Visible in SSRS

  • Comments posted to this topic are about the item Keep Column Headers Visible in SSRS

  • I don't use SSRS but the question of headers does come frequently on these forums.  Now I've got a great place to point them to.  Well done.

    --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)
    Intro to Tally Tables and Functions

  • That's it!  This has never been a critical issue so I never investigated it but I've always been curious why headers disappear despite having "Keep header visible while scrolling" checked.  I saw the article and had to look at it.  Great screenshots and thanks for getting right to the point.  Because it was so clear, I went right into an existing report, tried your settings and for the first time since I've been using SSRS my headers are staying in place.  Thanks for sharing!

  • Excellent article, thank you!

  • Appreciate you pointing out the correct way to do this Ginger. My users also thank you.

    Curious what the 'keep header visible while scrolling' row and column checkboxes are for. Since they don't do what they seem they're supposed to do, what do they actually do?

    Tablix properties > General > Row Headers/Column Headers

  • Freezing the header of a table is simple for the online version of an SSRS report, but freezing the header of a spreadsheet exported from an SSRS report appears to be impossible.

    I have tried all the alleged solutions I have found, but none of them have worked.

    Does anybody know how to do it?

  • Excellent post, thank you.

    Another tip about this is that you might have to change the background color of the header or it will be transparent, making the words appear on top of each other in the header when scrolling.

    The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge. - Stephen Hawking

  • Brad Smith wrote:

    Appreciate you pointing out the correct way to do this Ginger. My users also thank you.

    Curious what the 'keep header visible while scrolling' row and column checkboxes are for. Since they don't do what they seem they're supposed to do, what do they actually do?

    Tablix properties > General > Row Headers/Column Headers

    @Brad Smith, it's my understanding that these settings only work with a Tablix that utilizes COLUMN grouping.  Frankly, I can't speak to that because in my 15 years of data management, I've never created column groups.  I know it's a thing but my brain just doesn't work that way (I'm probably showing my age...which I'll keep to myself, lol).  SQL Chick mentions it at the very beginning of this article and I suppose that would be a starting point for finding out more, if you're so inclined.  HTH!

    • This reply was modified 1 year, 5 months ago by  thisisfutile.
  • Stan Kulp-439977 wrote:

    Freezing the header of a table is simple for the online version of an SSRS report, but freezing the header of a spreadsheet exported from an SSRS report appears to be impossible.

    I have tried all the alleged solutions I have found, but none of them have worked.

    Does anybody know how to do it?

    @Stan Kulp, are you saying that exporting the report to an XLSX file and then using Freeze Pane in Excel (or even Split Screen) doesn't work?  I'm assuming you've tried this or you're referring to something completely different that I'm oblivious to.

  • I am saying that I would like to be able to export the Excel file with the header rows frozen.

    It is allegedly possible, but I couldn't get it to work.

    https://www.mssqltips.com/sqlservertip/3548/freeze-excel-column-header-for-sql-server-reporting-services-report/

Viewing 10 posts - 1 through 10 (of 10 total)

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