Report/Group totals

[Javier Gonzalez de Aragon]

Hi, I created a report that gas one group. The data has the following form:

OrderID | Date | OrderTotal | InvoiceID | InvoiceTotal

1 | 2015-01-01 | 300 | 1 | 150

1 | 2015-01-01 | 300 | 2 | 100

1 | 2015-01-01 | 300 | 3 | 50

 

The report groups on OrderID, so on the group header I have the info related to the order and on the detail section I have the info related to the invoices for each order. The group footer has a subtotal for the InvoicoTotal (this works fine. Returns value of 300). In the report footer I have a total for OrderTotal, and teh prblem here is that the value I am getting is 900 instead of 300. How can I achieve to sum on the group level and not on the detail level. I have already tried using Exec(scope, SUM) and RunningTotal(scope, SUM) but the result is the same.

[Stef]

Hi Javier,

With applied aggregate the data will be accumulated for the given data scope.

If the total is already calculated in the retrieved data, you can directly display the field's value without applying aggregate, or use the First/Last/Max or other function suitable for your requirements. There is also a mechanism for creating custom aggregates.


I hope the provided information is helpful.

Regards,
Stef
Telerik

[Javier Gonzalez de Aragon]

Thanks for the reply. The solution doesn't work because there are multiple orders and what I need is a total for all the orders. If there is no built in solution then I will explore the custom aggregates approach.