Home » Developer & Programmer » Reports & Discoverer » Help me out..Passing parameter to Oracle 9i report from java screen
Help me out..Passing parameter to Oracle 9i report from java screen [message #88874] Mon, 26 May 2003 00:32 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..?

Report message to a moderator

Re: Help me out.Passing parameter to Oracle 9i report from java screen [message #89380 is a reply to message #88874] Wed, 03 March 2004 23:20 Go to previous message
Raj
Messages: 411
Registered: November 1998
Senior Member
temp_url := 'http://wi3W31:8888/reports/rwservlet?userid=PRDBA_TEMP/XYZ@oradd&report
=Prov_vsls.rdf&destype=cache&desformat=htmlcss&VSL_ID='||:CNTRL_BLK.VSL_ID||'&SLT_ID='||
:CNTRL_BLK.SLOT_ID||'&START_DAT='||:CNTRL_BLK.START_DATE||'&END_DAT='||:CNTRL_BLK.END_DATE;
WEB.SHOW_DOCUMENT(temp_url);

Report message to a moderator

Previous Topic: Query in Reports
Next Topic: Printing Character Mode Report On Oracle 9i AS - Application Server
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Apr 20 02:26:36 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.