How to generate serial numbers automatically in the datareports.

How to Generate serial numbers automatically in the datareports based on the number of records in the table. Iam using access and I dont think internally Access uses rowid option to keep track of rows. I dont know what function do I have to use to generate serial numbers. Rememeber I am not asking the count option it will give the total number of rows. I want to generate serial numbers dynamically from the front-end (VB) dont say to use the counter datatype in the backend (access). I want to generate serial numbers purely based on that row number in my report(datareport). It wont have any connection with the backend(access database). I want each row to be incremented automatically based on the row number. Is some one there to answer my question. I dont think there are too many to answers to the ?s on Datareports.


[Edited by [email protected] on 01-04-2001 at 11:46 PM]

Hello n_indureddy,
I think Your problem of getting serial numbers generated will not get solved using DataReports because no such functionality has been given in DataReports. I was trying to achieve this for one of my Invoice type of report around a year back but could not find any.
Still I can suggest you two solutions.
1. Use Crystal Reports (Any version). You can achieve your requirement very easily there.
2. Try putting all your data to a dummy table just before the report is required. Set a counter column in that dummy table & store incremental number. After closing the report window simply delete all the rows in the dummy table.

P.S. If You have already achieved a way out using datareports, then please let me know the solution.

Hello Rajesh,

Yeah, I solved the problem way back using the temporary table where in based on the query iam generating the records and putting them in the temporary table, and before each new query iam deleting the already present records in the table. But using of Datareports is very restricted may be we are used to crystal reports. Ok, yaar have a nice day..Bye.

I have exacltly the same problem as above.

Can you pls help,