Can't use more than 3 tables in a report

[OrangKampung]

OK..the problem is like that.I connect the crystal report to MYSQL using ODBC.

Everything work perfect when i am just using 1 or 2 tables in a report. I use left outer join to connect each table.

But the problem occur when i am using the data from 3 or more tables in a report.It always appear a message " Fail to open a row set" What wrong actually?

Thanks for help.

[sotoasty]

I would suggest you verify your SQL systax is correct. I am able to select from 4 tables using a natural join with no problems.

If you can't get it to work, try the MySQL ODBC List.

[OrangKampung]

This is the SQL query that generate from Crystal Report,before i run the project, i click on -> verify database to make sure that the databse is up to date.. but the problem still the same.. same message "fail to open a row set"..what happen actually? hope u can help me..thanks a lot.

And what do u mean by try the mySQL ODBC list? Did I need to modify something there?


SELECT `action`.`ActionDate`, `account`.`ClientRefNo`, `debtor`.`Name`
FROM {oj (`account` `account` LEFT OUTER JOIN `action` `action` ON `account`.`AccountNo`=`action`.`AccountNo`) LEFT OUTER JOIN `debtor` `debtor` ON `account`.`DebtorID`=`debtor`.`DebtorID`}

[sotoasty]

MySQL has a "Help" Mailing list for ODBC. Check out...
MYSQL List Page

I will try to help out some later if I get a chance.