InfoSol Help Desk

Requirements

• The data source must contain a column for each document parameter or filter
• Column names must either match parameter/filter names or column names are aliased to match parameter/filter names. There are two aliasing options:
  • Use Parameter Alias to alias the column name with the parameter/filter name
  • When using a Database Query, use the select statement to select the column name as the parameter/filter name.
    • Example: SELECT State AS 'Enter value(s) for State:')

• Enter value(s) for Customer State:
• Enter value(s) for Division:

Using Parameter Alias where Enter value(s) for Customer State: = state and Enter value(s) for Division: = division, the following select statement can be used:

SELECT state,division FROM table

Without Parameter Alias, the column names must be aliased with the select statement:

SELECT state as 'Enter value(s) for Customer State:',division as 'Enter value(s) for Division:' FROM table

When using an Excel File List, column names must match or Parameter Alias must be used as query aliasing is not available.

Apply a Document Source

• Select the Burst item
• Select the Document Source button under Item Details
• Select a Data Source
• Parameters (if applicable):
  • Database query syntax: @<PARAMETER>=<VALUE>
  • Excel File List syntax: <COLUMN>='<VALUE>'
• Delimiter: Set the delimiter character for multiple values as required by your reporting platform
• Select the OK button
• Error Source does not contain a match for... will occur if the data source does not contain columns for each document parameter/filter.

A Document Source may contain Date Macros. The macro is parsed at runtime and the resulting date value returned.

Example: