Notifications
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 592 Most Valuable Professional
André Arnaud de Cal... 478 Super User 2025 Season 2
BillurSamdancioglu 305 Most Valuable Professional
