Running Total

[Saima Gul]

Hi

 i want to show running total against each row . mydata is such as follows

A/C Debit Credit Balance

1 500 200 300

1 100 400

1 50 350

2 200 200

2 100 300

2 100 200

Here Balance is running total of Debit-Credit calculate w.r.t Acc No

i have seen forum thread http://www.telerik.com/community/forums/reporting/telerik-reporting/expressions.aspx

where it is mentioned that running total support is not present in Q1 2009

is this already possible in Q1 2010 Version?

Please reply me s soon as possible

[Peter]

Hi Saima Gul,

Since Q1 2010 we have introduced the RunningValue(scope, aggregateFunction) function -  the value for RunningValue resets to 0 for each new instance of the specified scope. If a group is specified, the running value is reset when the group expression changes. If a data item is specified, the running value is reset for each new instance of the data item.

Greetings,
Peter
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.

[Amdawi]

Hello,
I want example ..
Thanks,

[Peter]

Hello Fahad,

I have attached a sample that uses the = RunningValue("table1",Sum(Fields.Sales)) expression.

Kind regards,
Peter
the Telerik team

[chris_cf]

How would I put the running total in the page footer?

[Peter]

Hi Chris_Cf,

In order to use Page exec in running values scenario our suggestion is utilize report events. Check out the attached modified Invoice demo that illustrates how to accomplish running value on page exec aggregate.

Best wishes,
Peter
the Telerik team