Summary


This article describes the various options for supplying values to a document filter for single-pass bursting. Filtering is available for Web Intelligence, Crystal Reports, and Tableau.



Access


  • Select the Burst item
  • Expand the Filters panel



Add a Filter
  • Select the + icon to add a filter
  • Select a filter variable
  • Select the Add button
  • Select the Filters tab
  • Select a source for filter values



Report Variable


By default, a filter uses Report Variable as the source for filter values. The filter values are dynamically sourced from the document/reporting platform at runtime and the document is filtered using those values. all values for the filter variable. Use this option when the requirement is to filter for all variable values returned by the document query.



Data Source


Use a Data Source to provide filter values. Select the blue document icon then select a Data Source. 



Database Query
  • Select the Database Query
  • Parameters (if applicable):
    • Database query syntax: @<PARAMETER>=<VALUE>
    • Excel File List syntax: <COLUMN_NAME>='<VALUE>'
  • Delimiter: Set the delimiter character for multiple values as required by your reporting platform
  • Column: Query column to use if the query returns multiple columns
  • Select the OK button
  • Multi Pass: Select to refresh once for each value in a list of values. Option is only available if the parameter type is in-list.

MultiColumn List
  • Select the MultiColumn List
  • Column: Column to use if the MultiColumn List contains multiple columns
  • Condition (if applicable): Syntax <COLUMN>='<VALUE>'
  • Select the OK button
  • Multi Pass: Select to refresh once for each value in a list of values. Option is only available if the parameter type is in-list.


File List

  • Select the File List
  • Column: Column to use if the File List contains multiple columns
  • Condition (if applicable): Syntax <COLUMN>='<VALUE>'
  • Select the OK button
  • Multi Pass: Select to refresh once for each value in a list of values. Option is only available if the parameter type is in-list.


Enter Value


Select the blue pencil icon to enter filter values manually.




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