I am running some reports (tabular in this case, but can be any).
The grand total field is calculated, according to the "Show Currency Using.." on the report builder.
As we have partners/users around the globe, using multiple currencies, I want that the same report will display the summary, according to the user currency settings.
I can't seem to find a way to dynamically change the summary field.
Best Answer
I don't think it's possible. You can dynamically change the filter parameters (see http://www.shellblack.com/salesforce/deploy/custom-report-links/) or mimic clicking of [Show Details] by appending "?details=yes" or "details=no" to the report URL.
There's matching hidden input field but passing "¤cy=USD" doesn't seem to give any results...