DevOps, CI/CD and Automation

Hi,

There are 2 ways to do it.

1. Inside your asp application you can call Oracle reports using HTTP, ie, for paper layout use
http://machine:port/reports/rwservlet?report=...
for web layout (JSP's) deploy the report on a J2EE application server and access it
http://machine:port/reports/your_folder/Report.jsp?server=...

For complete information take a look at Publishing Reports to the Web (Chapter 8)
http://otn.oracle.com/products/reports/htdocs/getstart/docs/index.html

2. If you use upcoming Oracle Reports 10g, you should be able to use the Web Service interface to submit jobs from your application, and do some other operations. Documentation for this will also be included in the "Publishing reports manual" with the release.


Navneet.

This looks like it pertains to Reports 9i. Is is also possible to save the report definition as a JSP in Reports 6i? If not, how do I save it so that ASP can call it?

(1) In 6i you cannot save report as JSP
(2) In 6i to run to web you can use "rwcgi60" executable. You can use rdf format itself. From ASP give a link something like this

http://host:port/cgi-bin/rwcgi60?report=test.rdf+destype=cache....
(3) Another option is to run using Web cartridge and Reports thin client for 6i. Please refer 6i docs to see the steps in
details

Thanks
The Oracle Reports Team

Thanks, I used the rwcgi60 and that worked! Now, is there a way to pass parameters (connect string and user-defined report parameters) to the report without hard-coding them in the url?

We can't use the thin-client approach because our customer will not allow individual client-installs.

Thanks,
Jenny

1) To display user params give paramform=yes
2) For sensitive things like db conn which you would like to hide from user include keys in "cgicmd.dat" file

You can see cgicmd.dat file in $OH\reports\cgicmd.dat. There are lot of examples in the file to get started. Please refer docs for further details

Thanks
The Oracle Reports Team

Hi,

Can you help me how to run the oracle reports from asp.net.
And how to access the parameter values from asp.net screen to oracle reports.

Thanks,
shiva