15 pts.
 How to generate Serial No. in VB 6 Data Report
plz tell me to generate serial no in data report and iam using through data envornment and i dont have any srial no column in my database so plz tell me any trick or code to generate serial no in data report ....

Software/Hardware used:
ASKED: April 11, 2009  11:45 AM
UPDATED: April 17, 2009  1:08 AM

Answer Wiki:
What database are you using ? If you are using Oracle, you could add the pseudocolumn ROWNUM to your query, and use it as the serial number. Other databases could have something similar. Another (and more complex) option could be to retrieve your report's data into a temporary recordset, then construct another recordset, add and calculate a serial_number field programmatically to it, and then set this new recordset as the source of your DataReport before calling it.
Last Wiki Answer Submitted:  April 17, 2009  1:08 am  by  alessandro.panzetta   9,660 pts.
All Answer Wiki Contributors:  alessandro.panzetta   9,660 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _


 

Sir i didnt understand what r u saying about?
date function as a serial no….can u send me a program frm which i can understand!!!!!
Thanks!!!!

 15 pts.