Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Crystal Reports integration with Oracle 9iAS
We have developed many Crystal Reports w/ CR 8.5. These were all run
against an Oracle 8i database through an Oracle 6i Forms. We are now
moving to Oracle 9i database and Oracle 9i Application Server. Have
moved the Forms 6i to the Application Server and everything works
great except the reports.
We cannot get them so the user can view and then print the report form their workstation using the Oracle Forms interface. We have tried the HOST command and the ORA_FFI. They do not run.
I have opened a TAR with metalink.oracle and this was their response.
We do not have any information about the Crystal Reports integration with Oracle Forms 6i as Crystal Reports is a 3rd party application. You can try using Host command or ORA_FFI functionality. To reiterate, ORA_FFI and Host commands all execute on the middle tier, not on the Java Client. This implies that they cannot carry out any user interface interaction, as the display being used by the user is not the same display as the middle tier. Hence, the web forms client/user cannot view and interact with the report, as the report is not visible to him.
FORMS SERVER RESTRICTIONS
I would like to avoid redoing all of the many complex reports in Oracle. What alternatives do we have? Received on Wed Mar 03 2004 - 12:32:57 CST