Hi there,
I have a Crystal Report that connects into Active Directory and the connection is set up as: OLE DB (ADO) Active Directory Service Interface.
I use the below SQL query to connect and return data:
SELECT sapUsername, samAccountName FROM 'LDAP://DC=company,DC=com' WHERE objectClass='user' and objectCategory='person'
This works fine and I get results back. However, i have noticed that only 1000 records are being returned when I know there should be a lot more!
I have read about setting the Page Size to a value greater than 1000 as you are restricted to this value unless specifically specified.
My question is: How or Where do i declare this Page Size value?
Many thanks,
Bernard.