Hi all... I hope someone can help me... I have 2 questions about Crystal Reports:

1) I have a database which has some fields, one of them is a User Name field. I want to be able to create reports either by Ascending order or Descending order. At the moment, I have created two RPT files, for each sorting method. Is this correct? can I "instruct" Crystal Reports to sort "on the fly"?

2) How can I run Crystal Reports by using the API? I'm using Visual Basic 5.0 and Crystal Reports 4.6... I don't want to use ActiveX control.

Thanks a lot in advance
Jaime