OraFAQ Forum: Reports & Discoverer

Home » Developer & Programmer » Reports & Discoverer » deploying reports

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

deploying reports [message #167474]

Thu, 13 April 2006 04:28

kal_youssef
Messages: 25
Registered: September 2005
Location: canada

Junior Member

Dear Oracle Colleuges
How is it going?
Im new to this forum so i wanted to first say hello to everyone

Im new to building oracle reports and im using oracle reports 9i ok.
My issue is how do i deploy oracle reports online?
I created a couple of jsp reports but i still dont know how to run them on the web. What i mean is i will put the link to these reports on my service desk and so when the client clicks it the report should run.
I dont have an application server installed its only the Oracle 9iDS thats installed.
Anyone that can present me with the proper steps will be greatly appreciated.
regards
K.

Report message to a moderator

Re: deploying reports [message #167507 is a reply to message #167474]

Thu, 13 April 2006 07:34

sanka_yanka
Messages: 184
Registered: October 2005
Location: Kolkata

Senior Member

Hi,
Oracle 9iDS is enaugh to run the reports from Http service if on ur machine OC4J is installed.
First do one thing
Start OC4J instance and open Internet Explorer then give the
URL http://<MachineName>:8888/reports/rwservlet
where <MachineName> means ur pc name.
The page like the below will be opened.

http://in.geocities.com/sanka_yanka/error.JPG

Now first set your reports path from the regeistry by giving the command on dos cell regedit
Now go through the path on registry
My Computer\HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0
find the REPORTS_PATH on your <ORACLEHOME>
Append it and Set your own path where your reports are stored.
Now run your own report by issuing the command

http://<machineName>:8888/reports/rwservlet?
destype=cache&mode=default&desformat=PDF&report=<reportName>.jsp
&userid=<userName>/<password>@<ConnectingString>
&P_LOCATIONCODE=01&P_MONTH=FEB&P_YEAR=2006

where <reportName> is your report name

and P_% -- parameters

Try it out.

Thanks & Regards,
Sanka

Report message to a moderator

Re: deploying reports [message #167604 is a reply to message #167507]

Fri, 14 April 2006 08:25

kal_youssef
Messages: 25
Registered: September 2005
Location: canada

Junior Member

Sanka

Thanks for the quick reply

I tried it on an oracle database it works good thanks

However when i try to run this using a sql server database i get the error:

REP-51002: Bind to reports Server rep_server failed

The link i used was:

http://localhost:8888/reports/rwservlet?
destype=cache&mode=default&desformat=PDF&report=ogers.jsp

I think its a connection error what do you think?
regards
Kal

Report message to a moderator

Re: deploying reports [message #167732 is a reply to message #167604]

Sun, 16 April 2006 04:59

sanka_yanka
Messages: 184
Registered: October 2005
Location: Kolkata

Senior Member

Yea,

U r right. It's a connection error, u must supply a connection string with ur parameter calling on the &userid= parameter.

Report message to a moderator

Re: deploying reports [message #167746 is a reply to message #167732]

Sun, 16 April 2006 07:07

kal_youssef
Messages: 25
Registered: September 2005
Location: canada

Junior Member

Hey Sanka

I dont think the userid works for SQL SERVER 2000 databases does it?

When i run the oracle database i run it online and i do use the userid it just hangs up but on sql server i cant run web reports at all because i cant setup the jdbc connection!!

So my first problem is enabling jdbc from oracle reports directly and second is:
Oracle reports online hang for a long time.

Any advise would be appreciated
regards
Kal

Report message to a moderator

Re: deploying reports [message #167968 is a reply to message #167746]

Tue, 18 April 2006 03:17

kal_youssef
Messages: 25
Registered: September 2005
Location: canada

Junior Member

Sanka

I solved the sql server problem with the JDBC so dont worry about that Smile

Im testing my new report on the web and when ever i run the report online i get the error below:

Regards

Kal

Attachment: oraclereporterror.pdf
(Size: 32.16KB, Downloaded 1963 times)

Report message to a moderator

Parameter prompting [message #168891 is a reply to message #167507]

Mon, 24 April 2006 01:27

kal_youssef
Messages: 25
Registered: September 2005
Location: canada

Junior Member

Sanka
How are you?
How is life?

Thanks for the help sanka you directed me in the right direction i have one last question for you

1. In the URL you typed P_% parameters so this means that you can prompt the user for values they desire right?
How do i do this? Do i set this in the sql query? or where
thanks
kal

Report message to a moderator

Re: Parameter prompting [message #168927 is a reply to message #168891]

Mon, 24 April 2006 04:07

sanka_yanka
Messages: 184
Registered: October 2005
Location: Kolkata

Senior Member

Hi Kal,
For getting the Values for the Parameters you have to create a parameter form where u can take input values from the user and after that u'll call the report from that paramter form.

Thanks & Regards
Sanka

Report message to a moderator

Previous Topic:	run custom report in oracle applications
Next Topic:	Font Problem in Reports 10g

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 11:39:29 CST 2024