Summary


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


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

Usage Example

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


state division
Arizona Sales
California Development

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 document
  • Select Data Links > Document Source
  • Source: Select the ellipsis button
  • 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 Apply 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.


Example:


state date
Arizona [TODAY-1M,YYYYMMDD]
Califonia [TODAY-1M,YYYYMMDD]


See Also


Using Document Source

Creating & Using a Data Source