OraFAQ Forum: Forms » about report in fusion middleware

Home » Developer & Programmer » Forms » about report in fusion middleware

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

about report in fusion middleware [message #545165]

Mon, 27 February 2012 13:03

windowsdos
Messages: 29
Registered: May 2011

Junior Member

i need to call report from button in form
but when i call the report which have parameter in it ,it run direct without show me the parameter field to be entered
now i need to do the following
run report normally as when i press in the button the parameter filed appear

Report message to a moderator

Re: about report in fusion middleware [message #545237 is a reply to message #545165]

Tue, 28 February 2012 01:21

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

Senior Member

Which Report version are you using.?
Try this Sample & Use Paraform=yes in Web.Show_Document().

Declare
v_connect	VARCHAR2 (200)  := 'userid=xyz/xyz@abc';
v_report_name	VARCHAR2(100)   := 'Vou.rdf';
v_format	VARCHAR2(12)    :='Htmlcss';
 
Begin

Web.Show_Document('http://hoitvoltes5:9002/reports/rwservlet?'||v_connect||'&server=RptSvr&destype=cache&report='||v_report_name||'&desformat='||v_format'&vouno='
||:voucher.vouno&Paraform=Yes,'_blank');
End;

Regards,
Irfan

Report message to a moderator

Previous Topic:	How to make a node?
Next Topic:	How to connect remote database using forms 6i?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 06 15:18:26 CDT 2024