OraFAQ Forum: Reports & Discoverer

Home » Developer & Programmer » Reports & Discoverer » Passing Parameter (disc 10.1.2)

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

Passing Parameter [message #311551]

Fri, 04 April 2008 14:47

aarti81
Messages: 235
Registered: December 2007
Location: USA

Senior Member

HiAll

I have a URL on the first field of my report, how do i pass parameters to that URL, pls any advice is appreciated

Thanks

Report message to a moderator

Re: Passing Parameter [message #311561 is a reply to message #311551]

Fri, 04 April 2008 15:20

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

Senior Member
Account Moderator

Concatenation?

Report message to a moderator

Re: Passing Parameter [message #311763 is a reply to message #311561]

Sun, 06 April 2008 12:16

aarti81
Messages: 235
Registered: December 2007
Location: USA

Senior Member

Littlefoot wrote on Fri, 04 April 2008 15:20

Concatenation?

can you please explain a little bit more.

Thanks

Report message to a moderator

Re: Passing Parameter [message #311771 is a reply to message #311763]

Sun, 06 April 2008 13:33

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

Senior Member
Account Moderator

Something like this SQL*Plus example:

SQL> select 'http://mymachine.com:7777/forms90/f90servlet' ||
  2         '&param' result
  3* from dual
SQL> /
Enter value for param: ?config=my_application

RESULT
------------------------------------------------------------------
http://mymachine.com:7777/forms90/f90servlet?config=my_application

SQL>

Report message to a moderator

Re: Passing Parameter [message #311944 is a reply to message #311771]

Mon, 07 April 2008 08:25

aarti81
Messages: 235
Registered: December 2007
Location: USA

Senior Member

Littlefoot wrote on Sun, 06 April 2008 13:33

Something like this SQL*Plus example:

SQL> select 'http://mymachine.com:7777/forms90/f90servlet' ||
  2         '&param' result
  3* from dual
SQL> /
Enter value for param: ?config=my_application

RESULT
------------------------------------------------------------------
http://mymachine.com:7777/forms90/f90servlet?config=my_application

SQL>

I think you didnt get my point, i attached the URL as a link in one of the fields in the discoverer plus, this field is named as id and each row is unique, so when you click on the link it should take you to a pdf page in another applicxation having this number, so what else should i add in to the link?

Thanks

Report message to a moderator