AX Dynamic 2012 SSRS 按行数分页

时间:2024-09-08 17:37:38

按行数分页

1. Create a new Row Group with the following grouping expression: =Ceiling(RowNumber(Nothing)/<Number of rows per page>).

2. Create page break between each instance of the group

* To display total of the previous page on the first record of the page:

1. Create a new Total Record Inside the new group above your details section.

2. In Amount field where you want to display the total of the previous page add the following expression: =Previous(Sum(Fields!Amount.Value))

*To hide the total row on the first page which is empty:

1. Go to Row Visibility and use the following expression: =IIF(RowNumber(nothing)><Number of rows per page>,false,true)