How to: Upload Report Samples (Report Manager)

  • Article

[This topic is pre-release documentation and is subject to change in future releases. Blank topics are included as placeholders.]

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).

Note

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 AdventureWorks2008R2. 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 AdventureWorks2008R2 database. An example of the connection string for a local AdventureWorks2008R2 database is as follows:

      data source=(local);initial catalog=AdventureWorks2008R2

    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\AdventureWorks2008R2 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 AdventureWorks2008R2 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).

See Also

Tasks

How to: Start Report Manager

Other Resources

Finding and Viewing Reports in Report Manager
Considerations for Installing SQL Server Samples and Sample Databases
Report Samples (Reporting Services)
How to: Publish Report Samples

Help and Information

Getting SQL Server 2008 R2 Assistance