Thanks for your reply, but your article really only addresses a very small part of the problem.

The requirement is to be able to check Active Directory to find out what user groups the logged in user is a member of, and then to filter the data according to rules set up for that group.

I have designed a complete solution that also requires two SSIS packages and have drafted a preliminary document outlining the entire process. I hope to submit this to SQLServerCentral in the near future, since I think it may break some new ground in what I would imagine might be a somewhat common reporting requirement.

Larry