Create Running Totals,...

Heres something tricky I might have to implement, This is a partial screen shot of a report that I want to port to RS,

As you can see he is able to loop through the data and create totals for each month on the fly, Any one have an idea of how this might be accomplished in RS?? My thanks in advance.

Hi,

You can use RunningValue function to have running sums in your report.
You may have find the following article useful http://www.kodyaz.com/article.aspx?ArticleID=40 for the implemantation of RunningValue(Expression, Function, Scope) with an example like =RunningValue(Fields!qty.Value, Sum, "table1_Group1")
Eralper

|||You could also perform all of these sums, sorts, etc. within the SQL as well. My personal preference is to conduct almost everything in stored procedures and UDF's. The only special things I do in RS is date formatting, colors (IIF) ASC or DESC resorts on the fly - in that if I want to make system wide changes in RS I cannot remember where all of the special code is I use in RS.
To bad there is not a central repository for all custom code you include within RS - then you could just make the changes there and not worry about going back to each specific program to make the changes.
Best Regards,
joe