In SSRS, I need to display only one record on each page

Question

In SSRS, I need to display only one record on each page, with the next record appearing on the second page, and so on. Currently, I have two tables, two text boxes, and one matrix per page. I've tried rows grouping, but it's affected the first table only, and it's sending other table(s), matrixes, and text boxes on the next page too.

My dataset, "MsDset," is fetching 60 records.

Answer 1

Add a "Page break" on each row on Tablix or other control property, see

https://learn.microsoft.com/en-us/sql/reporting-services/report-design/add-a-page-break-report-builder-and-ssrs?view=sql-server-ver16