You use the Active Roles Collector to prepare data for reporting. The data is stored in the database you specify when configuring the data collection job (see Collector to prepare data for reports earlier in this chapter). In order to make the data available to the report server, the data source on the report server must be configured to connect to the database that holds the report data. Then, you can generate and view Active Roles reports.
You have the option to configure the data source when deploying Active Roles reports to the report server (see Deploying reports to the Report Server earlier in this document). If you have not configured the data source, or need to change the data source, then you can do this by using Report Manager on the report server on which the Active Roles reports were deployed.
To configure the data source by using SSRS Report Manager
Report Manager is installed during setup of SQL Server Reporting Services (SSRS) on the same computer as the report server. To start Report Manager, open Internet Explorer, and then, in the address bar of the Web browser, type the Report Manager URL. By default, the URL is http://<ComputerName>/reports.
If the SharedDataSources item is not displayed, click Details View.
For example, if the name of the database is ARServerReporting and the database is on the SQL Server instance named MyServer\Enterprise, then the connection string is as follows:
data source = MyServer\Enterprise; initial catalog = ARServerReporting
You can generate and preview Active Roles reports using SSRS Report Manager. This section provides basic instructions on how to use Report Manager for this purpose.
The following instructions assume that report data has been prepared by using the Active Roles Collector and the data source on the report server has been configured to connect to the database that holds the report data.
To view a report by using SSRS Report Manager
To start Report Manager, open Internet Explorer, and then, in the address bar of the Web browser, type the Report Manager URL. By default, the URL is http://<ComputerName>/reports.
Browse folder contents by clicking a folder name or folder icon on the Contents page. Search for a report by typing all or part of the report name in the Search text box at the top of that page.
Some reports require you to provide parameter values. You can also apply filters to specify what data you want the report to include.
For detailed instructions on how to use Report Manager, refer to Microsoft SQL Server Books Online.
This section lists the reports provided by the Active Roles Report Pack. The list is organized into sub-sections. Each sub-section heading identifies the path to a certain report folder, with the reports contained in that folder being listed under the sub-section heading.