Andyleates
Technical User
I have a similar issue to posed in this thread thread931-1453644 a few years ago, which never seemed to get answered. I wonder is anyone else has tackled this.
"Looking for some help figuring out why some AD schema attributes will not show data in crystal. I am using OLE DB (ADO) Active Directory Services Interface as my connector. I am creating a simple report, user name, when the account was created, last good logon, last logoff, last bad logon, and bad password count. I dont have any problem writing the ldap connection string and i get all the fields/attributes i want. My problem is some of the fields are empty of data in crystal even though i know they have data in AD. it seems to be a datatype issue im guessing. In the AD schema lets say the attribute is lastLogon, the data type is Large Integer/Interval(even though its a date and time stamp), if you look at it in crystal it states its a string. I am not sure if this is the problem or not but any AD attributes with the data type Large Integer/Interval comes out in crystal as string and displays no data. Now its also my understanding AD stores date and time stamps as some long integer and needs to be decoded to show the human readable date and time one would expect to see(i will deal with that in due time), but i cant get crystal to even show that long integer. Any thoughts on this would be a great help."
Andy Leates MCSE CCNA MCP+I
"Looking for some help figuring out why some AD schema attributes will not show data in crystal. I am using OLE DB (ADO) Active Directory Services Interface as my connector. I am creating a simple report, user name, when the account was created, last good logon, last logoff, last bad logon, and bad password count. I dont have any problem writing the ldap connection string and i get all the fields/attributes i want. My problem is some of the fields are empty of data in crystal even though i know they have data in AD. it seems to be a datatype issue im guessing. In the AD schema lets say the attribute is lastLogon, the data type is Large Integer/Interval(even though its a date and time stamp), if you look at it in crystal it states its a string. I am not sure if this is the problem or not but any AD attributes with the data type Large Integer/Interval comes out in crystal as string and displays no data. Now its also my understanding AD stores date and time stamps as some long integer and needs to be decoded to show the human readable date and time one would expect to see(i will deal with that in due time), but i cant get crystal to even show that long integer. Any thoughts on this would be a great help."
Andy Leates MCSE CCNA MCP+I