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

Deploy SSRS Reports using SSRS Report Manager

by suresh

In SSRS, Deploying the reports is very easy and straight forward, and thanks to Microsoft for giving multiple ways to deploy SSRS reports. In this article, we will explain how to Deploy SSRS Reports using SSRS Report Manager

We already explained the steps involved in Deploying the reports using the BIDS in Deploying Reports article.

Before we start to deploy SSRS reports using SSRS Report Manager, Let’s open Report Manager to see the existing Data Sources, Datasets, and reports.

Deploy SSRS Reports using SSRS Report Manager 1

Deploy SSRS Reports using SSRS Report Manager

To deploy SSRS Reports, the Report manager provides an option called Upload File. In this example, we will use this option to deploy the SSRS Dashboard report that we created in our previous article.

Deploy SSRS Reports using SSRS Report Manager 2

By clicking the Upload File Menu item, it will open the following page. You can use this page to upload .rdl, .smdl, Shared datasets, Report Parts into the report manager. Or you can say, Use this Report manager page to deploy SSRS reports.

  • Browse: This button will open the File dialogue box to browse the local file system and select the required file.
  • Name: Once you upload a file, this text box will automatically fill with the selected file name, but you have an option to change it as per your requirements.
  • Overwrite item if it exists: If there is a file with the same name in the report manager, then selecting this option will overwrite the existing file.
Deploy SSRS Reports using SSRS Report Manager 3

As you can see we are selecting the SSRS Dashboard report present in the Documents -> Projects -> Charts folder

Deploy SSRS Reports using SSRS Report Manager 4

Click OK to upload or deploy the report

Deploy SSRS Reports using SSRS Report Manager 5

Now you can see our deployed report on the Report Manager Home page.

Deploy SSRS Reports using SSRS Report Manager 6

Please click on the deployed report to see the report preview

Deploy SSRS Reports using SSRS Report Manager 7

As you can see, it does not display the report; perhaps, it is showing a message – The report Server cannot process the report. This reference for the shared dataset ‘DashboardDS’ is not valid.

We are getting this message because the report dataset is not pointing to any of the Shared Datasets (SharedDS).

Deploy SSRS Reports using SSRS Report Manager 8

Let us change the dataset properties of the deployed report. To do so, click the down arrow beside the Dashboard report to open the menu items. Please select the Manage option from the menu items.

Deploy SSRS Reports using SSRS Report Manager 9

Once you select the Manage option, the Report manager will navigate you to a new page with the following tabs. Under the properties tab, it will show the Report Created user, created and modified dates, and the Report size.

Deploy SSRS Reports using SSRS Report Manager 10

To change the dataset properties, please navigate yourself to the Shared Datasets tab. As you can see from the below screenshot, it is showing an error that we are explaining till now.

Please click the browse button to select the shared dataset.

Deploy SSRS Reports using SSRS Report Manager 11

Clicking the Browse button will show you the list of available folders and the data sets in the Report Manager.

Deploy SSRS Reports using SSRS Report Manager 12

From the below screenshot you can see, we are selecting the SharedDS present in the Datasets folder

Deploy SSRS Reports using SSRS Report Manager 13

Click the Apply button to apply the changed to the report.

Deploy SSRS Reports using SSRS Report Manager 14

Please click on the report to see the report preview

Deploy SSRS Reports using SSRS Report Manager 15

Now you can see the preview of the SSRS Deployed report using Report Manager.

Deploy SSRS Reports using SSRS Report Manager 16

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.
About | Contact | Privacy Policy