2) CR only reads 1 row at a time

3) you never reference an array member  bracket i endBracket

4) what is this supposed to do?  you keep setting a variable equal to itself...so nothing is changing

 

 

 

Crystal is good at reading rows, but if you are looking for something, Crystal is not the tool.

 

If you want a list of currencies that are present in the data for the report, I would suggest a subreport, it will read all the data and can report back with an array that you can format into a string.  If you want to filter a report by the currencies, you can use a command object to select the different currencies and present them to the user as a parameter, and then you can filter the data based on the user's response.

 

So the biggest question seems to be, how do you want to use the currency values that you are looking for?  For display or as a parameter to filter?

 

HTH