| Want to Hide Report Parameter Form [message #79075] |
Sun, 21 April 2002 20:21  |
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  |
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;
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
