Multi Currency Report 2

[dlengkong]

CR11

Has anybody dealt with multi currency reports before?

I have 40+ reports that contain about 10+ numeric fields that have been formatted to show the currency symbols($). I need to change the currency symbols based on the country name that is entered in the parameter. I know that I can create a separate field for the symbol and put some conditions in it, but that's going to take some time. I was wondering if there's an easier way of doing it. Any help is appreciated. Thanks

Denny

 

[IanWaterman]

Right click number-> Format
Select standard format you want then click customise.
Then click currenct tab
Check enable
In formula box opposite currenct symbol apply your formula rule there.

This should now be available for all numbers, using the format pasting option.

Ian

 

[dlengkong]

Ian,

Thanks for the reply. I apologize for not being clear on my posting earlier.

On each of my report, I have 10+ different numeric fields (in different sections), therefore if I were to follow your suggestion, I would have to format all those fields separately. Then, I have to redo the same process for 40+ reports. That's why I was wondering if there's an easier way to do it (e.g: creating global variable).

Denny

 

[AndyMc]

Denny,

Per report, you can hold down CTRL and click each of the numeric fields and then right click one and follow Ian's suggestion above. It will format all the fields together.

I don't know how you'd do accross all reports.

Andy

 

[dlengkong]

Thanks Andy and Ian,

I guess I have to do it the hard way since there's no apparent shortcut for the task that I'm trying to accomplish.

Denny