1 Attachment(s)
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:
Re: Sorting Amount By Currency
...and what is your reporting tool & version and how are you calling it? Crystal reports? data report?
Re: Sorting Amount By Currency
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.
1 Attachment(s)
Re: Sorting Amount By Currency
This is crystal reports for Visual Studio 2008.
I do not have codes that calls the report. Its purely crystal reports.
Attachment 98733
Thanks.
Re: Sorting Amount By Currency
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
Re: Sorting Amount By Currency
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.
Re: Sorting Amount By Currency
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.