How to print selected data in VB 6 Data Report
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..
Software/Hardware used:
Software/Hardware used:
ASKED:
January 15, 2009 6:44 AM
UPDATED:
April 9, 2012 3:27 PM
Answer Wiki:
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
To see all answers submitted to the Answer Wiki: View Answer History.
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 ?
How do I create a report from daily backup?
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.