Scenario:You are working for Health Insurance company and you have created an SSRS Report for them that display FName and LName and Region for the claimants. Now the users want you to make change to the report so they see only 10 rows per page.
Step 3: Add Page Break between Group Values
Now if you preview your report , you will see the report data is divided into groups. Now we need to add page Break in Groups so we can display in each page.
Go to Group Properties again and then add Page Break as shown.
Now if you will preview your report, you will see 10 rows per page but you will see the group value as well. As you really don't want to see the group column, you can delete it.
Step 4: Delete The Group Column
Delete the Group Column as shown below. Make sure you Delete columns only as shown below. Our logic will still stay after deleting the column only.
You are all done now. You will see 10 rows per page in your report now.