Forum Discussion
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 ...
Use ROW_NUMBER() to merge data from the two tables, group by every 10 rows and enable pagination,SSRS will handle page breaks automatically.