[Solved] Grand total on last page only and subtotals on each page – RDLC

by


I found the solution:
Add a parent group to the first group and limit the number of rows per page using the following expression

=CEILING(RowNumber(Nothing)/13) (where 13 is the number of rows per page)

add a footer to this group that will calculate your total per page(subtotal) using the sum function on one of the columns from the child group.

To achieve the grand total just add a total row to your table your tablix object that will only be presented in the last page.

solved Grand total on last page only and subtotals on each page – RDLC