Datas In Crystal Reports Are Jumbling....

[Winsoft Solutions]

Dear Friends,

We're using Crystal Reports 8.5 to generate a report from MS Access.
I'd sorted using a numeric Field (SlNo.) for a crystal report controller named 'CRP' in VB 6.0 as follows,

  Rs.Open "Select * From <tablename> Order By SlNo",<database name>,adopendynamic,adlockoptimistic

  CRP.reset
  CRP.DataFileName(0)=<database path>
  CRP.ReportFileName=<report path.rpt>
  CRP.Action=1

Rs.Close

While executing the above coding to display the field 'SlNo' Only the record get jumbled...As follows....


1
2
3
4
10
11
5
6
7
8
9
12
and so on.....

Is There any remedy To Overcome This problem or it's just a problem of mine....

NOTE: While opening the database table, The datas are arranged in sama manner as our expectation (without any jumbling.)