Trying to Retrieve Active Directory User data in Crystal Reports

[RoMarcus]

CR XI
W2003 AD / Terminal Server / Citrix

I'm excellent at creating reports; not great at writing scripts and stored procedures. I need to create a report that shows the AD users 'MemberOf' information.

OU name is 'Locations'
domain name is 'corp' or 'corp.cd'

I've searched this group and I cannot seem to 'get it'

Step by step instructions would surely be appreciated.

What I've done so far....

Create New Connection
OLE DB ADO
OLE DB Provider for Microsoft Directory Services {next}

(on this page it asks for data source, user id, password or integrated security - I've selected Integrated Security and left datasource blank)

Then I get a "Add Command" option

I open that up and type in
SELECT name, memberof FROM 'LDAP://OU=Locations,DC=corp.cd'

( I've also tried using double-quotes)

I click on OK and get the following error message

Failed to retrieve data from the database. Details ADO Error Code 0x80040e14
Source: Provider
Description: Table does not exist.
Native Error -2147217900 Crystal



When I use double quotes, I get this error message:

Failed to retrieve data from the database. Details ADO Error Code 0x80040e14
Source: Provider
Description: One or more errors occurred during the processing of command.
Native Error -2147217900

What am I missing? I've tried this as administrator with full access and get the same response.

Any thoughts?

Again I am a newbie to writing code so please be specific in your reply.