Home » Developer & Programmer » Reports & Discoverer » Discoverer launched in command line : Parameters ? (Discoverer Desktop)
Discoverer launched in command line : Parameters ? [message #320750] Fri, 16 May 2008 03:24 Go to next message
jb084
Messages: 14
Registered: April 2008
Junior Member
Hello,

I launch Discoverer in command line, with this line:
start I:\oracle\BIToolsHome_1\bin\dis51usr.exe /CONNECT $2/$3 /OPENDB "$1" /SHEET all


$1 meaning the query
$2 meaning the user
$3 meaning the password

I'd like to be able to add some arguments, that could be used in the query (in a the "where" section of the query for example). For example, if i had a query with a condition on the year, I'd like to be able to launch my query directly with the condition "year" fixed at 2008. The command line would be close to this :
start I:\oracle\BIToolsHome_1\bin\dis51usr.exe /CONNECT $2/$3 /OPENDB "$1" /SHEET all /PARAMS "2008"


Is it possible ?
Thanks for your help

[Updated on: Fri, 16 May 2008 03:28]

Report message to a moderator

Re: Discoverer launched in command line : Parameters ? [message #321145 is a reply to message #320750] Mon, 19 May 2008 04:20 Go to previous message
skooman
Messages: 912
Registered: March 2005
Location: Netherlands
Senior Member
From the documentation:

/parameter
This command enables you to set a specified parameter to a specified value.

Information Details
Syntax:
/parameter <parameter name> <parameter value>

Modifiers:
None
Restrictions:
If the end user does not specify a value for a parameter in a workbook then Discoverer uses a default value.
Example:
dis51usr.exe /parameter year 2001

Previous Topic: How to dynamic set the ole container source in Report Builder 6.0.5.32.0
Next Topic: selectiuon date
Goto Forum:
  


Current Time: Wed Dec 07 13:02:31 CST 2016

Total time taken to generate the page: 0.14531 seconds