Microsoft Dynamics 365 | Integration, Dataverse...

Show Sum of en expression column in footer in all pages SSRS

(0) Share

Report

Posted on by Community Member

I have 2 expression column in my tablix. They contain an expression that multiples two column.I want to show the sum of this expression column in footer in two textboxes as sum for first expression column and sum for second expression column also i want to show result in every page or last page.presently i did so with reportItem! but it will not work for every page.

I have the same question (0)

All responses (3)

Answers (0)

cloflyMao 25,210 on at

Like (0)

Report

Hi sharudas,

Could you share a screenshot of your current report with more detailed description if possible?

It would be helpful for me to understand your report appearance/layout better.

Below is my understanding based on what you've described.

Product Name Shipments Cost ($) Price ($) Total Sale Total Profit

TV 120 150 300 36000 18000

Washing Machine 100 250 500 50000 25000

Oven 80 50 150 12000 8000

98000 51000

Do you want to E5(98000) and F5(51000) are always fixed on report bottom/footer?

(and would them be your 2 expression columns?)

Thanks.

Regards,

Clofly

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

yes u r right and i want to show the total of those two column in the last page but it is showing total according to per page line like if i am having 5 lines in fist page and amount is 100 then first page 500 and if 3 lines in next page then 300 in next. how can i obtain 800 in last page.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

running value and lastvalue worked for it

Was this reply helpful? Yes No