Ad Hoc Reports

Custom reports can be created using Microsoft® Report Builder 3.0, and accessed from Report Manager. These custom reports are listed under the heading "Ad Hoc".

Configuration of the location of these reports is located in the System Settings options (System Settings… > Environment > SSRS). Refer to the topic titled SSRS Settings for additional information. When the settings for SSRS have been configured, the ad hoc view will be visible. Ad hoc reports are fully customizable and configured using Microsoft® Report Builder.

Previewing Ad Hoc Reports

To preview ad hoc reports:

1. Expand the Ad hoc folder group to see a listing of all custom reports.
2. Select the report you wish to run from either the folder list or the right side of the window.
3. The right side of the window changes and the Execute button is enabled.
4. Click the Execute button to run the report. The report viewer will open.

Creation and management of SSRS reports is outside the scope of DocLink. Microsoft® Report Builder can be used to author any type of business report. For detailed information about Report Builder and how to create and manage reports, please visit Microsoft's website: SQL Server 2012 Report Builder