Forum Discussion

Priyanka_S111's avatar
Priyanka_S111
Copper Contributor
Aug 06, 2024

SSRS: Display 10 Rows from Two Tables Per Page with Pagination

Question:
I’m working on an SSRS report where I need to display data from two tables on a single page. The requirement is to show a total of 10 rows combined from both tables on each page. If there are more than 10 rows, the next set of rows should be printed on the subsequent pages, maintaining the same pattern.
Example: 

  • Page 1: Rows 1-10 from both tables combined.
  • Page 2: Rows 11-20 from both tables combined.
  • And so on...
    Expected Result:
             
    How can I achieve this in SSRS? What is the best approach to ensure that I correctly paginate 10 rows per page from both tables combined? Any guidance or example would be greatly appreciated!

1 Reply

  • Repichi's avatar
    Repichi
    Iron Contributor

    Use ROW_NUMBER() to merge data from the two tables, group by every 10 rows and enable pagination,SSRS will handle page breaks automatically.

Resources