OraFAQ Forum: Forms » Run Report from Form10g

Home » Developer & Programmer » Forms » Run Report from Form10g (Oracle 9i database , 10g developer, windows Xp)

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

Run Report from Form10g [message #524007]

Wed, 21 September 2011 06:37

kame
Messages: 69
Registered: July 2009

Member

Oracle 10g Developer suite
using OC4J

hi experts

can you please share some code here to run report from form with and without passing parameters.

regards

Report message to a moderator

Re: Run Report from Form10g [message #524016 is a reply to message #524007]

Wed, 21 September 2011 06:52

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

Senior Member

Dear,
Read this post for run report from form with and without passing parameters.

http://www.orafaq.com/forum/m/518005/81953/#msg_518005

Regards,
Irfan

Report message to a moderator

Re: Run Report from Form10g [message #524022 is a reply to message #524007]

Wed, 21 September 2011 07:08

kame
Messages: 69
Registered: July 2009

Member

Thank you Irfan

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

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

here you use user/pw@host
if we are running same report on more then one user what should we do.

Report message to a moderator

Re: Run Report from Form10g [message #524028 is a reply to message #524022]

Wed, 21 September 2011 07:36

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

Senior Member

Quote:

If we are running same report on more then one user what should we do.

Through Form Pass the parameter
V_Connect Varchar2(200) :=:Usr_Pwd;

Please find herewith attached snapshot.
/forum/fa/9386/0/

Hope it'll help you.

Regards,
Irfan

Attachment: UsrPdw.PNG
(Size: 5.20KB, Downloaded 1359 times)

Report message to a moderator

Re: Run Report from Form10g [message #524030 is a reply to message #524022]

Wed, 21 September 2011 07:53

kame
Messages: 69
Registered: July 2009

Member

Irfan

Is there other way to do this. I mean can we define anywhere in oracle file like registry.
because I do not want to show the user and password to USER.

Report message to a moderator

Re: Run Report from Form10g [message #524045 is a reply to message #524030]

Wed, 21 September 2011 08:43

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

Senior Member

As my understanding you can define UserName & Password one time in cgicmd.dat file.
C:\Oracle\Middleware\as_1\reports\conf\cgicmd.dat
open cgicmd.dat file in notepad then you'll see there like.

orqa: report=breakb.rdf destype=cache desformat=html server=repserver 
 
usr: userid=xyz/irfan12345@tnsname server=repserver 
     destype=cache desformat=htmlcss paramform=no %*

Then you can use this key.

Web.Show_Document('http://Irfan:9002/reports/rwservlet?usr'||'&report='||v_report_name||'&desformat='||v_format,'_blank');

Regards,
Irfan

Report message to a moderator

Previous Topic:	Menu-bar not displayed correctly
Next Topic:	Master Detail Form (Wrong Data)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Oct 23 21:04:02 CDT 2025