How to print selected data in VB 6 Data Report

5 pts.
Tags:
VB 6
VB Data Report
VB Data Report designer
Visual Basic
Visual Basic 6
we were about to create a system that generate eport such as daily weekly monthly and annual... and we dont know how to do it.. plz.. help us..

Answer Wiki

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

Example
1. add textbox and command1 in a Form
2. add label1 and set a caption “Bill No”
4. add dataenvironment1
5. Set connection1 in Dataenvironment of your database file name
5. add command1 in Dataenvironment and type a query in sql as following example
SELECT * FROM BillTable WHERE Billno = ?;
6. Design a report of Datasource : DataEnvironment1 and Datamember Command1
7. Add Click Event of Command Button in Form
Private Sub Command1_Click()
If Dataenvironmanet1.Connection1.State<> 0 Then
Dataenvironmanet1.Connection1.Close
End If
Dataenvironmanet1.Connection1.Open
Dataenvironmanet1.Command1 Text1.Text
DataReport1.Show
End Sub
8. Run This Program
9. Type a bill No in Textbox
10. Click on Command1
You can See only selected BillNo Report

Discuss This Question: 3  Replies

 
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
  • carlosdl
    I think you will need to be more specific in your question in order to get useful responses. What exactly is what you don't know how to do it ?
    68,525 pointsBadges:
    report
  • AS400Operator
    How do I create a report from daily backup?
    80 pointsBadges:
    report
  • proseo
    lets make some example, I have one form then i have 4 textboxes, the name,address,age,gender then one button. after filling all the required fields. The inputted datas will normally add to the database, what I want is after clicking the button, I will generate a report just for the details of the my latest action.
    10 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