| Report Calling From Parameter Form 6i [message #542383] |
Tue, 07 February 2012 01:03  |
 |
glmjoy
Messages: 187
Registered: September 2011
Location: KR
|
Senior Member |
|
|
Dear All,
I am getting a problem I use lexical Parameter but When I call that through Form my parameter forms didnt call that on report parameter. My query is below as well I have attached all Jpg files to understand. I Didnt getting where I am mistaken.
Thanks in Advance.
DECLARE
pl_id PARAMLIST;
BEGIN
pl_id := GET_PARAMETER_LIST('TMP');
IF NOT Id_Null(pl_id)
THEN
DESTROY_PARAMETER_LIST(pl_id);
END IF;
pl_id := CREATE_PARAMETER_LIST('TMP');
IF :b1.script IS NOT NULL
THEN
ADD_PARAMETER(pl_id,'P_TITLE',TEXT_PARAMETER,INITCAP(:b1.obj_type)||' Name : '||:b1.obj_list);
ADD_PARAMETER(pl_id,'''P_SCRIPT''',TEXT_PARAMETER,:b1.script);
-- ADD_PARAMETER(pl_id,'P_DRAW_LINE',TEXT_PARAMETER,'SELECT '''||:b1.layout_style||''' FROM DUAL');
ADD_PARAMETER(pl_id, 'PARAMFORM', TEXT_PARAMETER, 'YES');
RUN_PRODUCT(REPORTS,'D:\dynamic_report',SYNCHRONOUS,RUNTIME,FILESYSTEM,pl_id,NULL);
DESTROY_PARAMETER_LIST(pl_id);
ELSE
Message('Script is not build');
Message('Script is not build');
END IF;
END;
-
Attachment: DForm.jpg
(Size: 68.24KB, Downloaded 752 times)
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
