Hi Nikhil,
If I understand correctly, there are three parameters in your report, and you want to filter Region or First_Name or Last_Name field based on those parameters.
In Reporting Services, the relationship of filters is And, and there is no option to change the relationship from And to Or. While we can use or operator within the expression to create one filter to integrated all filters as below in the table to
work around this issue.
Expression:
- If those parameters are multiple parameters:
=instr(join(Parameters!Region.Value,","),Fields!Region.Value)>0 or instr(join(Parameters!First_Name.Value,","),Fields!First_Name.Value)>0 or instr(join(Parameters!Last_Name.Value,","),Fields!Last_Name.Value)>0
- If those parameters are single parameters:
= Parameters!Region.Value=Fields!Region.Value or Parameters!First_Name.Value=Fields!First_Name.Value or Parameters!Last_Name.Value=Fields!Last_Name.Value
Type: Boolean
Operator: =
Value: true
If there are any other questions, please feel free to ask.
Thanks,
Katherine Xiong