CR 6.0

Ronnie D. Franklin ( ronnie@itexas.net )
Mon, 27 Apr 1998 09:46:48 -0500

I looked through the last thread that discussed Crystal Reports and did not
find my answer, so maybe someone else has the answer!!

I installed CR 6.0 and most of the reports work fine, however I have
several that come up with "ODBC error"[Microsoft][ODBC SQL Server
Driver]Driver not capable" when I try to print or preview it.

Example....

The SQL Statment for one of the reports is:
====================
SELECT
MasterAccounts."FirstName", MasterAccounts."LastName",
MasterAccounts."Company",
Payments."Amount", Payments."Date", Payments."PayInfo"
FROM
"Emerald"."dbo"."MasterAccounts" MasterAccounts,
"Emerald"."dbo"."Payments" Payments
WHERE
MasterAccounts."CustomerID" = Payments."CustomerID" AND
Payments."Date" > ?
ORDER BY
Payments."Date" ASC
====================

This report works fine with CR 4.5...

Anyone have any thoughts???

Thanks,

Ronnie@itexas.net