Change Sort Field in Runtime

[mutley]

HI

How can I to change sort field in runtime ?

I am using CRAXDRT

Tks

[pnish]

Try something like this...

Dim crFormulaField As CRAXDRT.FormulaFieldDefinition
    Dim crApp As CRAXDRT.Application
    Dim crReport As CRAXDRT.Report
 
    Set crApp = New CRAXDRT.Application
    Set crReport = crApp.OpenReport("your report here")
    '
    '   Set the field to sort by
    '
    Set crFormulaField = crReport.FormulaFields.GetItemByName("name of the field to sort by")
    crReport.RecordSortFields.Add crFormulaField, crAscendingOrder