Programmically Multiple Sort Order in Crystal Report
Posted on 2010-09-16
I am trying to programmically sort my crystal report on multiple columns.
I am able to sort one column by the below code.
fd = cryRpt.Database.Tables.Fields[_sortfield];
cryRpt.DataDefinition.SortFields.Field = fd;
cryRpt.DataDefinition.SortFields.SortDirection = CrystalDecisions.Shared.SortDirection.DescendingOrder;
where _sortfield is determined by the users selecting a sorting field.
However, how can I implement a multiple order column sort where a user can select multiple columns?
My information comes from a dataset created from multiple tables so cannot use SQL to sort my datatable.