Sorting of Crystal Report

[dharmesh_niru]

Hi Babu,

I am using crystal reports 8.0

I want to know how can I sort records based on some database column filed.

Thanks in advance,
Dharmesh

[dinesh123]

CrystalReport1.ReportFileName = App.Path & "\reports1.rpt"
CrystalReport1.SelectionFormula = sql
CrystalReport1.WindowTitle = "Status Reports"
CrystalReport1.SortFields(0) = "+{transaction_master.transaction_no}"
CrystalReport1.WindowState = crptMaximized
CrystalReport1.Destination = 0
CrystalReport1.Action = 1