Announcements
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 community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
André Arnaud de Cal... 433 Super User 2026 Season 1
Subra 382
Martin Dráb 279 Most Valuable Professional
