Home » Developer & Programmer » Forms » Calling reports from form builder with parametrs.
Calling reports from form builder with parametrs. [message #83328] Thu, 25 September 2003 05:20 Go to next message
Rajeev Katyal
Messages: 55
Registered: April 2002
Member
I wish to call a report from form builder and pass parameters to the report from form itself.

So for the same , i suppose , i need to do the following

1)Create parameter list using create_parameter_list
2)Add paramter using add_paramter
3)call run_product ..by passing paramter list id as one of the arguement.

This is the part as far as form builder is concerned , what do i need to do in report builder....

IF i write query like this( using user parameter )

select ename from emp where ename like :variable_1;

then it will start asking the paramter value at the startup of report.....

My question is :

what do i need to do , so that report should accept the value from the parameters passed while calling run_product form form.

REgards,
Rajeev Katyal
Re: Calling reports from form builder with parametrs. [message #83330 is a reply to message #83328] Thu, 25 September 2003 08:28 Go to previous message
magnetic
Messages: 324
Registered: January 2003
Senior Member
the paramters from the forms are known in the reports!!
you should check your runtime settings to not display the parameter form of the report
then your query should like this if you use the LIKE-operator:

select ename from emp where ename like '%'||:variable_fromForms||'%';
Previous Topic: LOV 'FIND' field NOT displayed in character mode(UNIX)
Next Topic: form start up
Goto Forum:
  


Current Time: Fri Mar 29 06:43:38 CDT 2024