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
* 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
0
Hi Mattias,
Peter
the Telerik team
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.