We are using the Merant ODBC drivers to connect a 5 user site license of
Crystal Reports version 7.0 to QAD. Everything connects up fine - you open
Crystal Reports and see all of the QAD tables, but once you
pick the tables, setup the relationships, etc and go to create the sql
statement, we get an error message. After calling Crystal Reports technical
support, it appears that there is a bug in Crystal Reports which chops off
the sql statement - thus the entire statement cannot be read, so the report
will never run.
We are now using the same Merant ODBC drivers to connect to Microsoft Access
and are running our report that way. Still testing, but at least we have
one remote client up and running.
I will probably return the Crystal Reports program. If anyone has had
better luck with Crystal, I'd be interested to know.
bye,
Arden Evans