It seemed like an eminently reasonable request, and something a Microsoft developer surely would have thought of, right?
After all, there is a Built-In Field that gives us UserID. OK, so what Windows AD groups is that user a member of, because that just might determine what information s/he sees in a report? A logical thing to expect . . .
We have an internal enterprise framework that provides some nice and easy (and reusable!) functionality to return Active Directory information, so perhaps I can just add a Reference in my SSRS Customer Code and call one of those handy functions. Oops - SSRS, even in Visual Studio 2010, supports only the .NET 2 Framework, so it doesn't like a reference to something newer.
OK, this can't be that hard, right? Using a couple of .NET (2!) references to System.DirectoryServices and System.Security, I wrote some code that should return all a user's groups. No more errors, but still doesn't seem to work.
Has anyone attempted something like this? It seems like something that might be commonly used, particularly for reports in a larger organization, where you might want to filter data by a user's security groups.
Any and all comments are greatly appreciated - thanks!
(To close the loop here, I should add that a separate table will have a list of which user groups can access which information, perhaps by a business segment code or similar.)
United Health Group, UHG IT Infrastructure Services