Home » Developer & Programmer » Forms » how i can to built form (oracle 6i) that connect with report builder
how i can to built form (oracle 6i) that connect with report builder [message #577483] Sat, 16 February 2013 23:58 Go to next message
abuqais_king
Messages: 1
Registered: February 2013
Location: JORDAN
Junior Member
hello
can you declare how i can to built form (oracle 6i) that connect with report builder
Re: how i can to built form (oracle 6i) that connect with report builder [message #577501 is a reply to message #577483] Sun, 17 February 2013 11:10 Go to previous messageGo to next message
Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Calling reports from a form has been discussed frequently; have a look at the search results (keywords: "call report form 6i"); you can further refine it and find what you are looking for.
Re: how i can to built form (oracle 6i) that connect with report builder [message #577871 is a reply to message #577483] Thu, 21 February 2013 06:15 Go to previous message
kame
Messages: 69
Registered: July 2009
Member
try this sample code here

declare
	pl_id paramlist;
	pl_name varchar2(200) := 'Kame';
	
begin 
	pl_id := Get_Parameter_List(pl_name);
	
	IF NOT Id_NULL(pl_id) THEN 
		DESTROY_Parameter_list(pl_name);
	end if;
	
	pl_id := Create_Parameter_List(pl_name);
	
	ADD_PARAMETER(pl_id,'rvno', text_parameter,:gl_receipt.rv_no);
	ADD_PARAMETER(pl_id,'rvdate', text_parameter,:gl_receipt.rv_date);
	ADD_PARAMETER(pl_id,'PARAMFORM', text_parameter,'NO');


		
		RUN_PRODUCT(REPORTS,'rv',ASYNCHRONOUS,RUNTIME,
	      FILESYSTEM,pl_id,NULL);
	      
	
END;

Previous Topic: Passing two parameters for reprot
Next Topic: acrobat reader open?
Goto Forum:
  


Current Time: Fri Apr 26 17:59:15 CDT 2024