Filter in report for missing values

[hell2010]

hi
I need a little bit help.
how is it possible to filter a column where not one of 5 values are in column
i have a report where a user get permissioncodes an i need to find out which user have not min one of the permissioncode 11,16,24,55,36.
the repot is a simple list-report. for example the result of the report:

name user 1, section1, permission 11
name user 1, section1, permission 24
name user 1, section1, permission 33
name user 1, section1, permission 99
name user 2, section2, permission 49
name user 2, section2, permission 61
name user 2, section2, permission 62
name user 2, section2, permission 63
name user 3, section1, permission 04
name user 3, section1, permission 07
name user 3, section1, permission 55
name user 3, section1, permission 99

now the report must show only user 2

thanks a lot
bye

 

[drlex]

You don't say what product you're using, however the logic would be something like

SELECT DISTINCT [User] FROM [Table] WHERE [User] not in (SELECT DISTINCT [User] FROM [Table] WHERE [Permission] in (11,16,24,55,36))

soi là, soi carré

 

[hell2010]

Ohh sorry. I'm using Cognos 7.4