Share via

How to create a report with a full-height static region that repeats on every page?

Anonymous
2023-05-11T21:28:11.3533333+00:00

I am trying to create a landscape report where 3/4 of it will contain a tablix that may or may not span multiple pages. In the remaining 1/4 of the report will be additional information that is static and it needs to repeat on every page.

The best example I can provide is something like the Amazon.com packing slip which I have included a link to below. Image of packing slip

I have tried tables, matrices, nested of both, etc... and I cannot find a solution. Does anyone have any insight on how I can accomplish this?

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,878 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. AniyaTang-MSFT 12,421 Reputation points Microsoft Vendor
    2023-05-12T02:19:36.0733333+00:00

    Hi @Andrew Kramb

    You can use rectangles to restore this static information. The rectangle acts as a container where you can add text boxes, images, etc.

    If you have a matrix or table in the report body, or any report item that repeats on each page, you can set the property of the rectangle RepeatWith to the name of the report item. The rectangle then repeats on each page.

    I did a simple test. Added a rectangle and set RepeatWith to the name of Tablix. This rectangle will repeat every page where Tablix appears.

    1

    2

    Preview:

    3

    Best regards,

    Aniya