-
Apr 8th, 2013, 11:42 AM
#1
Thread Starter
Member
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.
SELECT RefNumber, ProdCode, Amount, Currency,TraDate, AccOff
FROM tblSample
ORDER BY Currency
Thank you in advance.
-
Apr 8th, 2013, 06:44 PM
#2
Re: Sorting Amount By Currency
...and what is your reporting tool & version and how are you calling it? Crystal reports? data report?
JG
... If your problem is fixed don't forget to mark your threads as resolved using the Thread Tools menu ...
-
Apr 8th, 2013, 07:57 PM
#3
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.
-
Apr 9th, 2013, 01:03 AM
#4
Thread Starter
Member
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.
Thanks.
-
Apr 9th, 2013, 09:14 AM
#5
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
JG
... If your problem is fixed don't forget to mark your threads as resolved using the Thread Tools menu ...
-
Apr 9th, 2013, 09:45 PM
#6
Thread Starter
Member
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.
Last edited by hopia; Apr 9th, 2013 at 11:29 PM.
-
Apr 9th, 2013, 10:00 PM
#7
Re: Sorting Amount By Currency
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.
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|