R&R 10+ and MySQL 4

[Brian_Craig_(Guest)]

I have created a report using an ODBC connection to a MySQL database. The connection is configured properly and has successfully connected to the database. I can choose the table I want, pick the fields, and enter the filter information. When I export the report, the report selection dialog box comes up and counts records read, but doesn^t select any. Also, there are 73 records in the database, and when I stopped it, the report had read 1.2 million.____I am running RR10+ on Windows XP SP1.____Regards__Brian

[kfleming]

Have you tried using Limit Result Set?____Kathleen__R&R Support

[Brian_Craig_(Guest)]

I have tried limiting the result set to 100 and it doesn^t appear to make a difference. Even if I limit it to 1 and go to ^View Result Set^, the Records Read continuously increment until I cancel the operation.____I am using version 3.51.9 of the MySQL ODBC driver. The driver works ok with another reporting product. I have checked and I am running the latest version of R&R 10+.

[StanleySit]

I^m also experiencing the same problem. Has a solution to this been found?____Thanks,__Chris