OraFAQ Forum: Reports & Discoverer » Run report in menu???

Home » Developer & Programmer » Reports & Discoverer » Run report in menu??? (6i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Run report in menu??? [message #527666]

Wed, 19 October 2011 12:14

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

Report message to a moderator

Re: Run report in menu??? [message #528135 is a reply to message #527666]

Sat, 22 October 2011 01:27

ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia

Senior Member

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

Regards,
Irfan

Report message to a moderator

Re: Run report in menu??? [message #528200 is a reply to message #528135]

Sun, 23 October 2011 01:36

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

Report message to a moderator

Re: Run report in menu??? [message #528203 is a reply to message #528200]

Sun, 23 October 2011 01:53

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

Report message to a moderator