Summary Filter

[jmills]

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  :)

[bdbits]

What is your current filter expression?

[Francis aka khayman]

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.

however am unable to get the filter working properly

[bvk.cognoise]

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

[jmills]

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.

[Rajesh_Vanam]

Try the attched report.


Cheers,
Rajesh Vanam