.RDLC tablix fixed headers is broken after upgrade to VS 2019

Jeff Bowers 11 Reputation points
2022-03-30T16:40:14.447+00:00

In a Visual Studio 2015 .RDLC ReportViewer report page, we used to select "Advanced Mode" at the bottom of the designer space and then set the "FixedData" property of the upper-most static Row Groups to make them remain visible while the user scrolled down through the report data ("fixed headers"). After upgrading to Visual Studio 2019 and a newer version of the ReportViewer control, this functionality appears to be broken. Is there a different or new way to freeze the tablix headers during vertical scrolling in Visual Studio 2019?

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,064 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Joyzhao-MSFT 15,636 Reputation points
    2022-03-31T01:47:27.6+00:00

    Hi @Jeff Bowers ,

    • If your report has only one page, just set FixedData to True. For more information, see: Keep headers visible when scrolling through a paginated report (Report Builder).
    • If your report has multiple pages, after setting FixedData to True, you also need to set RepeatOnNewPage to True and KeepWithGroup to After, otherwise when the page runs to the second page, the fixed title effect will be invalid. The specific operations are as follows As shown in the figure:

    188516-01.jpg

    Please refer to: To display a static row or column on multiple pages.
    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

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.