title: How do I create a Crystal Report that lists members of Active Directory Groups
body: <p>I have a task to automatically email a report of who is in a series of groups in AD.  I'd like to schedule a report to run once a month from Crystal Reports.</p>
  
  <p>I have followed the instructions to create the OLE DB (ADO) connections and everything connects fine.  </p>
  
  <p>In my SQL query, I try:</p>
  
  <pre><code>SELECT member, descripton from 'LDAP://ou=blah,dc=blach,dc=blah' where  cn ='TheGroupName'
  </code></pre>
  
  <p>Crystal Reports allows this command to work.  (of course with real server parameters)  ;)</p>
  
  <p>However, the member list is blank and the description list is blank.  If I add distinguishedName to the SELECT, it returns, so I know it's able to get the object attributes.</p>
  
  <p>Also, I've noticed nested groups.  I would probably need to expand those out until I get the user list.</p>
  
  <p>For example:</p>
  
  <hr>
  
  <p>Group1</p>
  
  <ul>
  <li>Joe</li>
  <li>Jane</li>
  <li>Group2</li>
  <li>Group3</li>
  </ul>
  
  <p>Group2</p>
  
  <ul>
  <li>Larry    </li>
  <li>Michael</li>
  </ul>
  
  <p>Group3</p>
  
  <ul>
  <li>Tuan</li>
  <li>Huyen</li>
  </ul>
  
  <p>I saw a post that suggests doing a ldif to a file and then using CR to parse through it.  I'd like to keep this report simple as possible.</p>
  
  <p>Is it even possible to do this?</p>
  
  <p>Thanks,
  TT</p>