I have a Security report showing Employees with Multiple Roles, grouped by employee.
ie. Employee1 Role1
Role2
Role3
Employee2 Role1
Role2
I'd like to filter the report to remove all employees who have Role3, however am unable to get the filter working properly. I'm using a relational data source in Report Studio.
Thanks in advance :)
What is your current filter expression?
very vague statement. do you mean you are getting an error? if so, what is the error?
or are you getting wrong data? again please state how you are doing the filter expression.
Quote from: Jackal on 08 Oct 2014 10:20:56 AMhowever am unable to get the filter working properly
Hi Jackal,
I am not sure about your filter which your using currently but try to filter using following expression
Role<>3
or Role <> Role 3
please explain your issue in detail again
Regards
bvk
The filter i'm using indicates [Role] not in (Role3, Role4) and i've set the scope to the Employee.
From my understanding, it should remove the entire Employee Row. What it actually does is just remove the role from the employee, but not the entire employee row.
Try the attched report.
Cheers,
Rajesh Vanam