Home » Developer & Programmer » Reports & Discoverer » parameter problem to run report (forms & report 10g, oracle app server 10g)
icon9.gif  parameter problem to run report [message #362349] Mon, 01 December 2008 23:50 Go to next message
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 "
Re: parameter problem to run report [message #362376 is a reply to message #362349] Tue, 02 December 2008 01:32 Go to previous messageGo to next message
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
Re: parameter problem to run report [message #362435 is a reply to message #362349] Tue, 02 December 2008 05:00 Go to previous messageGo to next message
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 223 times)
Re: parameter problem to run report [message #362446 is a reply to message #362349] Tue, 02 December 2008 05:53 Go to previous messageGo to next message
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
Re: parameter problem to run report [message #362714 is a reply to message #362446] Wed, 03 December 2008 23:38 Go to previous message
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.
Previous Topic: No response from web server
Next Topic: Count multiple items
Goto Forum:
  


Current Time: Wed Dec 07 14:48:46 CST 2016

Total time taken to generate the page: 0.23233 seconds