So I am moving some Crystal Report logic from VB6 to .NET. For some of the more complex reports the code sets the value for grouping. I figured out how to set the 1st item in the SortFields array. What I cant find is how to set the first item in the GroupSortFields array because well GroupSortFields doesnt exist in the .NET API. I have a number of reports that uses this syntax and need to get the code that invokes them converted. Amazes me that this isnt simply documented, but I havent found anything.

Here is a simplified version of the VB6 code

CR1.ReportFileName = fullPathAndFileNameToRpt
CR1.Connect = dataConnectionString
CR1.ParameterFields(0) = "SortField;" & rptParameter & ";TRUE"
CR1.SelectionFormula = ""{Manager_Category1.List}"="SomeValue""
CR1.GroupSortFields(0) = "Sum({@ABSWeightedValue},{Manager_Category1.Category1})"
CR1.SortFields(0) = "{@ABSWeightedValue}"
CR1.PrinterStartPage = 1
CR1.PrinterStopPage = 1

Also can you tell me what GroupSortFields and SortFields map into the report?


Edited by keithf1138 - 22 Jun 2015 at 8:24am