Problem with DataReport and Mysql Database

[corneagigi]

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

[wes4dbt]

Need to see how "rs" is created and filled.

[leinad31]

Are you sure your not using the report header or page header to display the records? Use the details section for the records.

[corneagigi]

rs is the connection recordset and it works really good in any other case....but here I encouter this problem

[Hack]

Moved to Reporting

[wes4dbt]

As Leinad31 suggested, are you sure "section1" is the report detail section name.