>See basically I have given option to user for printing records
>say all records or selective on periodic basis so it will totally
>depends on the recordset that is how many records are there and
>while printing them I want to give serial no for that.
>Ok, I have try out with a label pasted on report and just changing
>it's caption with a variable which increment with next record.It
>shows perfectly in debuging but at end label caption get the value
>of the last record.
>e.g. say there are 25 records then it shows 25 against each record
>as record no.
>So if there is any solution then pls. tell me immediatly.
>Also I have got another query for you but since I am making R&D on
>that so just wait may be I need your help for the same.

DataReport doesn't trigger an event on each line processed. Maybe your solution is to build an in-memory (disconnected) recordset, in which you can put the value you want, and then bind this recordset to the DataReport!

Actually, I'm working with DataDynamics ActiveReports report maker. It is by very far a best product.

Another question, does your serial number have to be contiguous? If not, you can have a Identity (or autonumber) field in your database that will provide a unique serial number.