Active Directory/LDAP Query
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=12416
Printed Date: 28 Apr 2024 at 8:08pm
Topic: Active Directory/LDAP Query
Posted By: MacJ
Subject: Active Directory/LDAP Query
Date Posted: 23 Feb 2011 at 9:27am
|
I have a connection to our Active Directory with Crystal Reports XI but not all the fields return data. With the command below I do not get data for description, departmentnumber, and lastlogon. However, data is there in those fields. Any ideas?
SELECT cn, description, extensionAttribute13, extensionAttribute14, operatingsystem, operatingsystemservicepack, operatingsystemversion, departmentNumber, lastLogon
FROM 'LDAP://OU=Refresh 09 SOF Computers,OU=Hardware Refresh OUs,OU=09 Cass,OU=SOF,DC=fssa,DC=state,DC=in,DC=us' where objectclass='computer' |
Replies:
Posted By: ChristaB
Date Posted: 14 Apr 2011 at 10:16pm
|
I am experiencing the same problem. THe description field is a string of 65534 and that is causing the issue. Way back many releases ago we had the same issue trying to display a blob/memo field from an Ingres database. This was resolved by a SP.
Maybe we should try and put a left(description,500) in the command query. I will try that on Monday.
 |
Posted By: ChristaB
Date Posted: 17 Apr 2011 at 11:10pm
|
The left-function did not work. Refer to http://forums.sdn.sap.com/thread.jspa?threadID=907943 - http://forums.sdn.sap.com/thread.jspa?threadID=907943 for a workaround. :-( |