Unfortunately the DS groups aren't stored in the alert database, which is the only place Crystal can access. The only kind of "group" that is actually in the database is the subscription group (which shows which rules a user is subscribed to), the rest all just exist as metadata and are inaccessible to reports. We'll have to look at a way to expose our resources downstream, this is a good example of how it's useful.
So, you'll need to find a way to deal with this outside of the LEM database. You could use a text file as a resource and have it periodically updated? If you run "net group <groupname> /domain" on the command line it would output a list of all of the users that are members of that group by their account name. The output of that one might need some work to be fed directly in, though. On a server you can also use the dsquery tool, but chances are you aren't.
I can't say we've tried using Crystal with AD directly, but if you can specify the single item/property you want from the directory, it's most likely sAMAccountName.
Thanks Nicole, I was afraid that this was going to be the case. Since these group memberships almost never change, I believe I am going to just setup an Alert to send an email on group membership change, with a Note in the Email template to update the Crystal Report.
Not as dynamic as I wanted however the work to make it dynamic "Run a DSQuery > Dump to XLS (On Schedule) > Reference XLS as a Datasource" doesnt make sense for me as my time is already a precious commodity . If we start seeing a lot of changes I might have to revisit this in the future.