Announcements
No record found.
How to get running value when the field is of expression in the SSRS report?
Hi Vikash,
What do you mean by running value here? Could you please explain your requirement?
Try to use RunningValue function.
docs.microsoft.com/.../report-builder-functions-runningvalue-function
community.dynamics.com/.../ssrs-report-running-total-using-expression
Hi,
I tried this, but it is not working. Any other way?
Hi, here ABC and XYZ are two fields and 2,3,4(under column ABC) is the value which is coming from expression written under the field ABC. Now I want to calculate 0+2=2 which should come under XYZ column 1st row, then 2+3 = 5,5+4 = 9, and so on. It should come as the below table.
Hi Vikash_,
Could you, please, share your expression for RunningValue?
Another possible option is to calculate this column in the data provider class in x++ and save the value to another physical field.
=((Fields!LineAmount.Value)/(Sum(Fields!LineAmount.Value, "MyDatasetName")))*100
Hi vikash_,
Are you trying to calculate the percentage of value from the totals?
Yes
Please check this thread and see if that helps you.
Could you, please, provide more details on what exactly doesn't work? Do you see zeros instead of values in the percentage column or you see some errors? Have you tried first to output only sum expression in the column to check if it's calculated correctly?
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Giorgio Bonacorsi 617
André Arnaud de Cal... 461 Super User 2026 Season 1
Syed Haris Shah 298 Super User 2026 Season 1
