ORDENAR REGISTROS EM CRYSTAL REPORTS

KELLY 30/08/2015 20:15:56
#450720

Como faço para ordenar dados no Crystal Reports? Tentei fazer isso na Query, mas não funcionou.


Private Sub cmdExibir_Click()

Dim oapp As CRAXDDRT.Application
Dim oreport As CRAXDDRT.Report

Set rst = New ADODB.Recordset

rst.Open [Ô]SELECT id_funcionario, nome, email, telefone FROM Funcionario Order By nome ASC[Ô], Conexao, adOpenKeyset, adLockOptimistic

Set oapp = New CRAXDDRT.Application
Set oreport = oapp.OpenReport(App.Path & [Ô]\Report1.rpt[Ô], 1)

oreport.Database.SetDataSource rst, adOpenKeyset, 1

With CRViewer1
.ReportSource = oreport
.ViewReport
End With

End Sub