Tutorial Gateway

  • C
  • C#
  • Java
  • Python
  • SQL
  • MySQL
  • Js
  • BI Tools
    • Informatica
    • Talend
    • Tableau
    • Power BI
    • SSIS
    • SSRS
    • SSAS
    • MDX
    • R Tutorial
    • Alteryx
    • QlikView
  • More
    • C Programs
    • C++ Programs
    • Go Programs
    • Python Programs
    • Java Programs

Deploying Reports in SSRS

by suresh

In this article, we will show you the steps involved in deploying reports in SSRS using BIDS. Or, how to Deploy SSRS Projects in SQL Server Reporting Services Data Tools to Report Manager with an example.

The below screenshot shows the Shared Datasets, Shared Data Sources, and SSRS Report present in this project.

Deploying Reports in SSRS

Before we start deploying reports in SSRS Project, we have to configure the Reporting Server properties. So, Right-click on the project name (here, SSRS Projects) and select Properties as shown below

Deploying Reports in SSRS 2

Once you click on the Properties option, a new window called SSRS Projects Property Page will open to configure the settings. The following are some of the properties in the SSRS Report Deployment section:

  • TargetDatasetFolder: Please specify the folder name where you want to deploy the Shared Datasets present in this project. By Default, Datasets is the name, but you can change as per your requirement.
  • TargetDataSourceFolder: Please specify the folder name where you want to deploy the Shared Data Sourcespresent in this project. By Default, Data Sources is the name, but change as need.
  • TargetReportFolder: Please specify the folder name where you want to deploy the SSRS Reports we created in this project. By default, the Project name will assign to this. You can alter as per your requirement.
  • TargetReportPartFolder: Please provide the folder name where you want to deploy the Report Parts present in this SSRS project (If any). By Default, Report parts are the name.
Deploying Reports in SSRS 3

OverwriteDatasets: This property holds two options TRUE and FALSE. If the current project and Reporting Server has the same Shared Dataset name then:

  • If you set this option to TRUE, the Report Server will overwrite the Destination dataset with current project Dataset
  • And, If you set this option to FALSE, Report Server will keep the Destination Dataset. This is the default value
Deploying Reports in SSRS 4

OverwriteDatasources: This property hold two options TRUE and FALSE. If the current project and Reporting Server has the same Shared Data Source name then:

  • If you set this option to TRUE, Report Server will overwrite the Destination data source with the current project data source
  • And, If you set this option to FALSE (Default value), the Report Server will keep the Destination data source.
Deploying Reports in SSRS 5

TargetServerVersion: Please specify the Version of the Report Server you are using. This property has three options: SQL Server 2008, SQL Server 2008 R2 or later and Detect Version. We are using SQL Server 2014 so, and we selected the SQL Server 2008 R2 or later option.

Deploying Reports in SSRS 6

TargetServerURL: This property is used to provide the Target URL where we want to deploy the SSRS project. For instance, If you’re going to deploy to a report server installed in share point, then provide the site URL.

In this example, we are deploying to the default web server of a report server native mode so, we are placing the URL of that web server

Deploying Reports in SSRS 7

Click on the Apply button to finish modifying the project properties. Next, go to solution explorer and right-click on the project name to open the context menu. From the context menu, please select the Deploy option as shown in below screenshot

TIP: Please Run the BIDS as Administrator, If you don’t have the privileges.

Deploying Reports in SSRS 8

You can see the SSRS output window to check for deployed reports

Deploying Reports in SSRS 9

Next, open the Report Manager in Internet Explorer to view the deployed SSRS project.

TIP: Please Run the Browser as Administrator, If you don’t have the privileges.

Deploying Reports in SSRS 10

Double click on the Data Source folder to check the shared data sources in the project

Deploying Reports in SSRS 11

Double click on the Dataset folder to check the shared datasets in the project

Deploying Reports in SSRS 12

Next, Double click on the SSRS Projects folder to check the deployed SSRS Reports present in the project

Deploying Reports in SSRS 13

Placed Under: SSRS

  • Learn SSRS in 28 Days
  • Create New SSRS Project
  • Create a New SSRS Report
  • SSRS Query Designer
  • SSRS Shared Data Source
  • SSRS Shared Dataset
  • SSRS Embedded Dataset
  • SSRS Embedded Data Source
  • SSRS Lookup – combine datasets
  • SSRS Report Items
  • SSRS Table Report
  • SSRS Table using report wizard
  • Format SSRS Table Report
  • SSRS Matrix Report
  • SSRS Matrix with report wizard
  • Display Image in SSRS Report
  • Add Rectangle to SSRS Report
  • Add TextBox to SSRS Report
  • Create a SSRS List Report
  • Grouping in SSRS Matrix Reports
  • Grouping in SSRS Table Reports
  • Create SSRS Report using Views
  • SSRS report with store procedure
  • Add Total and Subtotal to Report
  • Add Headers & Footers to Report
  • SSRS Global References
  • Export Report to PDF, XML, Excel, Word
  • Format SSRS Table Report
  • Format Textbox Fonts & Bg Color
  • Format Numbers in SSRS Report
  • Format SSRS Report Date, Time
  • Add Row Numbers to Report
  • Headers Visible While Scrolling
  • Repeat Headers on Each Page
  • SSRS Sorting
  • SSRS Interactive Sort
  • Filters at Dataset Level in SSRS
  • Filters at Tablix Level in SSRS
  • Page Breaks in SSRS Report
  • Custom Code in SSRS Report
  • SSRS Calculated Fields
  • SSRS Dashboard Reports
  • SSRS Document Map
  • SSRS Drill Through Reports
  • SSRS Drill Down Reports
  • SSRS Drill Down Matrix Report
  • SSRS Go To URL Action
  • SSRS Subreports
  • SSRS Report Parameters
  • SSRS Cascading Parameters
  • SSRS Multiple Parameters
  • SSRS Multi Value Parameter
  • SSRS Drop Down List Parameters
  • SSRS Charts
  • SSRS Area Chart
  • SSRS Bubble Chart
  • SSRS Column Chart
  • Format SSRS Column Chart
  • SSRS Data Bars
  • Data Bars in SSRS Matrix Reports
  • Format SSRS Data Bars
  • SSRS Funnel Chart
  • SSRS Linear Gauges
  • SSRS Radial Gauges
  • Format SSRS Gauges
  • SSRS Indicators
  • Format SSRS Indicators
  • SSRS Line Chart
  • SSRS Pie Chart
  • Format SSRS Pie Chart
  • SSRS Pyramid Chart
  • SSRS Range Chart
  • SSRS Radar Chart
  • SSRS Scatter Plot
  • SSRS Sparkline
  • SSRS Stacked Bar Chart
  • SSRS Configuration Manager
  • Change Report Manager Title
  • SSRS Deploying Reports in BIDS
  • Deploy using Report Manager
  • SSRS Report Manager Shared DataSource
  • SSRS Cached Reports
  • SSRS Linked Reports
  • SSRS Report Parts
  • SSRS Report Snapshot
  • SSRS Report History Snapshot
  • SSRS Report Subscription
  • SSRS Security
  • Upload File to Report Manager
  • Install SSRS Report builder
  • Report Builder – Create a Report
  • Report Builder – Create a Dataset
  • Report Builder- Create Bar chart
  • Report Builder – Create Pie Chart
  • Report Builder – Create report without wizard

Copyright © 2021 · All Rights Reserved by Suresh

About Us | Contact Us | Privacy Policy