SSRS bring forward subtotal to subsequece page and using the value to add data on second page

Question

Hi, Is there any method that I can bring forward the subtotal from first page to the subsequence page using SSRS, then the subtotal will continue add on the second page value and form another subtotal of (page1 + page 2) again for the remaining page.

For example there will be a field which will bring forward the previous amount (for page 1 there is no previous value so it will be 0), and there will have another total field which will use the previous amount to add on the current data print on the page and forming the new subtotal for the page. The step will continue to the end of the page.

More detail can refer to the image :https://ibb.co/NSfVrBy

Answer 1

Hi @zhexian ，
You need an expression Total=(subtotal on this page + all previous subtotals, so that the value becomes the start of the next subtotal, that is, the value + subtotal on the next page

By inserting a row, use the following expression: =RunningValue(Fields!YourField.Value, Sum, Nothing).

If I misunderstand what you mean, please feel free to correct me.
Best Regards,
Joy

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our [documentation][2] to enable e-mail notifications if you want to receive the related email notification for this thread. [2]: https://learn.microsoft.com/en-us/answers/articles/67444/email-notifications.html