Hello to all.. im wondering how can i generate a more accurate monthly report in VB6 using crystal reports 9, what i have done so far is a basic monthly report (which is sorted of course by months). however, what i want to do now is not only it is sorted by months but also by its status. here is my code so far, im using SQL Server 2000..

strsql = "{ADMmemodetails.memoappdate} in DateTime (" & yr & ", " & m & ", " & dey & ", 00, 00, 00) to DateTime (" & Trim(yr2) & ", " & Trim(m2) & ", " & Trim(dey2) & ",00, 00, 00)"

Set miReport = miCRApp.OpenReport(App.Path & "\reports\rptmonthlyADM.rpt")
Call GenMonthlyAnn

Sub GenMonthlyAnn()

With miReport
.RecordSelectionFormula = strsql
End With


With frmrptview.crviewer
.ReportSource = miReport
.ViewReport
.Zoom "90"
.Visible = True
End With

Set miCRApp = Nothing
Set miReport = Nothing
frmrptview.Show

End Sub


this is only sorted by months, how can i sort it also by status?

thanks in advance.. need your advices and tips here..