| PASSING MULTI-VALUE IN REPORT [message #90275] |
Thu, 13 January 2005 03:06  |
mian imran
Messages: 29
Registered: July 2004
|
Junior Member |
|
|
i want to make a list of values in forms of data type varchar2 and then pass all that varchar2 values in report.
like i have 3 varchar2 values 'a12' , 'a13' 'a14' of colum id and a single values 'job' from job column and pass it to report and report select data on the basis of these 2 columns items
urgent need./
|
|
|
|
| Re: PASSING MULTI-VALUE IN REPORT [message #90295 is a reply to message #90275] |
Tue, 25 January 2005 03:01  |
Rohit
Messages: 43
Registered: January 2002
|
Member |
|
|
You have to use user parameters in the report.
To run the report from forms pass a parameter list in the syntax of the run_product function.
Before that:
1. Create a parameter list.
2. Add parameters in the parameter list.
3. Name of the parameters must be same as used in the report parameters
Try the following code:
declare
pl_id paramlist;
value1 varchar2(20);
value2 varchar2(20);
value3 varchar2(20);
value4 number(10);
begin
--Initialize the values--
pl_id:=Create_parameter_List('tmpdata');
add_parameter(pl_id, 'var1', TEXT_PARAMETER, value1);
add_parameter(pl_id, 'var2', TEXT_PARAMETER, value2);
add_parameter(pl_id, 'var3', TEXT_PARAMETER, value3);
add_parameter(pl_id, 'var4', TEXT_PARAMETER, value4);
--Not to show the parameter form add--
add_parameter(pl_id, 'PARAMFORM', TEXT_PARAMETER, 'NO');
run_product(REPORTS, 'd:report_name', SYNCHRONOUS, RUNTIME, FILESYSTEM, pl_id, NULL);
end;
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
