OraFAQ Forum: Reports & Discoverer » calling reports from forms(urgent!)

Home » Developer & Programmer » Reports & Discoverer » calling reports from forms(urgent!)

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

calling reports from forms(urgent!) [message #89373]

Mon, 01 March 2004 00:30

rajul
Messages: 2
Registered: March 2004

Junior Member

Hi all,

can anybody help me out.

i want a solution for this oracle reports error. REP-0091. 'INVALID VALUE FOR PARAMETER w'.

i calling a report from forms while passing a paramter named W.

from forms to reports.

any kind of help wil b appreciated.

bye.

Report message to a moderator

Re: calling reports from forms(urgent!) [message #89392 is a reply to message #89373]

Thu, 11 March 2004 01:54

Jeslie Simpson
Messages: 10
Registered: January 2003

Junior Member

Hi

Hope you used Run_Product.

Pls check the data type of the Parameter. It should match the data type of the value you assign to the parameter thru add_parameter..

Thanks

Report message to a moderator

Re: calling reports from forms(urgent!) [message #89461 is a reply to message #89373]

Wed, 07 April 2004 01:24

NooBEmu
Messages: 11
Registered: March 2004

Junior Member

I hope wour using Run_product..
Here is an example how to pass some paramters..

DECLARE
pl ParamList ;
BEGIN
pl := get_parameter_list('tmpdata');
IF Id_Null(pl) THEN

pl := create_parameter_list('tmpdata');

IF Id_Null(pl) THEN
RAISE form_trigger_failure;
END IF;
//Add paramters values to tmpdata list
add_parameter(pl,'PARAMFORM',TEXT_PARAMETER,'NO');
add_parameter(pl,'DESTYPE',TEXT_PARAMETER,'Preview');
add_parameter(pl,'COPIES',TEXT_PARAMETER,:COPIES_NUMBER);
add_parameter(pl,'ORIENTATION',TEXT_PARAMETER,:ORIENTATION);
add_parameter(pl,'MAX_VALUE',TEXT_PARAMETER,:MAX_VALUE);
add_parameter(pl,'MIN_VALUE',TEXT_PARAMETER,:MIN_VALUE);

--Call reports with the disered paramters
RUN_PRODUCT( REPORTS, name, ASYNCHRONOUS, RUNTIME,FILESYSTEM, param_list);
Destroy_Parameter_List( pl );

ELSE MESSAGE('Parameter already created...');
END IF;
END;

Ive learned this from online help.. search there for "paramters" and you ll get some easy to understand info :)

Report message to a moderator

Re: calling reports from forms(urgent!) [message #90009 is a reply to message #89373]

Wed, 29 September 2004 03:55

Suvransu @path
Messages: 2
Registered: September 2004

Junior Member

try run_product......pass a parameter list... the name of the parameter passed from the form should be same as the name of the parameter in the report

or u can simply call reports using the

find_report_object('report name') function...this function returns a unique identifier for the report.

and then use the run_report_object(report_identifier) function to call the report. this function returns a varchar value.

hope it helps

Report message to a moderator

Previous Topic:	Error 1249 on trying to generate PDF,RTF,..... reports
Next Topic:	URGENT URGENT - Missing Fields in Print preview

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon May 06 04:26:33 CDT 2024