How to: Upload Report Samples (Report Manager)

You can use Report Manager to upload the sample reports to the report server. Before uploading reports, you must first create a shared data source for the reports. If you do not want to perform all these steps, you can deploy the sample reports solution using Business Intelligence Development Studio. For more information, see How to: Publish Report Samples. For more information about how to install samples, see Initial Installation (Reporting Services).


To create a data source and upload files to a folder on the report server, you must have permissions to manage reports for the folder. If My Reports is enabled, you automatically have these permissions for your My Reports folder. For more information, see Managing My Reports.

To upload sample reports using Report Manager

  1. Start Report Manager.

  2. Click New Data Source, and then do the following:

    1. In Name, type AdventureWorks. The sample reports reference the data source by this name.

    2. In Description, type a description or leave the field blank.

    3. Select Enable this data source.

    4. From Connection Type, select Microsoft SQL Server.

    5. In Connection String, provide the connection string to the database that contains the AdventureWorks database. An example of the connection string for a local AdventureWorks database is as follows:

      data source=(local);initial catalog=AdventureWorks
    6. From Connect Using, select Windows Integrated Security.

  3. Click OK to save the data source and return to the folder view.

  4. Click Upload File, and then click Browse to navigate to the folder that contains the sample reports. By default, the samples are located at C:\Program Files\Microsoft SQL Server\100\Samples\Reporting Services\\Report Samples\AdventureWorks Sample Reports.

  5. Click .an .rdl file to upload, and then click Open. Some .rdl files use an Analysis Services cube as a data source. Review the sample description on the Codeplex site to verify that the reports you are uploading use the AdventureWorks relational database.

  6. Click OK to open the file.

  7. Repeat steps 5 through 7 for the remaining sample reports.

  8. Open the reports and set the data source property to use the shared data source you created in step 2. For more information, see How to: Configure Data Source Properties for a Report (Report Manager).