Troubleshooting
Problem
Using a picklist for a prompt page with a static collection of values you cannot pass the filter if there are multiple selections in the Use portion for the Static Choices.
Symptom
No error is returned when entering more than one value in the User portion of the Static Choices and when you run the report and select the Display value that corresponds to the Use value with multiple criteria the report is blank.
Resolving The Problem
This is due to the fact that the Static Choices are a one-to-one value and you cannot pass more than one filter criteria in the Use portion.
Enter a single string value into the Use and in the filter used an if...then...else to define the values you would like associated with the string value from the Static Choices.
For example, if you would like to Use the values 'ABC' and 'DEF', enter something to the effect of ?String Value? in the Use area for the Static Choices. In the Filters for the Tabular Model enter the following:
if ((?parameter?) = ?String Value?) then
([Column] in ( 'ABC', 'DEF'))
else if ((?parameter?) = ?String Value2?) then ([Column] in ('ABC', 'DEF', 'GHI')) else ([Column] in (?parameter?))
The first ?String Value? will represent values 'ABC' and 'DEF' if selected from the picklist when the report is run. The second value, ?String Value2?, will filter the report on 'ABC', 'DEF' and 'GHI'.
Historical Number
1013277
Was this topic helpful?
Document Information
Modified date:
15 June 2018
UID
swg21335756