Skip to Content
Former Member
Mar 02, 2010 at 09:16 AM

Creating Totals Per Currency



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.


Num Price Currency

1 45 ZAR

2 5 USD

3 10 EUR

4 100 ZAR


Total 145 ZAR


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.