How to call Reports from browser 1

mrm312 · Feb 4, 2004

I am new to Oracle reports, but I have just created a few reports using Report Builder 9i Developer and am trying to find out how to integrate them into my web application.

The backend is running on Oracle 8.1.7, and the web application was programmed using PL/SQL with embedded HTML and is using an Apache web server.

The goal is to be able to click a hyperlink and pull up the reports as a .pdf. in a new window.

Suggestions on how/where to start?

Thanks,
mrm312

nagornyi · Feb 4, 2004

Here is a piece from Oracle doc:

Modify the template information below to match your environment:
1. Change the http command to match your server name and call the cgi or cartridge.
2. Create the reports you are running and add names to this html file.
3. Copy the information below into a text file and name .html
(This will create your html form to call over the web).
4. Copy the file into your webserver document directory, e.g. c:\orant\ows\doc
5. Call the file from your web server

http://<hostservername>/<doc_directory>/<filename>.html

This will call the html file, now you can run your report.

NOTE:
There may be a problem calling reports that do not have a parameter form.
Suggestion: Create one form for reports with a parameter form and one for reports without a paramform.
DISCLAIMER:
This code is not supported by oracle support. This information is only meant to
help create a html form. If the report runs fine
from the browser alone however runs slow from the browser then it would not an oracle issue.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
copy below this line
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
<html>
<head>
<TITLE>List of SunCollect Reports</TITLE>
</head>

<BODY bgcolor="white">

<form METHOD=GET ACTION="

http://<machine-name>/<ows-bin/r30cgi32.exe

or r30ows>?"



<center>

<font color="red"><H1>Select the desired report:</H1></font>

<BR>
Report Name :
<INPUT name=report type=text value="empparm.rdf"><BR>

Static URL Information:
<INPUT name=server type=text value="rep30"><BR>
<INPUT name=userid type=text value="scott/tiger"><BR>
<INPUT name=destype type=text value="cache"><BR>
<INPUT name=desformat type=text value="pdf"><BR>
<INPUT name=paramform type=text value="html"><BR>

Output Format:
<SELECT name=report>
<OPTION value=emp.rdf selected> employee-report
<OPTION value=empparm.rdf> paramater-report
</SELECT> <BR>

<HR><INPUT type=submit value="Run Report!">

</CENTER>
</FORM>
</HTML>

--------------------------------------------------------------------
copy above this line

mrm312 · Feb 4, 2004

Thanks! I will give this a try and see what happens.

Mike

mrm312 · Feb 5, 2004

Is there any documentation out there on how to configure the 9iAS server to be able to test this code?

Thanks...

nagornyi · Feb 5, 2004

Info is here, but it requires metalink password:

http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=131810.1

kenatu · Feb 10, 2004

this post is a life saver thanks. but if you guys don't mind could you break down those steps for me a bit. i'm trying to acheive sort of the same thing. i'm suppose to call an oracle report using a url,passing the parameters and values in the url. this is sort of urgent. it will be done from a java based application. if you can help thanks. as you may can tell i'm not even sure what i should be asking for.

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

How to call Reports from browser 1

mrm312

MIS

nagornyi

MIS

mrm312

MIS

mrm312

MIS

nagornyi

MIS

kenatu

Programmer

Similar threads

Part and Inventory Search

Sponsor