Data Reports

[ANTY90]

I want to print the bill report from within VB6.0 instead of Word. How to print any info using data reports?
Awaiting your reply.

[lotus18]

Hi

Select Project > Add Data Report, then that's it
BTW, are you using DAO or ADO?

Rey Sean

[Ali Rizwan]

I want to print the bill report from within VB6.0 instead of Word. How to print any info using data reports?
Awaiting your reply.

Add a data report as lotus says.
Now add rptrlabels and rptrtextboxes.
You need a data environment to be add and connect it with your database connect your data report to data environment and connect labels and textboxes with commands added in data environment.
Now when you run the data report the bill was build automatically.

If you need any more help in databases of such type you can contact me using yahoo. You can find my id from my profile.

Regards

>> ALI <<

[ANTY90]

but how to connect a database to a data environment
it would be of great help if u give an example with a little coding

[werks]

Happy New Year..

Try this..

frmPreview

Private Sub chPreview_Click()
     rptBookreport.Show
End Sub

Now add this code to your Datareport..

rptBookReport

Option Explicit
Dim adoReport As New ADODB.Recordset
Private Sub DataReport_Initialize()
     Set adoReport = New ADODB.Recordset
     adoReport.Open "SELECT * FROM tblBooks", CoNN,  adOpenStatic, adLockReadOnly
     Set rptBookreport.DataSource = adoReport
End Sub
 
Private Sub DataReport_Terminate()
     adoReport.Close
     Set adoReport = Nothing
End Sub

Hope this help you..