How to View a Report with SQL Server Reporting Services

By Mark Robinson

Part of Microsoft SQL Server 2005 Reporting Services For Dummies Cheat Sheet

Viewing a report with Microsoft SQL Server 2005 Reporting Services requires that your computer have at least a connection to the server that’s running the report server. If you’ve installed the sample reports from the Reporting Services installation CD, you should be able to view a sample report by following these steps:

  1. Connect to the Report Manager by pointing your favorite web browser to http://localhost/reports.

    The Report Manager home page appears. You’ll see a folder for Sample Reports, as well as any other folders defined on your report server. You’ll also see the menu options related to site settings and subscriptions. Click the Show Details button (which then toggles to a Hide Details button) to see who created the folders and when they were last modified.

  2. Select the folder that you want to view and click it.

    Report Manager displays the contents of the Sample Reports folder. The folder consists of reports, resources, and (possibly) other folders defined on the report server. Each report in the Sample Reports folder can have a description (if provided), as well as a listing of the last date modified and who modified it.

  3. Select the report that you want to view and click it.

    Report Manager displays the report. The report shows all the information based on any parameter values entered, as well as on the security enforced on the report server.

    A toolbar option enables export to a different format. This is a way to change the reported information into a spreadsheet or a PDF for sharing and collaborating with others.

  4. Click the Back button when you finish viewing the report.

    Alternatively, you can link back to the original report folder by clicking the link on the breadcrumb trail in the top-left of the Report Manager window.