Reputation: 928
Let's say I have a report with following table in the body:
ID | Name | FirstName | GivenCity | RecordedCity | IsCorrectCity
1 | Gates | Bill | London | New York | No
2 | McCain | John | Brussels | Brussels | Yes
3 | Bullock | Lili | London | London | Yes
4 | Bravo | Johnny | Paris | Las Vegas | No
The column IsCorrectCity
Basically includes an expression that checkes GivenCity
and RecordedCity
and returns a No
if different or a Yes
when equal.
Is it possible to add a report filter on the column IsCorrectCity
(and how) so the users will be able to just select all records with No
or Yes
? I know this can be done with a parameter in the SQL query, but I would like to add it based on the expressions rather then adding more calculations and all to the query.
Upvotes: 0
Views: 1452