Crystal Enterprise and SQL Expressions

[sharinad]

I have several reports that have been modified to use sql expression to improve response time. However, the report will run fine on the client running in CR, but will not run on Crystal Enterprise. Any ideas?
We are running Crystal Reports/Enterprise 9 with Oracle 8i and Lawson 8.0.3.

 

[Turkbear]

Hi,
By 'will not run', what do you mean?

No data, error messages, server explodes ( well, probably not that)...


More info please..

 

[sharinad]

run fine in crystal reports, but get the default error message "Crystal Reports: Print Engine Error " when I try to run it on enterprise.
Tried both saving it with and without saved data.

 

[mikiap]

I get the same error.
Any ideas?

 

[sharinad]

My problem was corrected after the upgrade to 9i. Then I noticed that the ODBC driver and the native oracle drivers had a different command set available. In my case I had to change the functions I was using on the ODBC to the oracle ones (left and right to substr, substring to substr, ifnull to NVL, etc.)

Hope this helps