Home » Developer & Programmer » Reports & Discoverer » HOW TO VIEW MY REPORT
HOW TO VIEW MY REPORT [message #193091] Thu, 14 September 2006 21:04 Go to next message
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 #193498 is a reply to message #193091] Sun, 17 September 2006 20:23 Go to previous messageGo to next message
wency
Messages: 450
Registered: April 2006
Location: Philippines
Senior Member

search forum for "run_product" or just read the syntax from your F1.
icon13.gif  Re: HOW TO VIEW MY REPORT [message #198453 is a reply to message #193091] Tue, 17 October 2006 04:11 Go to previous message
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.....
Previous Topic: Diference in print preview
Next Topic: Parameter sent to query
Goto Forum:
  


Current Time: Sat Dec 10 06:59:35 CST 2016

Total time taken to generate the page: 0.26730 seconds