Home » Developer & Programmer » Reports & Discoverer » URL for report Submittal
URL for report Submittal [message #213870] Fri, 12 January 2007 10:28 Go to next message
smugnos
Messages: 5
Registered: January 2007
Junior Member
We have a consultant here who is setting up Oracle report server for us. I was wondering how I can determine what the URL is to use to submit a report?

Thanks - Sal
Re: URL for report Submittal [message #213889 is a reply to message #213870] Fri, 12 January 2007 12:39 Go to previous messageGo to next message
bsmith18
Messages: 8
Registered: April 2006
Junior Member
It depends on App Server version and OS. I am using Oracle 10.1.2.0.2 App Server on Linux AS 4. I will give a description to execute a report using a browser to execute a report saved in a jsp format and to output the report to the browser in an html format. The description will be in a written form for you to understand what info needs to be entered according to your environment. Then I will show an actual examples.

http://"servername or ip"/"http server listening port"/reports/rwservlet/?SERVER="name listed for server variable in rwservlet.properties file"&REPORT="path to directory where reports resides on server"/reportname&USERID="database schema where data for report resides"/password@database&DESFORMAT=html&DESTYPE=cache

The default http server listening port for Linux or Unix is 7777 and 80 for Windows. It can be changed at time of installation to a different port.

Linux Example:

http://reportsserver.yourcompany.com:7777/SERVER=rep_reportserver_bif&REPORT=/home/oracle/reports/samplereport.jsp&test/test1 23@test&DESFORMAT=html&DESTYPE=cache

Windows Example:

http://reportsserver.yourcompany.com:80/SERVER=rep_reportserver_bif&REPORT=\home\oracle\reports\samplereport.jsp&test/test123 @test&DESFORMAT=html&DESTYPE=cache

Hope this helps!
Brad Smith
Re: URL for report Submittal [message #213991 is a reply to message #213889] Sat, 13 January 2007 07:01 Go to previous messageGo to next message
skooman
Messages: 913
Registered: March 2005
Location: Netherlands
Senior Member
Another suggestion: usually, in the install directory there remains a readme.txt, this also contains the URL's.
Re: URL for report Submittal [message #222689 is a reply to message #213870] Tue, 06 March 2007 00:10 Go to previous message
SpeakurMind
Messages: 14
Registered: June 2006
Junior Member
Hi,

Can someone let me know as to what the maximum length of the URL string that could be formed? I believe in IE browser a maximum of 64,000 characters can only be formed. If I need to pass many parameters and the length of the values passed exceeds the default length in IE, the rest of the values will not be captured in the report server.

Please let me know on how to proceed with this problem.
Previous Topic: Scheduling of Reports Issue (Not being picked up and run)
Next Topic: what is the maximum size of parameter that we can pass thro URL .......
Goto Forum:
  


Current Time: Fri Dec 06 23:51:43 CST 2024