SSRS (RDL report) pagination displays table headers and freeze processing of table headers

Source: Internet
Author: User

Basic Environment

A recent two-time development of a Siemens system in the company requires SQL Server Reporting Services (SSRS). The SQL version we use is

SQL Server R2; When designing a report, the table uses a matrix (Tablix). As the group of users in the Siemens system implementation at the time, the Siemens developers have raised this issue, Siemens then gave the answer is: "Technical reasons, can not be achieved." ”。

In retrospect, one is that they have not studied the problem carefully, and the second is that there is too little information about SSRS.

Technology implementation

The first attempt is through the Tablix property

It is found that even if all of these "functions" are checked, the desired effect cannot be achieved. The header of the report data is still not paged, or it cannot be "frozen".

In this paper, we find that the desired effect can be achieved by modifying the XML code of the report file.

After you open the XML view, find the <TablixRowHierarchy> node,

After locating the node, modify the first tablixmember (usually the second is group information)

To make it easy for everyone to modify, post code:

<Tablixrowhierarchy>          <tablixmembers>            <TablixMember>              <KeepWithGroup>After</KeepWithGroup>              <RepeatOnNewPage>True</RepeatOnNewPage>              <Fixeddata>True</Fixeddata>            </TablixMember>            <TablixMember>              <GroupName= "pom_order_id">                <groupexpressions>                ...

Where the use of <KeepWithGroup> nodes and <RepeatOnNewPage> nodes, the role is to turn the page to display the table header;<fixeddata> node is frozen table header, that is, when the scroll bar is pulled to display the table header.
Finally, the report implementation effect

For more technical content on SSRS, keep your eye on it.

SSRS (RDL report) pagination displays table headers and freeze processing of table headers

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.