reports on AD elements

Is there a way that RS can create reports using the DC
Active Directory as the data source? I need to pull a
report listing two fields: User and e-mail address(from
exchange). Any help is appreciated. Thanks, RonI found the info. it is included in case someone else would like to know how to do it:
Other Data Sources
One exciting aspect of SRS is its ability to query multiple data source types in addition to SQL Server. Any ODBC or OLE-DB provider can be a potential data source for SRS. We will be covering two of these additional providers while covering both developing reports in SRS as well as examining an overall Business Intelligence platform with Analysis Services in a later chapter.
For a simple example of using a data source other than a SQL Server database, let=D5s look at the OLE-DB Provider for Directory Services. By using a direct LDAP query, it is possible to generate field information for use in SRS.
SELECT cn,sn,objectcategory,department
FROM 'LDAP://DirectoryServerName/ OU=3DOuName ,DC=3DCompany,DC=3DCom'
The query uses a standard SQlLdialect that will return the common name, surname, objectcategory (computer or person) and department from the Active Directory. The field names will be automatically created and can be used like any other data field for a report.
There are couple of caveats that must be taken into consideration when querying AD, as well as other data sources that do not support the graphical query designer in SRS.
* Query Parameters are not supported directly in the query, however, Report Parameters can be defined and utilized both in the query, referred to as dynamic query, or used to filter data.
* Because a graphical query designer is not available, the query will need to be developed in the generic query designer by typing the query directly and testing. This requires knowledge of Active Directory objects and names.
Tip: There are several tools available to assist in the development and management of Active Directory, such as ADAM (Active Directory Application Mode) and LDP, an Active Directory tool included in the Windows Support Tools.
>--Original Message--
>Is there a way that RS can create reports using the DC >Active Directory as the data source? I need to pull a >report listing two fields: User and e-mail address(from >exchange). Any help is appreciated. Thanks, Ron
>.
>