Syntax error 20003 on compiled report

[vandaliarental]

I am trying to get a client machine up & running with compiled reports. I've installed the driver software (Dharma) to connect to the ODBC database and tried a test report in MS Query to make sure it was working correctly.

I wrote a simple report in Crystal, using only 1 table, and compiled, transferred the 3 files to the client machine and it worked.

Then I wrote another simple report, joining 2 tables, compiled it (testing it on my machine first) and transferred the 3 files. When I ran this report, I received the following error:

Seagate Crystal Reports: Database Error
ODBC error: [Dharma][ODBC Dharma Driver 06.20.1001][Dharma/SQL]-20003

Any ideas?

Thanks