Report Calling From Parameter Form 6i [message #542383] |
Tue, 07 February 2012 01:03 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/cc837b9c65ed1aec0080f5550741ecfe?s=64&d=mm&r=g) |
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 734 times)
|
|
|
|
|
|