In report properties, there's an "Aggregation" property:
In sounds as if it could be useful if it passes the aggregation back to the server.
I've tried to use it in a Sales Ledger report to aggregate transactions by customer, but have had no joy. Does it actually work, and if so could I have an example?