OraFAQ Forum: Reports & Discoverer » URL for report Submittal

Home » Developer & Programmer » Reports & Discoverer » URL for report Submittal

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

URL for report Submittal [message #213870]

Fri, 12 January 2007 10:28

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

Report message to a moderator

Re: URL for report Submittal [message #213889 is a reply to message #213870]

Fri, 12 January 2007 12:39

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

Report message to a moderator

Re: URL for report Submittal [message #213991 is a reply to message #213889]

Sat, 13 January 2007 07:01

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.

Report message to a moderator

Re: URL for report Submittal [message #222689 is a reply to message #213870]

Tue, 06 March 2007 00:10

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.

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 03 05:01:02 CDT 2024