Last post Jul 24, 2019 06:51 PM by StrangerMike
Jul 24, 2019 05:50 PM|StrangerMike|LINK
I have an SSRS report that I have a parameter and a filter. Records comes in with a field called Clocked that contains either 'No' or 'Yes'.
When the user selects either one from a dropdown parameter and views report, the filter only brings back those records that were selected, being 'No' or 'Yes'.
Now the users want another option: 'Both', but the field in the record only contain the words 'No' or 'Yes'.
Is there a way to build an expression for the filter that states if the parameter selected is a 'both' then bring back all records. If not it must be a 'No' or 'Yes' so bring back those records where the field Clocked matches what is in the Clock Parameter?
like: =IIF Parameters!Clocked.Value = "Both", Fields!Clocked.Value <> "", Parameter!Clocked.Value) Or something to that affect.
Jul 24, 2019 06:01 PM|mgebhard|LINK
Use a wild card, %, if both is selected.
Jul 24, 2019 06:42 PM|StrangerMike|LINK
I just tried using, Clocked <> 'Yes', which gives me all the 'No', <> 'No' which gives me 'Yes' and then Clocked <> 'Both' which gives me all. So that worked
I went back to try your suggestion (making clocked 'like' 'Yes', or 'like' 'No', and I tried Like %, but it did not return any records.
Did I do something wrong?
Jul 24, 2019 06:51 PM|StrangerMike|LINK
Never mind, I tried an * asterisk and that worked for the wild card. Thanks