Home » Developer & Programmer » JDeveloper, Java & XML » Help me...passing parameters thru java screen to oracle reports
Help me...passing parameters thru java screen to oracle reports [message #91859] Tue, 27 May 2003 06:12 Go to next message
rc
Messages: 9
Registered: July 2001
Junior Member
Hi all..
Anybody post me the solution to pass a parameter from a java screen to a oracle report.
My requirement is ...
I should generate oracle reports from a screen which is developed in java,On clicking of a button I should call a report, which is deployed in a application server,While clicking I should also pass the values that are get selected from the screen
So that I can query it from DB.

Ques:

I found the way to call the report thru link

http://hostname:8888/reports/test/report.jsp?userid=DBconnection (this is for calling a jsp file)

http://hostname:8888/reports/rwservlet?report=report.jsp&userid=DBconnection&destype=cache&desformat=PDF (this is for calling a jsp file that will be generated in PDF)

got it..?

Now the thing is how to pass the parameters thru this link,is there any way..?

Thanx in advance
-RC

Report message to a moderator

Re: Help me.passing parameters thru java screen to oracle reports [message #92453 is a reply to message #91859] Thu, 22 July 2004 03:32 Go to previous messageGo to next message
claude comtois
Messages: 2
Registered: December 2002
Junior Member
Hi there.

In your link to call the report, where is your report on your hard drive? I tried the string but I do not know where to put the report. For someone who hasn't done this before there is no explanation on where the report should be.

Thanks in advance.

Report message to a moderator

Re: Help me.passing parameters thru java screen to oracle reports [message #92752 is a reply to message #91859] Thu, 06 January 2005 08:21 Go to previous message
Marian Scheianu
Messages: 2
Registered: May 2003
Junior Member
Here is my solution, using Oracle 9i Reports on Linux SuSE 8.0:
- Create a paper only report, with a data query like:
select * from employees where de4partment_ID=:dep_id
- save the report as something.rdf
- put the report something.rdf in the report server path
- start the report server and the application server: rwserver and Oracle 9i AS (startinst)
- from a browser enter something like:
http://localhost:8896/reports/rwservlet?report=something.rdf&destype=cache&desformat=html&userid=hr/hr@ora1hpp1&DEP_ID=60

I can provide more details if the case.

Cheers
John

Report message to a moderator

Previous Topic: problem installing jinitiator
Next Topic: JAVA Exception Error - Causes?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 04:49:09 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.