Deploying an SSRS report to the Report Server

The final step in the creation of an SSRS report is to deploy the report definition file to the Report Server from which it is to be called and run.

To deploy the report definition file:

  1. Verify that your project is set up to use the correct deployment settings:
    1. In the Solution Explorer, right-click the name of your project.
      (Be aware that this is not the *.rdl file, but rather the top-level project entry.)
    2. From the context menu, select Properties.
    3. In the Project Property Pages dialog box, verify that you are using the correct settings.
      If necessary, change those that are not set correctly. The fields that you are particularly concerned with are:
      • TargetReportFolder – Set this to the name of the report folder on your report server in which report definition files are deployed.
      • TargetServerURL – Using a standard HTTP path, specify the name and location of the report server to which reports are deployed.

        Typically, this follows the format: http:// serverName/ReportServer, where serverName is the DNS or IP address of your Report Server.

      • TargerServerVersion – Verify that this is SQL Server 2008 R2. Other versions do not work.
  2. Deploy the report definition file:
    1. Right-click the name of your RDL file.
    2. From the context menu, select Deploy.