Problem with DataReport and Mysql Database
Hy
I am building an application that is using an mysql database and I am trying to build Datareports using ADO data control.
My problem is that in the reports it puts me only the first record from the database for "Number of records" times, so I can't see all the records I need.
My code looks like this:
With DR
Set .DataSource = rs
.Sections("section1").Controls.Item("Txt0").DataField = rs.Fields(0).Name
.Sections("section1").Controls.Item("Txt1").DataField = rs.Fields(1).Name
.Sections("section1").Controls.Item("Txt2").DataField = rs.Fields(2).Name
.Refresh
End with
Waiting for your response.
Thanks
Re: Problem with DataReport and Mysql Database
Need to see how "rs" is created and filled.
Re: Problem with DataReport and Mysql Database
Are you sure your not using the report header or page header to display the records? Use the details section for the records.
Re: Problem with DataReport and Mysql Database
rs is the connection recordset and it works really good in any other case....but here I encouter this problem:(
Re: Problem with DataReport and Mysql Database
Re: Problem with DataReport and Mysql Database
As Leinad31 suggested, are you sure "section1" is the report detail section name.