Data Report Connection

[Johann]

How to connect Data report to a database without the data environment?

[HansV]

See if the attachment to Use Data Report without Data Environment helps.

[Johann]

Doesn't help. There is no code. :/. How to put datasource to data report without using data environment??

[HansV]

Have you looked at the Visual Basic project in the zip file?

S102.png

[Johann]

Yes!. But they are not connected to each other. Data report has no codes or they are not in one program

[HansV]

I can't test this myself - I only use the Office applications, not VB or VB.Net - but as far as I can tell, the data source is set from the form:

Code: Select all

Private Sub cmdShowReport_Click()
Set rs = db.Execute("select *from student")
If rs.EOF = False Then
    Set DRSample.DataSource = rs
    DRSample.Show
End If
End Sub