Data report Serial Nos.

[ISChana]

Dear All.
Can anybody tell me how to put serial numbers in the data report e.g.my output is

name class
aa 4
bb 6
cc 5
dd 10
ee 2

now myreport should be as

Sr. nO. name class
1 aa 4
2 bb 6
3 cc 5
4 dd 10
5 ee 2


thanks

inderjeet

 

[VDavid]

You can try to do it in the query, if you're working directly with the database (no recordset manipulation) you can look for the database's engine implementation of that, or if you're manipulating the recordset you can use a column and update with an incremental value (not sure if this will work, i haven't try it myself)

Hope this helps,
David.