OraFAQ Forum: Forms » i need call report from forms 11g

Home » Developer & Programmer » Forms » i need call report from forms 11g (Help؟؟)

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

i need call report from forms 11g [message #487375]

Sun, 26 December 2010 07:27

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

Report message to a moderator

Re: i need call report from forms 11g [message #487417 is a reply to message #487375]

Mon, 27 December 2010 00:27

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

Senior Member

ranamirfan@gmail.com

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

Report message to a moderator

Re: i need call report from forms 11g [message #487469 is a reply to message #487417]

Mon, 27 December 2010 18:55

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,

Report message to a moderator

Re: i need call report from forms 11g [message #487473 is a reply to message #487469]

Tue, 28 December 2010 00:20

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

Senior Member

ranamirfan@gmail.com

While Calling a report through Forms11g I did not used Add_Parameter before.

Report message to a moderator

Re: i need call report from forms 11g [message #487520 is a reply to message #487473]

Tue, 28 December 2010 07:04

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,

Report message to a moderator

Re: i need call report from forms 11g [message #487522 is a reply to message #487520]

Tue, 28 December 2010 07:19

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

Senior Member

ranamirfan@gmail.com

Dear,

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

Regards,
Irfan

Report message to a moderator

Re: i need call report from forms 11g [message #487525 is a reply to message #487522]

Tue, 28 December 2010 07:30

ibra
Messages: 4
Registered: December 2010
Location: Saudi Arabia

Junior Member

Thanks for the help Mr.Irfan

Good luck

Report message to a moderator

Re: i need call report from forms 11g [message #487527 is a reply to message #487525]

Tue, 28 December 2010 07:45

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

Senior Member

ranamirfan@gmail.com

Thanks for your feedback.

Report message to a moderator

Previous Topic:	Unable to fetch data using control-blocks
Next Topic:	How to implement MS Excel's SUMIF function in Oracle Forms

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 12 15:29:44 CST 2024