khushbuj
November 22nd, 2006, 08:37 AM
Hi,
I have made a new Oracle 10g XE database and connecting report via Crystal Report 10 tool directly as no ODBC is been used in my application.
Now what happening is ,when I am running the report it is giving me error no 000936( Missing expression syntax) in query of SQL Expressions.I have changed them to support oracle XE also tested in query browser ,there they r running perfect,but not in crystal report 10 environment.
strange part is that even i delete the whole query from the SQL Expression area then also getting same error.
Its difficult for me to understand the reason.
is this connection issue with database or some compatibility problem in b/w oracle XE and crystal report 10.
I would appreciate the efforts,if any one know the reason or can guid me for the same.
Note: This whole exercise i am doing on already prepared reports, which were previously using MS-SQL as DataBase.
I have made a new Oracle 10g XE database and connecting report via Crystal Report 10 tool directly as no ODBC is been used in my application.
Now what happening is ,when I am running the report it is giving me error no 000936( Missing expression syntax) in query of SQL Expressions.I have changed them to support oracle XE also tested in query browser ,there they r running perfect,but not in crystal report 10 environment.
strange part is that even i delete the whole query from the SQL Expression area then also getting same error.
Its difficult for me to understand the reason.
is this connection issue with database or some compatibility problem in b/w oracle XE and crystal report 10.
I would appreciate the efforts,if any one know the reason or can guid me for the same.
Note: This whole exercise i am doing on already prepared reports, which were previously using MS-SQL as DataBase.