Home » Developer & Programmer » Forms » Want to Hide Report Parameter Form
Want to Hide Report Parameter Form [message #79075] Sun, 21 April 2002 20:21 Go to next message
ayaz
Messages: 4
Registered: April 2002
Junior Member
I am running report from the form and printing it. I am passing some parameter from form to report. Though I check the option suppress parameter form in the report file. It still come up while running from the form.

I don't want to show parameter form while running report from the forms.

Help is needed.
Thanks.
Re: Want to Hide Report Parameter Form [message #79076 is a reply to message #79075] Sun, 21 April 2002 21:31 Go to previous message
Yuvraj Thapa
Messages: 28
Registered: May 2001
Junior Member
HI !!

Use following tech to solve your problem.
Regards,
Yuvraj Thapa
Kathmandu, Nepal.

Declare

pl_id ParamList;

BEGIN

pl_id := Get_Parameter_List('tmpdata');

IF NOT Id_Null(pl_id) THEN
Destroy_Parameter_List( pl_id );
END IF;

pl_id := Create_Parameter_List('tmpdata');

---- this is importment...
ADD_PARAMETER(PL_ID,'PARAMFORM',TEXT_PARAMETER,'NO');

Add_Parameter(pl_id,'account_code',TEXT_PARAMETER,:filter.account_code);
Add_Parameter(pl_id,'account_name',TEXT_PARAMETER,:filter.account_name);
Add_Parameter(pl_id,'fmdate',TEXT_PARAMETER,to_date(to_char(:filter.fmdate,'DD-MON-YYYY'),'DD-MON-YYYY'));
Add_Parameter(pl_id,'todate',TEXT_PARAMETER,to_date(to_char(:filter.todate,'DD-MON-YYYY'),'DD-MON-YYYY'));

Run_Product(REPORTS,'c:aceproreportsac_statement',SYNCHRONOUS,RUNTIME,FILESYSTEM,pl_id,'NO');


end if;


END;
Previous Topic: Buttons Behaviour
Next Topic: In Forms...
Goto Forum:
  


Current Time: Wed May 22 04:15:40 CDT 2024