lahiru_1

@tchen i already tried the first two methods. They are working as expected. but the clients want as i mentioned earlier. And the company dont want me to specify the currencies which are coming. I havent tried the last suggestion. I will look into it. Hopefully it will be the answer im looking for. Thanx for the answers. I really appreciate it.

Hi, I already tried that method. In that i have to define the currency as USD. But in my case there can be 100+ currencies. I have no idea which currencies will come as i take a web service to get the data. Is there a way to solve without having to manually define the currencies

I have two fields in the report, which are Amount and Currency. And I have to calculate the total for each currency. This report is for a financil application, therefore the currency can be anythn. And my problem is to get the total for each currency. This total has to be for each page and the whole report as well. How can solve the above problem. Please Help me. If there is any clarification of the problem, please ask. Thank you.