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

Nesting aggregates not supported

1 Answer 23 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Mattias
Top achievements
Rank 1
Mattias asked on 10 Apr 2013, 09:11 AM
I read that Telerik Reporting does not support nesting of aggregates and I don't know if there is a way to achieve the following:

* I have a report with a list of amounts and currencies. Some amounts are positive and others are negative.
* I have grouped the amounts by currency.
* In the group footer I put two textboxes:
1) textBox1.Value:  =Sum(IIF(Fields.Amount>=0;Fields.Amount;0))
2) textBox2.Value: =Sum(IIF(Fields.Amount<0;-Fields.Amount;0)) * At the very bottom I need to create a hashcode of respective group footer values. a) textBox3.Value: =Sum(textBox1.Value) b) textBox4.Value: =Sum(textBox2.Value) I can't seem to calculate values based on the group footer results however. Am I missing something really simple?
Yours,

Mattias ├ůslund


1 Answer, 1 is accepted

Sort by
0
Peter
Telerik team
answered on 15 Apr 2013, 08:40 AM
Hi Mattias,

Yes, nesting aggregates is not supported. However in many cases you can overcome this limitation with custom aggregates. Up to your current question, based on the provided information it seems that you want to show aggregate data based on the whole report data. If this is the case our suggestion is to place the textboxes in a report footer sections and use the same expressions that you have used in the group footer textboxes.

Greetings,
Peter
the Telerik team

Have you tried the new visualization options in Telerik Reporting Q1 2013? You can get them from your account.

Tags
General Discussions
Asked by
Mattias
Top achievements
Rank 1
Answers by
Peter
Telerik team
Share this question
or