Hello experts -
I am trying to use a multi value parameter to filter two different fields in a tablix. However, SSRS does not allow me to specify OR when adding filters. For example, the user selects options in the multi valued parameter and then those choices are used to filter two different fields in an OR statement
Parameter: 'Choose Event Type:' [user selects] J, R
I want the tablix to return all rows with a Start Event of J, R OR all rows with an End Event of J, R
In the attached example, I would want rows 10, 24, and 25 to be returned.
I originally had one filter setup to use for both fields but abandoned that in favor of two fields, please see the attached screen shot of SSRS.