Skip to Content
0
Former Member
Feb 18, 2009 at 08:06 PM

Report connecting to AD only returns maximum 1000 records

173 Views

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.