Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2003
    Posts
    54

    Unanswered: Order by in Crystal reports

    Hi ,
    I have a report which is grouped by user_id. When I checked the SQL query for the report, it did not have any group by clauses but had a order by clause for the user_id. Now I want it to order by sales_date. I don't know how to add that to the report. So I added that manually into the SQL query and it worked fine but the saved changes to the SQL query did not show up at the next run of the report. Can someone tell me how to add the extra order by clause and save the cjanges so that the report reflect the changes at the next run.

    Regards

    Jaideep

  2. #2
    Join Date
    Apr 2004
    Location
    Germany
    Posts
    23

    Smile

    Hi again Jaideep,

    you will find the sort options in the menu "Report", there take the "Report Sort Expert..." menu item.

    Your group is allready there.

    Sneaky Pie

  3. #3
    Join Date
    Apr 2003
    Posts
    54
    thanks a ton .......
    man

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •