OraFAQ Forum: Reports & Discoverer » Error Running report in 9i

Home » Developer & Programmer » Reports & Discoverer » Error Running report in 9i

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

Error Running report in 9i [message #227032]

Tue, 27 March 2007 03:15

zafarkarachi
Messages: 29
Registered: November 2006
Location: Karachi Pakistan

Junior Member

Dear All

I receive the following error in 9i report while running the
report on web.

when i run this report having the database on the same machine
it does not show any error. But when i use to connect to the
database which is on the other machine it displays the following error.

REP-50003: Bad command line: userid="scott/tiger@orcl report=dept_hyperlink.rdf destype=cache desformat=html P_deptno=" deptno

This is a hyperlink/drill down report in 9i.

Zafar Iqbal
Karachi
0321-2876518

Report message to a moderator

Re: Error Running report in 9i [message #229373 is a reply to message #227032]

Sat, 07 April 2007 01:12

zafarkarachi
Messages: 29
Registered: November 2006
Location: Karachi Pakistan

Junior Member

I have solved the problem

Thanks

zafar

Report message to a moderator

Re: Error Running report in 9i [message #229393 is a reply to message #229373]

Sat, 07 April 2007 05:12

Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Would you mind to post the solution? I'm glad you made it work, but simply saying "I have solved the problem" will not help other people to solve the same problem when they encounter it.

Report message to a moderator

Re: Error Running report in 9i [message #229582 is a reply to message #229393]

Mon, 09 April 2007 04:34

zafarkarachi
Messages: 29
Registered: November 2006
Location: Karachi Pakistan

Junior Member

Dear Littlefoot

Actually i was supplying variable with the following line.
and as this is a hyperlink report in 9i deptno field is
hyperlinked.

correct syntax :
http://mycomputername:8889/reports/rwservlet?userid="scott/tiger@orcl report=dept_hyperlink.rdf destype=cache desformat=html

I was writing the wrong address like
http://mycomputername:8889/reports/rwservlet?userid="scott/tiger@orcl report=dept_hyperlink.rdf destype=cache desformat=html+dno=&deptno

Thanks
Zafar Iqbal

Report message to a moderator

Re: Error Running report in 9i [message #229703 is a reply to message #229582]

Mon, 09 April 2007 15:12

Littlefoot
Messages: 21813
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Thank you!

Report message to a moderator

Re: Error Running report in 9i [message #229784 is a reply to message #229703]

Tue, 10 April 2007 01:15

ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India

Senior Member

Hi,
@LF but how the same report is working in the local databse/local machine and not in the remote machine?
Bye
Ashu

Report message to a moderator

Previous Topic:	How to draw lines between the records of report output
Next Topic:	Reports source from more than one database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jul 04 12:16:31 CDT 2024