Sorting Problem

[zmcanally]

I am using Crystal Reports 8.5 w/ an Access 2000 database. I have created a drill down report and the detail section is sorting in descending order instead of ascending order. I modified the SQL query and it changes and works fine, but after I save the report and reopen it, it reverts back. Here is a snippet from the SQL - - ORDER BY Cashier.`CSHR_POS_NAME` ASC - - here is what I add/change - - ORDER BY Cashier.`CSHR_POS_NAME` ASC, RegSale.`RECEIPT_NUM` ASC - - Like I said, it works fine until I save and reopen it then it reverts back to the SQL statement without the second sorting. Any help would be appreciated

 

[Martin97]

Instead of editing the SQL, you can sort your field in Crystal Reports. In the menu, choose "report" --> "Sort records"
Then, select the field you want to sort in your detail section and change the sort direction from there.

make sure you select the "use indexes or server for speed" in the report option so that the ORDER BY clause is sent to the server.


HTH,
Martin