Crystal Reports ? Set Order By At runtime

[BrianDH]

I am looking for a way to set the Sort Order by at runtime

Sort the output of field "totalfees" to (descending) or (ascending) at
runtime.

Thanks

BrianDH

[BrianDH]

This works
Dim crSortDirection As SortDirection
Dim crDatabaseFieldDefinition As DatabaseFieldDefinition
Dim crSortField As SortField
Dim iSortItem As Integer = 0

crDatabaseFieldDefinition =
crReportDocument.Database.Tables(0).Fields(6)
crSortField = crReportDocument.DataDefinition.SortFields(0)
crSortField.Field = crDatabaseFieldDefinition
'crSortField.SortDirection = SortDirection.AscendingOrder
crSortField.SortDirection = SortDirection.DescendingOrder

"BrianDH" wrote:

I am looking for a way to set the Sort Order by at runtime

Sort the output of field "totalfees" to (descending) or (ascending) at
runtime.

Thanks

BrianDH