Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Active Directory/LDAP Query Post Reply Post New Topic
Author Message
MacJ
Newbie
Newbie


Joined: 23 Feb 2011
Online Status: Offline
Posts: 1
Quote MacJ Replybullet Topic: Active Directory/LDAP Query
    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'

IP IP Logged
ChristaB
Newbie
Newbie
Avatar

Joined: 14 Apr 2011
Location: South Africa
Online Status: Offline
Posts: 2
Quote ChristaB Replybullet 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.Cry
IP IP Logged
ChristaB
Newbie
Newbie
Avatar

Joined: 14 Apr 2011
Location: South Africa
Online Status: Offline
Posts: 2
Quote ChristaB Replybullet Posted: 17 Apr 2011 at 11:10pm

The left-function did not work.
Refer to http://forums.sdn.sap.com/thread.jspa?threadID=907943 for a workaround.  :-(
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.