OraFAQ Forum: Forms » Report Calling From Parameter Form 6i

Home » Developer & Programmer » Forms » Report Calling From Parameter Form 6i (9i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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 716 times)

Report message to a moderator

Re: Report Calling From Parameter Form 6i [message #542390 is a reply to message #542383]

Tue, 07 February 2012 01:09

Michel Cadot
Messages: 68666
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version, with 4 decimals.

Regards
Michel

Report message to a moderator