Freeze Headers in SSRS Paginated Report

Dom 866 Reputation points
2023-08-02T13:29:25.4366667+00:00

I have an RDL that has multiple pages of data. I need to freeze the column headers (preferably not the whole header, just the column headers) both when scrolling and from page to page.

User's image

Tried ticking off these items in the Tablix properties for the column headers, but this has no effect. How can I accomplish this?

User's image

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

1 answer

Sort by: Most helpful
  1. AniyaTang-MSFT 12,446 Reputation points Microsoft Vendor
    2023-08-03T01:32:43.9433333+00:00

    Hi @Dom

    For displaying row and column headers on multiple pages, you can refer to this document: https://learn.microsoft.com/en-us/sql/reporting-services/report-design/display-row-and-column-headers-on-multiple-pages-report-builder-and-ssrs?view=sql-server-ver16.

    For keeping headers visible while scrolling the report, you can refer to this document: https://learn.microsoft.com/en-us/sql/reporting-services/report-design/keep-headers-visible-when-scrolling-through-a-report-report-builder-and-ssrs?view=sql-server-ver16.

    Hope these can help you.

    If the answer is helpful, please click Accept Answer and Up-Vote for the same. If you have any questions, please feel free to let me know.

    Best regards,

    Aniya

    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.