I am trying to call an Oracle Report from APEX. (4.2)
Does anyone know how this works? I have heard by URL?
The rdf/rep-file is on our file system, but how can I get the report running. I would be nice if a user clicks a button, the report will popup (redirect to URL when clicking on button?)
OF course I have searched on google, but I do not know what to use a URL.
If you are running Forms apps, then you PROBABLY have the Reports applet running too... If not, then you CAN'T run Oracle reports directly from APEX< you need the Reports applet running to execute the report..
that runs reports via: c:\orant\bin\rwrun60.exe rep_name.rdf
That is the old client/server version of Reports 6i. You cannot use that in Apex. You need the web version if you want to call a report directly from your Apex app.
If a web version is not possible at all, and you really need this report to run from Apex, you may get this to work:
- Create a batch job with dbms_scheduler to run an external command file.
- This command file runs the report using rwrun60.
The problem is where to put this bat file. It will very like not be on the database server, but on some machine where Developer 6i is installed. So, you also need to enable running remote batch jobs with dbms_scheduler.
NO, since it is pretty much a BAD idea to run local applications through a browser. Instead IF you want to use those Oracle Reports, you will need to install the Reports server applet OR redevelop them as APEX report pages..
The problem is, the reports are already developed and now started from a Forms 6i application. That application is migrated to APEX, but they still want to use that old reports. We don't have time to convert them to... I really don't know to what actually...
Simplest way is to start the reports from APEX, if that is possible. What is the Reports server applet you mentioned?