I will add my opinion about my report
busy cat http://s3.subirimagenes.com:81/imagen/previo/thump_7631306captura.png
You can see that the parent of the group is NOM CLIENTE (ACCOUNT) after it has a child group called fecha (date) after each date (date), has several pro code (product code), and each pro-code has a cantidan (quantity) and each (pro codigo * cantidad) (product code * quantity) has importe (quantity), so each function (date) has its own value (its total amount is the quantity purchased on this day) now each customer has a total quantity ( all his purchases), and now I want to sort my report, but this is the last total, you could see
837,25000
549,60000
1004,0000
369,50000
464,50000
order should be:
1004,0000
837,25000
549,60000
464,50000
369,50000
when I do the sorting in the upper left corner and I put this function on the sorting tab
=Sum(Fields!importe.Value)
I get this message:
An error occurred while processing a local report. report / best_accounts definition is invalid. The sort expression for tablix "Tablix4" includes an aggregate function. Aggregate functions cannot be used in data row sort expressions.
then how can i sort as i want?
source
share