HOW TO VIEW MY REPORT [message #193091] |
Thu, 14 September 2006 21:04 |
jamesrussell15
Messages: 16 Registered: September 2006 Location: philippines
|
Junior Member |
|
|
HOW TO VIEW MY REPORT IF IM GOING TO PRESS A BUTTON FROM FORM BUILDER?
WHAT IS/ARE THE CODE/S FOR LINKING A REPORT FROM FORM BUILDER?
THANK YOU..
HAVE A NICE DAY!
RUSSELL
|
|
|
|
Re: HOW TO VIEW MY REPORT [message #198453 is a reply to message #193091] |
Tue, 17 October 2006 04:11 |
imen_mr2004
Messages: 22 Registered: October 2006 Location: tunisia
|
Junior Member |
|
|
Hi. i hav answer to ur question u must put in ur form a button with a trigger when_button_pressed and write this code
declare
ref varchar2(40);
pl_id ParamList;
x varchar2(20);
wtypper varchar2(4);
BEGIN
pl_id := Get_Parameter_List('refope');
IF NOT Id_Null(pl_id) THEN
Destroy_Parameter_List( pl_id );
END IF;
pl_id := Create_Parameter_List('refope');
Add_Parameter(pl_id,'refope',TEXT_PARAMETER,ref);
Add_Parameter(pl_id,'xxxx',TEXT_PARAMETER,:bloc.item);
Add_Parameter(pl_id,'destype',TEXT_PARAMETER,'screen');
Add_Parameter(pl_id, 'PARAMFORM', TEXT_PARAMETER, 'NO');
Run_Product(REPORTS,'name_of_report,SYNCHRONOUS,runtime,FILESYSTEM,pl_id);
end;
xxx is the parameter ur passed to the report from form if the is, if no ignor it.
whish u all the best.....
|
|
|