Creating Totals Per Currency

169 Views

Hi,

I have tried solving this problem by using code and searching forums but can't seem to come right.

The problem that I am experiencing is :

I have an undefined amount of currencies in a report. So for each line printed the currency could vary.

Ex.

Num Price Currency

1 45 ZAR

2 5 USD

3 10 EUR

4 100 ZAR

_________________

Total 145 ZAR

5 USD

10 EUR

So if I just create a total by using built in Crystal Functionality then it would just sum the price values and give the incorrect answer.

Is there a way to create get a total per currency under ones details section? If so how would one go about it. I've written some code that I thought would do the job, but have not had any luck. (If you would like to know the

Thanks in advance for any help or suggestions.