Home » Developer & Programmer » Reports & Discoverer » Run report in menu??? (6i)
Run report in menu??? [message #527666] Wed, 19 October 2011 12:14 Go to next message
saqib4882
Messages: 22
Registered: August 2011
Location: Hassan Abdal
Junior Member

Hi Experts....

How can I run my report in my main menu or fort page for example I want to run my report when user click a button. What will process?

Waiting plzz

saqib khan
Re: Run report in menu??? [message #528135 is a reply to message #527666] Sat, 22 October 2011 01:27 Go to previous messageGo to next message
ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia
Senior Member

Dear,
Search & Study about Run_Product() Report built in.


Regards,
Irfan
Re: Run report in menu??? [message #528200 is a reply to message #528135] Sun, 23 October 2011 01:36 Go to previous messageGo to next message
saqib4882
Messages: 22
Registered: August 2011
Location: Hassan Abdal
Junior Member

Irfan sab thanks for reply

run_product(RUN_PRODUCT (REPORTS, 'f:\college\reports\resutl.rep', ASYNCHRONOUS, RUNTIME, FILESYSTEM, NULL);
check please whats wrong here?
saqib
Re: Run report in menu??? [message #528203 is a reply to message #528200] Sun, 23 October 2011 01:53 Go to previous messageGo to next message
ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia
Senior Member

Dear,
Quote:

run_product(RUN_PRODUCT (REPORTS, 'f:\college\reports\resutl.rep', ASYNCHRONOUS, RUNTIME, FILESYSTEM, NULL);



Try this Sample code.
Declare
pl_id   ParamList; 
pl_name Varchar2(50) :='tempdata';
Begin
pl_id := Get_Parameter_List(pl_name); 
IF NOT Id_Null(pl_id) THEN 
Destroy_Parameter_List(pl_id); 
END IF; 
pl_id := Create_Parameter_List(pl_name);  
-- Pass Report Parameter 		    
Add_Parameter(pl_id,'pono',TEXT_PARAMETER,:PO_header.po_no); 
Add_Parameter(pl_id,'destype',TEXT_PARAMETER,'preview'); 

Run_Product(REPORTS, 'C:\PO.rep', SYNCHRONOUS, RUNTIME,FILESYSTEM, pl_id,Null);		     	   		     	  
End;  


Hope it'll help you.

Regards,
Irfan


Re: Run report in menu??? [message #529089 is a reply to message #528203] Fri, 28 October 2011 12:01 Go to previous messageGo to next message
saqib4882
Messages: 22
Registered: August 2011
Location: Hassan Abdal
Junior Member

v thanks for reply .....
Re: Run report in menu??? [message #529166 is a reply to message #529089] Sat, 29 October 2011 01:11 Go to previous message
ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia
Senior Member

Thanks for the feedback.

Regards,
Irfan
Previous Topic: .rep to exec
Next Topic: Symbol in Oracle Reports
Goto Forum:
  


Current Time: Thu Mar 28 19:00:12 CDT 2024