Crystal Reports and Active Directory

[Guest]

Hello!

So far, I can't find any information on making a connection to active
directory for reports in visual studio .net 2003.

From the list of Available Data Sources I select "OLE DB (ADO)" and from the
list of OLE DB Providers I select "OLE DB Provider for Microsoft Directory
Services". On the next screen where I put in my data source I try something
like: LDAP://OU=<ou>,DC=<dc1>,DC=<dc2> OR
LDAP://OU=<ou>,DC=<dc1>,DC=<dc2>;samaccountname;subtree (for example)

When I click 'Finish' a tree node labelled "Active Directory Service
Interface" under OLE DB (ADO) shows up with "...no items found..."

I'm not sure what to do. Is there something wrong with my LDAP query or am I
looking to make the connection in the wrong place or the wrong way?

 

[AMDRIT]

I would propose that you instead specify a strongly typed dataset, manually
populate the dataset via code, and pass the dataset to your report. This
will allow you to have an easier time in development, plus it would be
easier to take advantage of custom properties in AD.

Example,

Table: Domains
Table: OrganizationalUnits
Table: Users
Table: Groups
Table: Workstations
Table: Printers
Table: Servers
Table: EventLogs
Table; EventLogEvents