This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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.
Add a "Page break" on each row on Tablix or other control property, see
Thansk a lot. I was having multiple tables, and when I aded page break on one table (I've done grouping on this table too), only that table was appearing on one single page, but I needed to show all three because all three contained the data of one single record. So what I did was remove the grouping from all tables and insert all the tables inside a list, and then remove the grouping of the table rows as the list throwing error and say, "Need to have static members." The grouping is applied only on the list, and this list has all tables + some text boxes, and it works now.
Hi @M ZUNAIR TARIQ，
You may refer to How to display X Rows per page in SSRS Report and follow the steps to do that.
Regards，
Zoe Hui
If the answer is helpful, please click "Accept Answer" and upvote it.
Thansk a lot. I was having multiple tables, and when I aded page break on one table (I've done grouping on this table too), only that table was appearing on one single page, but I needed to show all three because all three contained the data of one single record. So what I did was remove the grouping from all tables and insert all the tables inside a list, and then remove the grouping of the table rows as the list throwing error and say, "Need to have static members." The grouping is applied only on the list, and this list has all tables + some text boxes, and it works now.