Home » Developer & Programmer » Forms » i need call report from forms 11g (Help؟؟)
i need call report from forms 11g [message #487375] Sun, 26 December 2010 07:27 Go to next message
ibra
Messages: 4
Registered: December 2010
Location: Saudi Arabia
Junior Member

Hi all Smile
i need call report from forms 11g
Example or Code

I have a forms11g and system XP

thanks
Re: i need call report from forms 11g [message #487417 is a reply to message #487375] Mon, 27 December 2010 00:27 Go to previous messageGo to next message
ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia
Senior Member

Dear,

Please see below code for calling a report in a forms11g.

declare
v_show_document	VARCHAR2 (2500) :='http://hoitvoltes5:9002/reports/rwservlet?';
v_connect	VARCHAR2 (200)  := 'userid=nisadmin_dev/nisadmin_dev@webnis';
v_report_server	VARCHAR2 (30)   := 'ReportsServer_HOITVOLTES5_asin';
v_report_name	VARCHAR2(100)   := 'Voucher.rdf';
v_format	VARCHAR2(12)    :=:Frmt;
 
 begin
	
Web.Show_Document('http://hoitvoltes5:9002/reports/rwservlet?usr'||'&report='||v_report_name||'&desformat='||v_format||'&companyid='||:voucher.companyid||'&vouno='||:voucher.vouno,'_blank');
  
  
  end;
  


Hope it'll help you.

Regards,
Irfan
Re: i need call report from forms 11g [message #487469 is a reply to message #487417] Mon, 27 December 2010 18:55 Go to previous messageGo to next message
ibra
Messages: 4
Registered: December 2010
Location: Saudi Arabia
Junior Member
Thank you Mr.Irfan
But I have a query you could use

ADD_PARAMETER


If possible, please attach an example of user-Leah Scott

Best Regards,

Re: i need call report from forms 11g [message #487473 is a reply to message #487469] Tue, 28 December 2010 00:20 Go to previous messageGo to next message
ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia
Senior Member

While Calling a report through Forms11g I did not used Add_Parameter before.
Re: i need call report from forms 11g [message #487520 is a reply to message #487473] Tue, 28 December 2010 07:04 Go to previous messageGo to next message
ibra
Messages: 4
Registered: December 2010
Location: Saudi Arabia
Junior Member
I used it in the form 10g

Is it possible that in forms 11g

Best Regards,

Re: i need call report from forms 11g [message #487522 is a reply to message #487520] Tue, 28 December 2010 07:19 Go to previous messageGo to next message
ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia
Senior Member

Dear,

Please also read this post regarding ADD_PARAMETER.
http://forums.oracle.com/forums/thread.jspa?messageID=4489840

Regards,
Irfan
Re: i need call report from forms 11g [message #487525 is a reply to message #487522] Tue, 28 December 2010 07:30 Go to previous messageGo to next message
ibra
Messages: 4
Registered: December 2010
Location: Saudi Arabia
Junior Member
Thanks for the help Mr.Irfan

Good luck
Re: i need call report from forms 11g [message #487527 is a reply to message #487525] Tue, 28 December 2010 07:45 Go to previous message
ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia
Senior Member

Thanks for your feedback.
Previous Topic: Unable to fetch data using control-blocks
Next Topic: How to implement MS Excel's SUMIF function in Oracle Forms
Goto Forum:
  


Current Time: Fri Mar 29 09:01:06 CDT 2024