Converting Crystal Reports from Progress to Oracle8i 1

[Sullikit]

I have created several reports using an ODBC driver for Progress92 and now I must take the same reports and change them to Oracle8i.

I have succesfully done this to one report wich was very simple. A second report was as simple put contained a date parameter and a String parameter. The string parameter works fine but when I try to use the date parameter I get an Oracle error message
ORA-00928 missing SELECT keyword

Cause: A SELECT subquery must be included in a CREATE VIEW statement.

Action: Correct the syntax. Insert the required SELECT clause after the CREATE VIEW clause and then
retry the statement.

I have tried to have the simple report with a date field onit and I get the same error even though it is not a Parameter or a Select Field.
Does anyone know of Oracle 8i ODBC issues this might belong to?
Kitrina Sullivan

 

[MalcolmW]

It sounds like the report is based on a Progress view, via ODBC. Have you recreated this same view in Oracle? You may need additional database administration rights to do so. Malcolm

 

[Sullikit]

Hi Malcolm.
I did try this same report design again but straight against Oracle8i.

I got different results this time. I got issues of the third tble in the join would not let me use any of the fields. I get an error stating that it is missing a select statement.

Does anyone know if The Oracle8i ODBC driver has problems writing the SQL Statments in the correct manner and the only way to deal with this is to go directly into the SQL Statement and alter it.

Thanks Kitrina

 

[Sullikit]

To all who may read this string !

The issue above was caused by the Oracle8i ODBC level compared to the Crystal Dll
So the Crystal Dll could handle two tables but not more than that. It was not rewriting the SQL Statement.

Kitrina Sullivan