Friday, July 22, 2016

SSRS - Report Deployment from Report Manager

Report deployment comes after developing the report in the BIDS/ Report Builder/ SQL Data Tools without any issue. To visualize the report to the end users/business users, we need to deploy the report on the report server. So, there are lots of techniques to deploy the report on the report server. 

In this section, we will learn report deployment with the help of Report Manager.
How to open Report Manager?
For the first time, to open the Report Manager, we need to go programs list and choose SQL Server 2014 Reporting Services Configuration Manager from Microsoft SQL Server 2014 as given below-

It will launch SQL Server 2014 Reporting Services Configuration Manager and by default it will open with Reporting Services Configuration Connection window which facilitate you to choose Server name and Report Server Instance as given below:

Note: Please ensure that your reporting services should be started if not then you should restart it.
Click on the connect button to make a connection to your Report Server Instance and click on Web Services URL to launch your Web Services window as given below-

Now, we are able to view Report Server on the web page as given below-

In the configuration window, click on the Report Manager URL to launch the Report Manager window as given below-

Wow, we get the Report Manager on the web page as given below-
Great!! We have the report server and report manager on the web page. In the report manager web page, we should have some directories such as the Reports, DataSources and DataSets etc. Click on the new folder and create those one by one as given below-

Now, we have to set a data connection from the database. So, go in the DataSources folder and click on the new Data Source and set your database connection as given below-
After set your connection string, you should test it by using Test Connection button on the screen and if it shows successful message on the screen then click on OK button which will look like as given below-
Now, we have created the data connection. It's time to load your developed report on the report server. Go back to your Reports directory and click on the upload file as given below-
In Upload window, click on the Browse button to choose your report to deploy as given below-

After clicking on the Browse button, you can choose your SSRS report from your development environment as given below- 
After clicking on the Open button on the above window and you are able to view your report on the report manager as given below- 
Now, click on OK button to view your uploaded report in Report directory as given below- 
Choose Manage to set the connection as given below-

 Now, you are in the report manage section and there is no data source connection to the report as given below in red color-

To set the data connection, click on Browse button to set the data connection and choose your data connection from the DataSources directory as given below-

After set the Data Source to the report, you must click the Apply button to applicable the data source to the report as given below-
Now, you did everything with the report deployment process and your report is ready for the execution. You can execute your report by click on the report name as given below: 
After clicking on the report, it will execute and render the report on the web page as given below-
Now, you can execute your report from the report server and after creating the directories and deployment of the report.
Watch demo-

1 comment:

  1. Building a user-friendly GUI for Report Builder
    I have a specific reporting requirement and would be very grateful for comments on the best way achieve it.

    Schools currently produce a large number of reports in Excel for internal management purposes — these tend to be unique to each school — which is the rationale as to why I am looking to build a friendly application — they also require repetitive wrangling every time an updated report is required. The reports contain a combination of tables, visuals, and text.

    The data for the reports will exist in an Azure SQL DB. A R package has been developed to

    At present I am seeking advice about whether it is possible to develop an easy-to-use interface for MS Report Builder for schools to build and distribute reports based on a schedule specified by the user — these reports will be produced as pdfs and as MS Powerpoint and Word documents.

    A number of specific Templates will be designed for schools to adapt to their requirements — Is it feasible to consider developing an interface for report Builder/SSRS that is useable by school staff who have no technical knowledge???

    Is there a better way to tackle this problem??

    I’ve tried PowerBI, but it is too complex for most staff in schools, and last time I looked at it, there was very limited ways to reconfigure the UI to make it approachable for non-technical users

    The reports are for an Educational Analytics application that is being developed in R — brief articles on the application are available at the links below.


Popular Posts

Get Sponsored by Big Brands