7

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.

2 Answers 2

3

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 ;) -->
3

Perhaps it wasn't possible at the time this question was asked, but in the meantime it is possible.
You can remove the currency you set in the Currencies Using picklist in the Classic report builder through the metadata.

You need to download the xml of the report using your preferred tool. Then simply delete the <currency>EUR</currency> element from the xml, and upload the xml back to the server using the Metadata API.
This will remove the default EUR currency from the report and instead will use the currency set in the user settings.

2
  • 1
    Thanks for sharing this trick, VERY HELPFUL !!!
    – benahm
    Sep 29, 2020 at 12:14
  • Happy to help. Perhaps @Saariko should update the accepted answer >:)
    – Folkert
    Sep 29, 2020 at 13:46

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .