Hi I am making a report using Microsoft Reporting services 2008. I need to calculate a field base on the other column. Suppose I have the data like this Actual Data 12 2 5 7 Now i want to make a new column whose values are basically sum of previous column in this fashion. Actual Data Calculated Data 12 12 1st Row 2 14 1st+2nd 5 19 1st+2nd+3rd 7 26 1st+2nd+3rd+4th Can anybody tell me how to do this? Regards Shuja shuja

I'll wait to be corrected but for now you should assume this is not possible. I had similar requirements a while back and couldn't do it. The table, tablix control has a row... that row does not have a row(i) - 1 function. you cannot reference cells either. so, no way to do it via simply ssrs.

From your example i've understood that you are trying to calculate running value of Actual data. you can try this: =RunningValue(Fields!ActualData.Value, sum,nothing) Replace the ActualData with field name.

Right - but he wants to reference the row above, the previous record (row) which cannot be addressed.

what do you mean? records are coming from dataset and he can put this runningvalue exprssion on the very top and he should be good.

Hi Pratul_sri, Your solution work for me partially. It done as I want but now the problem is that i have grouped the data i.e there are multiple groups in the report and i want this for only one w.r.t that group but now e.g like this Actual Data Calculated Data First Group 12 12 1st Row 2 14 1st+2nd 2nd Group 5 5 1st 7 12 1st+2nd 1 13 1st+2nd+3rd At the moment it is doing in this way, Actual Data Calculated Data First Group 12 12 2 14 2nd Group 5 19 7 26 1 27 Any Solution for it??shuja

Hi edgarsanchez, I have done it. it can be possible as described by Pratul_srishuja

Could you share our formula? Thanks.

=RunningValue(Fields!open_quantity.Value,sum,"table1_product_id") where "table1_product_id" is the name of the group. if ur report did not have any group then replace it with nothing. If u have any other question then do let me know Thanks Shuja shuja