Results 1 to 7 of 7

Thread: Sorting Amount By Currency

  1. #1

    Thread Starter
    Member
    Join Date
    Jun 2011
    Posts
    52

    Thumbs up 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
    Name:  Total.jpg
Views: 363
Size:  280.7 KB


    Thank you in advance.

  2. #2
    Frenzied Member
    Join Date
    May 2006
    Location
    some place in the cloud
    Posts
    1,886

    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 ...

  3. #3
    PowerPoster
    Join Date
    Sep 2005
    Location
    Modesto, Ca.
    Posts
    5,195

    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.

  4. #4

    Thread Starter
    Member
    Join Date
    Jun 2011
    Posts
    52

    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.

    Name:  Capture.JPG
Views: 174
Size:  66.4 KB

    Thanks.

  5. #5
    Frenzied Member
    Join Date
    May 2006
    Location
    some place in the cloud
    Posts
    1,886

    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 ...

  6. #6

    Thread Starter
    Member
    Join Date
    Jun 2011
    Posts
    52

    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.

  7. #7
    PowerPoster
    Join Date
    Sep 2005
    Location
    Modesto, Ca.
    Posts
    5,195

    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
  •  



Click Here to Expand Forum to Full Width