When a report contains more than 100 rows then we can add page break at the end of a specified number of rows instead of /in addition to groups or report items.
Steps for adding Page Break in Reporting
Step 1- Remove all the Groupings of the Table.
Step 2- Select the Detail Row(All total Data Row) of the Table –>Right Click.
Step 3- Click on Add Group –> Parent Group.
Step 4- In the Group By Expression Add =Int(RowNumber(Nothing-1)/10) –>OK.
Step 5- Go for Row Group(At the left corner below of the Design View) –> Group Properties.
Step 6- Go for Sorting Properties, Remove the Sort Expression.
Step 7- Go for Page Breaks and check the “Between Each Instance of Group”–>OK.
Step 8- If you dont want the Newly added Column , Select The Total Column –>
Click on Delete Columns.
Step 9- Select the “Delete only columns” Radio Button from the Dialog Box.
Alternatively, you can follow these steps
Step 1- Edit Group, Group on expression =Fields!patientName.Value ( group field).
Step 2- Another expression =Int(RowNumber(Nothing-1)/10).
Step 3- Include group header & page break at end.