Here is my solution:

I am using Custom Query, with Data Source being any of your SQL servers (it just needs an MSSQL platform to execute the query).

Here is my query that I use to get a list of employees, some of their basic information and their managers:

SELECT 
EmployeeID, 
Name, 
givenname, 
sn, 
mail, 
title, 
department, 
displayname,
REPLACE(SUBSTRING(manager,4,CHARINDEX(',OU=',manager) - 4),'\','') as manager
--this manager lookup was a bit tricky to setup but it works!

FROM OPENQUERY (ADSI,
'SELECT  
userAccountControl, 
manager, 
name, 
employeeID, 
department, 
mail, 
givenname, 
sn, 
title, 
displayname 

FROM ''LDAP://OU=YourOUgoesHere,DC=YourDCgoesHere,DC=YourDCgoesHere'' 
--You can find your LDAP information if you select any user in your AD environment and then look at the "distinguishedName" attribute, ignore the CN, and OUs depending on how many 'subfolders' you have.
WHERE objectCategory = ''Person'' AND objectClass = ''user''')
--The first Where statement is for AD to specify a user
WHERE employeeID <> 'NULL' and useraccountcontrol <> '66050' and title <> 'Vendor' and title not like '%Workstudy%'
--The second Where statement is for the data to exclude missing anything that isn't an employee in our environment
--The useraccountcontrol 66050 is eliminating disabled accounts
ORDER BY name

I truly hope that this helps someone, it works pretty well. You can always modify this report and have it select other columns by replacing the attributes in the SELECT statements. Whatever attribute you want to add, you have to select it in both SELECT statements otherwise you will get an "invalid column name" error.

Again, this can query to AD can be done against any SQL database!