You’re offline. This is a read only version of the page.
Announcements
210
How to get running value when the field is of expression in the SSRS report?
Hi Vikash,
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?
Hi Vikash,
Please check this thread and see if that helps you.
Hi vikash_,
Are you trying to calculate the percentage of value from the totals?
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.
| ABC | XYZ |
| 2 | |
| 3 | |
| 4 | |
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.
| ABC | XYZ |
| 2 | 2 |
| 3 | 5 |
| 4 | 9 |
Hi Vikash,
Try to use RunningValue function.
docs.microsoft.com/.../report-builder-functions-runningvalue-function
community.dynamics.com/.../ssrs-report-running-total-using-expression
Hi Vikash,
What do you mean by running value here? Could you please explain your requirement?
#1
André Arnaud de Cal...
294,206
Super User 2025 Season 1
#2
Martin Dráb
232,968
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
