Summary


This article describes the various options for supplying values to a document filter for single-pass bursting.


Add a Filter
  • Select the Burst document
  • Select the Filters tab
  • Select the green plus button and select a filter variable
  • Source From: Select a source for filter values


Report Variable


Report Variable uses all values for the filter variable. At runtime the document is refreshed and list of values for the filter variable is derived from the resulting data set. Use this option when the requirement is to filter for all variable values returned by the document query.

  • Source From: Select Report Variable
  • Exclude These Values: Check this option to exclude values from the Report Variable list 
    • Supports wildcards and NOT(..) functions. Static values and wildcards can be combined. 
      • Example: NOT(C*) (exclude values starting with 'C' from filter list) 
      • Example: NOT(C*;Tokyo) (exclude values starting with 'C' and 'Tokyo' from filter list) 
      • Example: London;T* (filter for London and any value starting with 'T')

Database Query
  • Source From: Select Data Source
  • Source: Select the ellipsis button then select a database connection and query
  • Parameters (if applicable):
    • Database query syntax: @=[VALUE]
    • Excel File List syntax: [COLUMN_NAME]='[VALUE]'
  • Delimiter: Set the delimiter character for multiple values as required by your reporting platform
  • Column to use: Designate column to use if the query returns multiple columns
  • Select the Apply button

MultiColumn List

  • Source From: Select Data Source
  • Source: Select the ellipsis button then select a MultiColumn List
  • 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 From: Select Data Source
  • Source: Select the ellipsis button then select a File List
  • Column to use: Designate column to use if the data source contains columns
  • Condition (if applicable): Syntax [COLUMN]='[VALUE]'
  • Select the Apply button


Enter Value

  • Source From: 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
  • Select the Apply button

Document Source

To use Document Source with a filter, set the filter variable then set source as Report Variable. Application of Document Source then overrides Report Variable.


See Also


Processing Methods (Single-Pass Bursting)

Using Document Source