Summary


The article describes the various options for supplying values to a document parameter using Parameter Source.


Add a Parameter Source
  • Select the Burst document
  • Select Data Links > Parameter Sources
  • Select a parameter
  • Source Type: Select a source for parameter values

Enter Value

  • Source Type: Select Enter Value
  • Values: Enter a value, using the appropriate delimiter when entering multiple values
    • Example: Arizona;California
  • Delimiter: Set the delimiter character for multiple values as required by your reporting platform
  • Multi Pass: Option is accessible if the parameter type is In-List
    • Select to refresh once for each value in a list of values
  • Select the Apply button

Database Query
  • Source Type: Select Data Source
  • Source: Select the ellipsis button then select a database connection and query
  • Parameters (if applicable):
    • Database query syntax: @<PARAMETER>=<VALUE>
    • Excel File List syntax: <COLUMN_NAME>='<VALUE>'
  • Delimiter: Set the delimiter character for multiple values as required by your reporting platform
  • Multi Pass: Option is accessible if the parameter type is In-List
    • Select to refresh once for each value in a list of values
  • Column to use: Designate column to use if the query returns multiple columns
  • Select the Apply button

MultiColumn List
  • Source Type: Select Data Source
  • Source: Select the ellipsis button then select a MultiColumn List
  • Multi Pass: Option is accessible if the parameter type is In-List
    • Select to refresh once for each value in a list of values
  • Column to use: Designate column to use if the query returns multiple columns
  • Condition (if applicable): Syntax <COLUMN>='<VALUE>'
  • Select the Apply button


File List

  • Source Type: Select Data Source
  • Source: Select the ellipsis button then select a File List
  • Multi Pass: Option is accessible if the parameter type is In-List
    • Select to refresh once for each value in a list of values
  • Column to use: Designate column to use if the data source contains columns
  • Condition (if applicable): Syntax <COLUMN>='<VALUE>'
  • Select the Apply button

Report Variable


Use the default list of values from BusinessObjects (Web Intelligence only). Selection of individual values is not supported.


Optional Parameters

Optional Parameters are designated with a blue dot following the parameter name and may be left blank if applicable.

See Also