Data Report records Serial Numbers

[rohit.engineer]

Hi ALL,

I am facing a problem while designing a data report. I am using ADO data Environment for getting the data from the Microsoft Access database. I want to include serial number for the report entries. Could any one suggest me how can i do it.

Like now entries are coming like this

rohit 21 India 200
Varun 22 India 200

I want the entries like

1. rohit 21 india 200
2. varun 21 india 200

How can i do it

I have an another question also
Application i am developing is a database application it contains entries upto several pages i want that in a report sum of all the entries in a page comes last in a page an this sum carry forwrds to the next page also

suppose there are two entries in page 1
1. rohit 21 india 200
2. varun 21 india 200
sum = 400
this sum should be carry forwards in the top of the next page
like this
previous carry = 400
1. ro 21 india 300
2. va 21 india 500
sum = 1200
Thanks
Rohit

[KGComputers]

Hi!!!

suppose there are two entries in page 1
1. rohit 21 india 200
2. varun 21 india 200
sum = 400
this sum should be carry forwards in the top of the next page
like this
previous carry = 400
1. ro 21 india 300
2. va 21 india 500
sum = 1200

Try creating a module and declare a variable that would receive the value for the previous carry and sum..Then add the previous value to the present value to obtain a new value...You could do likewise to the serial number....

[rohit.engineer]

Hi!!!



Try creating a module and declare a variable that would receive the value for the previous carry and sum..Then add the previous value to the present value to obtain a new value...You could do likewise to the serial number....

Hi KGComputers

Thanks for responding to my query.
Since these entries goes to different pages.
How could we access the different pages in a data report
Is there any way.
Could you tell me in more detail how could i do it

Thanks
Rohit

[stockton]

i'm having the same problems, i too need to carry the sum for each page, and put secuencial numbers.. and i can't find any way to do this :S .. if you can find how to do that, please let me know ([email protected]).. i'll do the same

[rohit.engineer]

For this the better solution is use the MSH Flexgrid for creating the
Data Report
Create a temp Record set from the grid values and assign it to data report
This will solve your sequential problem
for the problem of page total you have to set your page length according to records in a page required
Then insert this page total value in the the record set after the number of records that fit into a page
This will solve your problem

rohit.engineer
[email protected]