| other reports parameter(form builder) [message #87480] |
Thu, 06 January 2005 23:44  |
r.g.godbole
Messages: 5
Registered: January 2005
|
Junior Member |
|
|
DEVELOPER -2000
I have developed one form in form Builder
and under report node i included one report
How to pass form field value to report user parameter
what is the syntax.for single parameter & multiple parameter
|
|
|
|
| Re: other reports parameter(form builder) [message #87481 is a reply to message #87480] |
Thu, 06 January 2005 23:54  |
Niranjan
Messages: 34
Registered: June 2001
|
Member |
|
|
to pass a single value from form to reports u need to use TEXT_PARAMETER and for multiple values u have to use DATA_PARAMETER in add_parameter procedure.
u can try the following code.
declare
p paramlist;
begin
p:=create_parameter_list('abc');
add_parameter(p,'p_dno',text_parameter,:block.value);
-- p_dno is the parameter name of ur report
run_product
(reports,
path_of_ur_report_file,
synchronous,
runtime,
filesystem,
p
);
end;
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
