Aggregation in the report done locally

[dssd]

I have a report where the aggregation is done locally.. as in xsums, xmins etc...Native sql doesnt have the corresponding sum, etc. This is effecting performance.

How can i send it to Native sql, any clues?

[navissar]

There's a setting in query properties called "rollup processing". In Query Explorer select your query, then in properties pane change "rollup processing" to "Database" (Default is "Extended"). See if this helps.

[dssd]

Tried it out and it didnt help.