This is a migrated thread and some comments may be shown as answers.

Accumulated Amount

3 Answers 150 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Thi Han
Top achievements
Rank 1
Thi Han asked on 12 May 2012, 05:58 PM
hi all,
I would like to calculate for accumulated amount by grouping.I have a problem for that.Please help me how to solve.

Thank you so much,

3 Answers, 1 is accepted

Sort by
0
Thi Han
Top achievements
Rank 1
answered on 13 May 2012, 05:40 AM
Hi all,
I want to add the column which for accumulative amount for every rows group by one field.I want the following format.


Fixed Assets
Furniture and Fittings

Date                          Amount              Accumulative
10-05-12                   200                   200
11-05-12                   300                   500
12-05-12                   100                   600

Current Assets
Prepaid Insurance

Date                         Amount           Accumulative
10-05-12                  100                 100
11-05-12                   200                 300
12-05-12                   300                 600

I would like to get  Accumulative column.How to calculate in telerik reporting.
Please solve my problem.
Thank you so much,
Thi Han





0
Accepted
Peter
Telerik team
answered on 14 May 2012, 12:25 PM
Hi Thi,

Our suggestion is to utilize the RunningValue(scope, aggregateFunction) function. That aggregates data and 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. 

Regards,
Peter
the Telerik team

BLOGGERS WANTED! Write a review about Telerik Reporting or the new Report Designer, post it on your blog and get a complimentary license for Telerik Reporting. We’ll even promote your blog and help bring you a few fresh readers. Yes, it’s that simple. And it’s free. Get started today >

0
Thi Han
Top achievements
Rank 1
answered on 18 May 2012, 09:12 AM
Thank you so much for your reply.It works for me.Now I got the format my wanted.
Tags
General Discussions
Asked by
Thi Han
Top achievements
Rank 1
Answers by
Thi Han
Top achievements
Rank 1
Peter
Telerik team
Share this question
or