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