How to get running value when the field is of expression in ssrs report?

(0) Share

Report

Posted on by vikash_

210

How to get running value when the field is of expression in the SSRS report?

I have the same question (0)

All responses (10)

Answers (0)

Sergei Minozhenko 23,093 on at

Like (0)

Report

RE: How to get running value when the field is of expression in 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?

Was this reply helpful? Yes No
Gunjan Bhattachayya 35,421 on at

Like (0)

Report

RE: How to get running value when the field is of expression in ssrs report?

Hi Vikash,

Please check this thread and see if that helps you.

Was this reply helpful? Yes No
vikash_ 210 on at

Like (0)

Report

RE: How to get running value when the field is of expression in ssrs report?

Yes

Was this reply helpful? Yes No
Sergei Minozhenko 23,093 on at

Like (0)

Report

RE: How to get running value when the field is of expression in ssrs report?

Hi vikash_,

Are you trying to calculate the percentage of value from the totals?

Was this reply helpful? Yes No
vikash_ 210 on at

Like (0)

Report

RE: How to get running value when the field is of expression in ssrs report?

=((Fields!LineAmount.Value)/(Sum(Fields!LineAmount.Value, "MyDatasetName")))*100

Was this reply helpful? Yes No
Suggested answer

Sergei Minozhenko 23,093 on at

Like (0)

Report

RE: How to get running value when the field is of expression in ssrs report?

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.

Was this reply helpful? Yes No
vikash_ 210 on at

Like (0)

Report

RE: How to get running value when the field is of expression in ssrs report?

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

Was this reply helpful? Yes No
vikash_ 210 on at

Like (0)

Report

RE: How to get running value when the field is of expression in ssrs report?

Hi,

I tried this, but it is not working. Any other way?

Was this reply helpful? Yes No
Blue Wang on at

Like (0)

Report

RE: How to get running value when the field is of expression in ssrs report?

Hi Vikash,

Try to use RunningValue function.

docs.microsoft.com/.../report-builder-functions-runningvalue-function

community.dynamics.com/.../ssrs-report-running-total-using-expression

Was this reply helpful? Yes No
Gunjan Bhattachayya 35,421 on at

Like (0)

Report

RE: How to get running value when the field is of expression in ssrs report?

Hi Vikash,

What do you mean by running value here? Could you please explain your requirement?

Was this reply helpful? Yes No