Follow the steps to limit the rows on the page
1) Go to the Rows Groups section . Select Add Group -> Parent Group -> Choose Expression in Group By
2) Paste the following code into the expression box.
=int((RowNumber(nothing)-1)/No. of rows you want to keep on the pagr)
3) In the group property go to Page Breaks option and select "Between each instance of a group".
4) If you run your report, you could get error saying "A sort expression for tablix ‘Tablix...’ uses the RowNumber function. RowNumber cannot be used in sort expressions." To fix the error remove the default sorting expression created in the group properties
1) Go to the Rows Groups section . Select Add Group -> Parent Group -> Choose Expression in Group By
2) Paste the following code into the expression box.
=int((RowNumber(nothing)-1)/No. of rows you want to keep on the pagr)
3) In the group property go to Page Breaks option and select "Between each instance of a group".
4) If you run your report, you could get error saying "A sort expression for tablix ‘Tablix...’ uses the RowNumber function. RowNumber cannot be used in sort expressions." To fix the error remove the default sorting expression created in the group properties
No comments:
Post a Comment