If you use multi-value report parameters, you may want to filter for multiple values at the same time. For example, you have create the report parameter STypes for sample types, and provide the following available values:
|
Label |
Value |
|---|---|
|
Calibration |
1 |
|
Sample |
3 |
Control | 4 |
If the user selects multiple values, you want to show a table for all selected values. To achieve this, you can use the following filter expression for the table:
|
Expression |
Operation |
Value |
|---|---|---|
|
=Join(STypes, " ").Contains(Sample_Type) |
= |
=True |
The Join function returns a string, created by concatenating the elements of an array.In this example, the array is the multi-value report parameter STypes. The second parameter of the Join function (in this example, a space " ") is the delimiter to be used when creating the string.
The Contains function returns true, if the preceding string contains the characters given as a parameter to the Contains function.