Deploy SQL Server Report

Hi Dear friends,

Here I would like to share few important steps to deploy any report (i.e. rdl) file on Server. This rdl stands for Report Definition Language.

Actually to deploy a report there are following different ways to Deploy / Upload reports

1  Through MS Visual Studio BI Development Studio
2  Report Manager
3  SQL Server Management Studio
4  Programmatically (i.e. using RS.EXE) 

I have used the Microsoft Visual Studio 2008 and SQL Server 2008 and here I have selected first way to deploy a report.

Prior start deployment of a report please make sure following few things.

1.   In solution explorer select the project and Right click to go to properties menu, following wizard will be populated for few configurations which are must to deploy the report, important fields are mentioned in red colored entries.

      a.  StartItem - Here you have to select the report which you want show first on load.
      b.  TargetDataSourceFolder
      c.  TargetReportFolder - To store the folder in particular folder or in existing folder.
      d.  TargetServerURL - This is the url which you will get at the time of configuring the Report Server as shown in following screen and it is the URL of the report server,on which the reports will be deployed.

      e.  TargetServerVersion - Here you have to select the SQL Server version.

Note:
When any user will download the report in any one format (pdf,doc,exl etc) then the by default name of that file will be the name of the Report.