How to generate Serial No. in VB 6 Data Report

15 pts.
Tags:
VB 6
VB Data Report
Visual Basic
Visual Basic 6
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 ....
ASKED: April 11, 2009  11:45 AM
UPDATED: April 17, 2009  1:08 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • 11a
    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 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following