Can SSRS do excel like functions as expressions such as adding 1 cell from a column to another?

Question

I have searched and searched but can't find the answer. I am building an SSRS report that provides a running total. I need to be able to do the equivalent of I2+J3 and have the next row be I3+J4, etc. My report uses 1 dataset. Is this possible?

Running Total Example Pulled From Excel

You could try using `ReportItems!TextBox1Name.Value + ReportItems!TextBox2Name.Value` — BJones, Mar 23 '18 at 17:28

score 1 · Accepted Answer · answered Mar 23 '18 at 18:10

1

I found my answer. By using RunningValue function I can accomplish this task.

=RunningValue(!Fields.Charges.Value,sum,"DataSet1") creates the running total.

answered Mar 23 '18 at 18:10

jrushing

61
1
8

score 0 · Answer 2 · answered Mar 23 '18 at 17:28

0

you can use expressions in SSRS and also use grouping. looks like a duplicate of

SSRS Expression-Sum two fields

see also

https://social.msdn.microsoft.com/Forums/en-US/74e73cd3-46ce-4812-ad15-3adc50438c04/sum-two-fields-in-ssrs?forum=sqlreportingservices

answered Mar 23 '18 at 17:28

JaYdipD

40
10

I looked at that, but it does not answer my question. I need to add a row to the next row of another column just like I3+J4. different rows, – jrushing Mar 23 '18 at 17:33

Can SSRS do excel like functions as expressions such as adding 1 cell from a column to another?

2 Answers2