Hi

I've come back to CR Reporting after a long layoff and forgotten most of what I used to use, so I need help.

I am using CR XI to query Active directory. I want to produce a list of all groups and their  users.
As far as I can see there is no way via ADO to created the required SQL Statement.

So far I have two test reorts which do what I want.
The first
SELECT distinguishedName FROM 'LDAP://dc=Blah,dc=local'
WHERE  objectCategory='Group'
and
SELECT sAMAccountName, distinguishedName
     FROM 'LDAP://dc=Blah,dc=local'
     WHERE objectClass='person' AND  memberOf=
'CN=mygroup,DC=Blah,DC=local'

Is there any way of creating a report using the second qury based on the results of the first query.
e.g. using the distinguishedName from query 1 instead of 
CN=myGroup,DC=Blah,DC=local

Cheers
Taoh