Share via

I need to display a summary table and a details table on one report.

David Lopez 1 Reputation point
2021-08-20T13:20:13.213+00:00

I need to display two tables on one report and each table has its own dataset. The summary table is only one page long, while the details table can be several pages. I would like to display the summary table on each page generated by the details table. Right now, the summary table disappears after the first page and I am left with blank white space on the left side of my report for the pages generated by the details table. I have tried "RepeatWith" and I have tried "RepeatOnNewPage" to no effect. I have tried inserting a rectangle and adding textboxes to create a "header" for the summary report in order to display that on each page, but that did not work either. I have also tried inserting a list, but no matter what I try, it will not display on the next page. Anyone have any ideas of what I can do. All the tips that I have found online make me think it is possible, but obviously, I am doing something wrong.125067-radiograph2.pdf

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,134 questions
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,949 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Joyzhao-MSFT 15,596 Reputation points
    2021-08-23T02:37:31.883+00:00

    Hi @David Lopez ,

    and each table has its own dataset.

    This will lead to why you cannot repeat the summary table on each page.
    In the report, there can be multiple Tablix from different datasets. However, the above operations you mentioned are limited to operations in the same data area.
    If you have checked it on the Internet, the prerequisite for any one of the tables to be repeated is that the tables are all from the same dataset.
    As far as I knowr, your idea can not be realized. You can consider integrating the data from the two tables and presenting them in one dataset (for your data, I am not sure whether this method will work for you).
    By the way, how to fix Row and Column Headers in the report, please refer to: Display Row and Column Headers on Multiple Pages (Report Builder and SSRS).
    On how to repeat a table in the same dataset on each page: How to Repeat a Table in every page of SSRS Report.
    Best Regards,
    Joy

    If the answer is helpful, please click "Accept Answer" and upvote it.
    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.

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.