You'll need to sort on a parameter. Have the user select the sort order in VFP, then pass that as a parameter field to Crystal.
>I don't remember how to do this or if I can do this in Crystal Reports 10.
>
>I want to be able to sort a Crystal Report either of two different ways depending upon the user input parameter when the report runs.
>
>The report will either be sorted and grouped on item number or job number depending upon the user input parameter as Item or Job.
>
>Or do I have to make two separate reports? Meanwhile, I'll be researching the question some more.
>
>Thank you for your help!
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer