This article describes the Document Source method for supplying values to all parameters/filters in a document using a single Data Source.


  • 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:')

Usage Example

In this example, the document or query contains two parameters:
  • Enter value(s) for Customer State:
  • Enter value(s) for Division:
The data source contains corresponding columns with mismatched column names.


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.

Date Macro Support

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



See Also

Using Document Source

Creating & Using a Data Source