more than one order by clause

[112055]

Hello,
Inside the Show SQL Query, I want to include more than one order by clause.
I want to have

ORDER BY
F.BOOK_ID ASC,
L.PURCHASE_NUMBER ASC,
D.ORDER_NUMBER ASC

but somehow, everytime after I saved the Crystal Report(6.0), reopen the rpt , the

L.PURCHASE_NUMBER ASC,
D.ORDER_NUMBER ASC

disappear. Is there a way to make sure whole ORDER BY clause sticks?

Thanks

 

[112055]

Thanks guys, I've figured that out .