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

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