×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Business Objects: Crystal Reports 2 Data Access FAQ

Connection Problems

Reporting of Active Directory (v. 9 & 10) by poujor
Posted: 24 Aug 04

I have had a lot of problems reporting on data from Active Directory. The Article c2016008 on http://support.businessobjects.com/library/kbase/articles/c2016008.asp is a very good starting point.
The Examples applied are not that good though. Below is an example of how to select fields from Active Directory:

Select distinguishedName, cn, mail, sAMAccountName, userPrincipalName, telephoneNumber, department, userAccountControl, objectClass
From
'LDAP://DC=CrystalReports, DC=com'
Where ObjectClass='User'

Above retrieves the following fields:
distinguishedName, cn, mail, sAMAccountName, userPrincipalName, telephoneNumber, department, userAccountControl, objectClass
FROM the domain CrystalReports.com
WHERE The ObjectClass Is USER.

Tools to use to figure out field names etc. is: AdisEdit (Adsiedit.msc). This tool is a part of the support tools for windows 2000 or 2003 server.
Also Schema Management (SchmMgmt.msc) might be of interest. Be careful with this tool it can be very destructive if you start modifying. To use this tool the following dll is to be registered: schmmgmt.dll. This is done in the following way:
Regsvr32 %systemroot%\system32\schmmgmt.dll
To use the Schema Management tool the adminpak.msi is required to be installed on the computer you are using it.

On windows 2000 professional use the adminpak.msi from windows 2000 server editions. On wWindows XP use the Adminpak.msi from windows 2003 server editions.

Back to Business Objects: Crystal Reports 2 Data Access FAQ Index
Back to Business Objects: Crystal Reports 2 Data Access Forum

My Archive

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close