Say I am trying to total sales $ for a specific company, if I hardcode the expression to be: total([Sales] for [Company])
The query runs in less than a minute.
If I leave it as just [Sales] and set the aggregation function to Total, it takes almost an hour.
Anyone know why? I have lots of reports that I used the Total Aggregate function property but after upgrading to C10, they are all taking major performance hits.
Thanks!
Did you extract the SQL and see the difference between both?
Perhaps you can extract the SQL and run the SQL itself and see the difference and the number of rows returned and also runtime of just the SQL