Summary
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:')
- Enter value(s) for Customer State:
- Enter value(s) for Division:
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.
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