headers scroll on same page in vs but not after deployment to servers

db042190 1,521 Reputation points
2022-08-31T15:38:51.713+00:00

hi we run 2014. we will upgrade to 2019 next year.

this is an extension of the post at https://learn.microsoft.com/en-us/answers/questions/986282/1st-column-of-grid-overlays-other-items-as-i-scrol.html?childToView=989107#answer-989107 .

i have set fixed data to true on the 1st two static items featured there. And I get the intended "headers scroll on same page" effect in vs. but when i deploy to our dev and qa servers, that effect isn't working. can someone suggest a solution?

236636-anotherpicofrowgroups.png

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,061 questions
0 comments No comments
{count} votes

4 answers

Sort by: Most helpful
  1. Joyzhao-MSFT 15,631 Reputation points
    2022-09-01T05:59:12.07+00:00

    Hi @db042190 ,
    Do you want to keep the tablix header visible while scrolling or the first column of data is visible? As far as I know, the FixedDate property only works with First TablixMember. When I deploy to the report server it works fine.

    See more: Keep headers visible when scrolling through a paginated report (Report Builder).
    Best Regards,
    Joy


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

  2. Anonymous
    2022-09-01T08:25:59.13+00:00

    Hi @db042190
    Do you mean that after you deploy, scrolling doesn't work when viewed in the browser? Maybe you can try to open Tablix properties, click Repeat Header Rows on each Page and Keep Header Rows Visible While Scrolling.
    236827-1.png
    It could also be a compatibility issue, you can check the compatibility settings: fix-site-display-issues-with-compatibility-view-in-internet-explorer-11-9a0a3a6e-89be-518f-ff56-c491b528b302
    Best regards,
    Aniya

    0 comments No comments

  3. db042190 1,521 Reputation points
    2022-09-01T16:37:30.907+00:00

    thx joyzhao and aniya.

    joyzhao, the only thing that isnt working now (that i want) is what the author at your link says is accomplished by setting fixed data to true on the static members you want to "freeze" as you are scrolling vertically. it works in vs preview but not when deployed to 2 servers so far.

    aniya, the property you suggested trying is not for tablix's. but i tried anyway. no luck.

    right now i have fixed data = true on the 2 row group static members. and i still have it on the 1st col group static member but i'd forgotten i even had it there. i dont think the col group setting is affecting anything but who knows. this part of ssrs is very confusing.

    0 comments No comments

  4. Joyzhao-MSFT 15,631 Reputation points
    2022-09-02T08:57:14.027+00:00

    @db042190 ,
    I'll provide some screenshots of my tests:

    237196-01.png
    first-static-row
    237195-first-static-row.png
    second-static-row
    237090-second-static-row.png
    third-and-forth-static
    237251-third-and-forth-static-row.png

    View in Web Portal:

    237271-00.gif

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.