[SalesForce] How to dynamically change the currency used in a report summary

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.

enter image description here

enter image description here

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.

enter image description here

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 "&currency=USD" doesn't seem to give any results...

<input type="hidden"  id="details" name="details" value="no" />
<input type="hidden"  id="currency" name="currency" value="EUR" />

<input type="hidden" name="delrep" /><!-- yes, we can delete reports by visiting "?delrep=1" but we can't change the currency ;) -->
Related Topic