OraFAQ Forum: Reports & Discoverer » parameter problem to run report

Home » Developer & Programmer » Reports & Discoverer » parameter problem to run report (forms & report 10g, oracle app server 10g)

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

parameter problem to run report [message #362349]

Mon, 01 December 2008 23:50

pinkalsolanki
Messages: 25
Registered: December 2008
Location: Surat/Gujarat

Junior Member

hi..
I am using forms & reports 10g deploying on oracle app server 10g.

i am calling report from form using RUN_REPORT_OBJECT method..
here it is sample code

Declare
pl_id paramlist;
Begin

pl_id := Get_Parameter_List('Temp');
IF Not Id_Null(pl_id) Then
Destroy_Parameter_List(pl_id);
End if;

Pl_Id := Create_Parameter_List('Temp');

Add_parameter (pl_id,'FILTERSTRING',TEXT_PARAMETER,'WHERE S03_NOTS=''ACCOUNT''');

Add_parameter (pl_id,'PARAMFORM',TEXT_PARAMETER,'YES');

RUN_REPORT_OBJECT_PROC(PL_ID);
-- THIS IS PROGRAM UNIT WHICH CALL RUN_REPORT_OBJECT method and pass parameter list

Everything is run fine when i am set PARAMFORM=NO and everything is same and i am just change PARAMFORM=YES then
report job id genereted properly and parameter form also display , all parameters are also passed to the parameter form
but when i press SUBMIT QUERY then report does not run and internet explorer throws the page of " The Website can not display the page "

Report message to a moderator

Re: parameter problem to run report [message #362376 is a reply to message #362349]

Tue, 02 December 2008 01:32

rajy_salim
Messages: 204
Registered: January 2008
Location: Beirut - Lebanon

Senior Member

Welcome to the forum.
Please read The forum Guidelines before posting.

Make sure the report's name/path has not changed.

Rajy

Report message to a moderator

Re: parameter problem to run report [message #362435 is a reply to message #362349]

Tue, 02 December 2008 05:00

pinkalsolanki
Messages: 25
Registered: December 2008
Location: Surat/Gujarat

Junior Member

Thanks for reply

report name / path, everything is ok.
my problem is that.
when i am pass PARAMFORM=NO in parameter list then REPORT RUN PROPERLY ,
BUT WHEN I PASS PARAMFORM=YES then PARAMETER FORM WILL DISPLAY BUT AFTER ENTER PARAMETER OR AFTER KEEPING AS IT IS..
PRESSING SUBMIT QUERY BUTTON THERE IS NOTHING TO DISPLAY
JUST ERROR OCCURED OF INTERNET EXPLORERE

I HAVE ATTACHED SCREEN SHOT OF ERROR

Attachment: untitled.PNG
(Size: 33.58KB, Downloaded 843 times)

Report message to a moderator

Re: parameter problem to run report [message #362446 is a reply to message #362349]

Tue, 02 December 2008 05:53

rajy_salim
Messages: 204
Registered: January 2008
Location: Beirut - Lebanon

Senior Member

Take a look on This Thread. It may help you.

You can use the link inside, it may be helpful.

Rajy

Report message to a moderator

Re: parameter problem to run report [message #362714 is a reply to message #362446]

Wed, 03 December 2008 23:38

pinkalsolanki
Messages: 25
Registered: December 2008
Location: Surat/Gujarat

Junior Member

Thanks Rajy_salim

Its working..!!!! Great..

i got help from that document frmrepparamform.pdf

Thanks.

Report message to a moderator

Previous Topic:	No response from web server
Next Topic:	Count multiple items

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 03 18:45:03 CDT 2024