I have a need to determine what security group(s) a user is a member of from within a SQL Server Reporting Services report. Access to the report will be driven by membership to one of two groups: 'report\_name\_summary' and 'report\_name\_detail'. Once the user is executing the report, we want to be able to use their membership (or lack of membership) in the 'report\_name\_detail' group to determine whether or not a "drill down" should be allowed.

I don't know of any way out of the box to access the current user's AD security group membership, but am open to any suggestions for being able to access this info from within the report.