Hi,

I have VS 2005 and am running a crystal report bound to a typed dataset (that gets it's data from a SQL 2000 database).

Can anyone tell me how I sort the data programatically?

I cannot sort the data in the stored procedure nor can I define the sort fields in the crystal report at design time because they must be specified by the user at run time.

I have tried creating a DataView object and sorting that but the SetDataSource property doesn't take a DataView (only a DataSet or DataTable).

I noticed a ReportDocument.DataDefinition.SortFields object but it doesn't appear to have anyway of adding sort fields.

Please help!