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 of these steps, you can deploy the sample reports solution using Business Intelligence Development Studio. For more information, see How to: Publish Report Samples (Report Designer).


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 by typing its URL in the address bar of a Web browser. By default, the URL is http://*<webservername>*/reports.

  2. Navigate to the destination folder for uploaded reports. For more information, see Finding and Viewing Reports in Report Manager.

  3. 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 NT Integrated Security.

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

  5. Click Upload File, and then click Browse to navigate to the folder that contains the sample reports.

  6. Click the file to upload, and then click Open.

  7. Click OK to open the file.

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

See Also


How to: Start Report Manager (Report Manager)
How to: Publish Report Samples (Report Designer)

Other Resources

Installing AdventureWorks Sample Databases and Samples
Report Samples (Reporting Services)

Help and Information

Getting SQL Server 2005 Assistance