I am trying to convert my reports in a fairly new project from ODBC to VFP7's OLE-DB, but am unable to get them to return any data. I get a "No recordset returned" message. By process of elimination I discovered it was a problem with several left outer joins in the report.

In desperation, I tried creating a trivial report and then adding a single, simple left outer join. No dice.

Anybody else have any experience with this?

...Jim