Post reply

Cannot for the life of me Feeeze the Column Headers on a simple Tabular SRSS Report

  • October 13, 2016 at 3:06 am

    #330920

    I have a Tabular report in SRSS which has 9 columns.

    I am trying to freeze the Column Headers, so when i scroll down, the Image (banner picture) and Column Headers remain fixed while scrolling down.

    Here is what the report looks like:

    Image

    Title

    Column Header 1 2 3 4 5 6 7 8

    In the Row Groups, it looks like this:

    (Static) ----------------------------> I changed the Property here to FixedData = True

    [(table1_Emp_Number)

    =(table1_Details_Group)

    (Static)

    In the Column Groups. i have it like this:

    (Static)

    (Static)

    (Static)

    (Static)

    (Static)

    (Static)

    (Static)

    (Static)

    (Static)

    I did Advanced Mode and in Column Groups, I changed the "FixedData" to True for every Static entry

    When i do preview, Visual Studio does try to fix the columns to the top, but when i publish my report and use any web Browser, the headers are not fixed.

    Can anyone please help me solve this fixed header issue and also how to fix the banner to the top as well.

    Thanks

  • October 13, 2016 at 3:14 am

    #1906273

    It's not as straightforward as it first seems. Have a look at this link for one way to do it.

    On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
    —Charles Babbage, Passages from the Life of a Philosopher

    How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

  • October 13, 2016 at 4:00 am

    #1906280

    Hi BW,

    Thanks for the link. I tried that, but still doesn't work.

    I also tried following this blog: http://bidn.com/blogs/hardikabhavsar/bidn-blog/1638/keep-column-headers-visible-while-scrolling-in-ssrs-2008

    When doing preview within Visual Studio, the column headers works fine and remain at the top while scrolling.

    However when deploying the report to the server, it the headers dissapear as soon as scrolling down using any web browser....

    So, i'm kinda stuck

  • October 17, 2016 at 4:30 am

    #1906820

    I've also tried in Report Builder... Running the report in report builder freezes the columns to the top.

    So the problem is when the report is published, no browser seems to understand the fixed settings... any ideas?

Viewing 4 posts - 1 through 3 (of 3 total)

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