Sorting Amount By Currency

I wanted to sort all amounts by their respective currency.

Below is the output that i wanted.
AUD: xxx.xx
JPY: xxx.xx
SGD: xxx.xx
EUR: xxx.xx


I'm trying this code but it is not working. Hope you can help me to generate the output.

Quote:

---

SELECT RefNumber, ProdCode, Amount, Currency,TraDate, AccOff
FROM tblSample
ORDER BY Currency

---

Attachment 98673


Thank you in advance. :thumb:

...and what is your reporting tool & version and how are you calling it? Crystal reports? data report?

Also, could you post the code where you call the report and how do you set the datasource. The SQL looks ok so maybe the datasource is not getting set with that sql string.

This is crystal reports for Visual Studio 2008.

I do not have codes that calls the report. Its purely crystal reports.

Attachment 98733

Thanks.

menu / Report / Record Sort Expert
select Currency field from Available Fields and move to Sort Fields using > button
set Sort Selection
click OK and try

Hello jggtz, it only sorted the currency. Thanks jggtz. Btw, what i wanted to happen is like this.

Currency AMOUNT

IDR 100.00

PHP 0.00

USD 150.00

IDR 50.00

-----------------------------
TOTAL (IDR) 150.00
TOTAL (USD) 150.00

TOTAL (IDR) and TOTAL (USD) should be placed in the footer.

Quote:

---

it only sorted the currency

---

That's what you said you wanted, you didn't say anything about the totals.

Don't you think you should at least thank jggtz for helping with what you asked for.