This approach only requires Oracle Report Server installed on the machine/server and responding on its port 8889.
- Verify that you have all license rights to install Oracle Report Server
- Install a PDF reader (personally I love foxit reader)
- Verify that these environment variables are set:
REPORTS_PATH = C:\your_reports_folder;
PATH=C:/DevSuite10_home;C:/OLD_DevSuite9_home;etc...
Important: Make sure your latest Dev
Suite is on your PATH environment variable first, before any older versions! - Start OC4J
- Start your web browser and run your report using this sintax:
http://<reports server name>/reports/rwservlet?report=<report file name>&<other report parameters>
Example:
http://localhost:8889/reports/rwservlet?report=rep_007.rep&userid=username/password@192.168.19.58:1
521/ORCL&desformat=pdf&destype=cache&YOUR_REPORT_PARAMETER1=image.bmp&OTHER_REPORT_PARAMETERS=...
Common problems:
If your report calls other libraries, these must be in the same directory of the report, and must be compiled/recompiled with Oracle reports builder 10g.
To avoid errors like the following:
Not able to load oracle.reports.util.EnvironmentGlobal class
Using oracle.reports.util.Environment class
you must also generate/regenerate REP file using 10g Report Builder AND check whether the file/folder has enough privilege to the logged in user.
If you still have problems try to copy it to another folder: there might be problem with the acess right in your folder.
For reference:
Useful guide to Oracle Reports http://www.rittmanmead.com/files/quick_start_guide_oracle_reports.html
Using the Oracle Reports Web Service http://download.oracle.com/docs/cd/B10464_05/bi.904/b13673/pbr_webservice.htm
In the case that you can't use report server and you're forced to use something on the clients, thake a look at
http://www.orafaq.com/forum/t/37321/2/
