How to show total Amount for all the rows per page in SSRS report?

(0) Share

Report

Posted on by D365FO Avatar

668

Hi All,

I'm working with SSRS report which have a column of Net Amount field and I want to show the total amount of all rows per page in the end of the page body and if more lines exist it will print in another page and have total amount line as well.

In my report I have created a table and added a group, I have added a row with add total amount of the new amount field. But in my report the total amount is coming but not per page when all the data is printed in second page then the total amount line is coming.

Please help me to solve this issue.

I have the same question (0)

All responses (2)

Answers (0)

huijij 19,811 on at

Like (0)

Report

Hi

Please go through the link to check if it helps:

social.msdn.microsoft.com/.../ssrs-expression-adding-totals-per-page

Was this reply helpful? Yes No
D365FO Avatar 668 on at

Like (0)

Report

Hi Judy Jee,

I have gone through the link but there it is mentioned to use it in footer and in my case I have 4 tables in a single layout and need the sum of Amount in all the pages at the end.

Was this reply helpful? Yes No