Regarding SSRS Report . Urgent !!!!

Question

I have two column in a report . I want below result

Member1   Member 2

416           -

422         416

58           422

472          58

470         472

I want member2 column result on the basis of Member1 column in my report with the help of expression.

please suggest me the the expression .

I use this -=iif(isnothing(previous(Fields!Members.Value)),"-",Fields!Members.Value-previous(Fields!Members.Value))

but it fetch the value from data set not in member1 column.above expression doesn't works for me .

please suggest the alternate way for doing this.

Answer 1

Hi,

Use the below expression:

=IIF(ISNOTHING(Previous(RunningValue(Fields!Members.Value,First,"Details"))),"-",Previous(RunningValue(Fields!Members.Value,First,"Details")))

Where "Details" is the default row group name.

Thanks,

Rana

Answer 2

Hi Hasan,

Above expression gives following error..

Error    7    [rsAggregateofAggregate] The Value expression for the textbox 'textbox33' contains an aggregate function (or RunningValue or RowNumber functions) in the argument to another aggregate function (or RunningValue).  Aggregate functions cannot be nested inside other aggregate functions.  

Answer 3

Hi,

I have checked it and it is working fine for me.

Please use only this part and check

Previous(RunningValue(Fields!Members.Value,First,"Details"))

Answer 4

Thanks a lot Hasan !!!

Answer 5

Please mark appropriate reply as answer if your problem is resolved.

---

"You will find a fortune, though it will not be the one you seek." - Blind Seer, O Brother Where Art Thou
Please Mark posts as answers or helpful so that others may find the fortune they seek.