How to give serail number in VB Data Environmental datareport(vb datareport)

D Manivelan

Hi Friend, I am using MSAccess database and VB Data Environmental datareport(vb datareport) i don't have serial number as a field in the database table. But in VB Data Environmental datareport(vb datareport) i need to display serial number. That report will display only one person's information.how to give that serail number. Here is my sample database table.

Nam id feename amt

AAA 11 Tution1 100
AAA 11 Tution2 100
AAA 11 Tution3 100
BBB 12 Tution1 100
BBB 12 Tution2 100
BBB 12 Tution3 100
BBB 12 Tution4 100
CCC 13 Tution1 100
CCC 13 Tution2 100
CCC 13 Tution3 100
DDD 14 Tution1 100
DDD 14 Tution2 100

Kindly help me. Expectd Output in DataReport is

Sno Nam id feename amt

1 AAA 11 Tution1 100
2 AAA 11 Tution2 100
3 AAA 11 Tution3 100

Sno Nam id feename amt

1 BBB 12 Tution1 100
2 BBB 12 Tution2 100
3 BBB 12 Tution3 100

Agecanonix

If you mean adding record numbers to a report here is an article that may help: Counting in reports[^]

D Manivelan

It is working in ms access datareport but am asking about VB Data Environmental datareport(vb datareport)