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-

10 comments:

  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.

    https://www.linkedin.com/pulse/next-generation-educational-analytics-peter-cuttance?published=t

    https://www.linkedin.com/pulse/next-generation-educational-analytics-part-1-peter-cuttance?published=t

    https://www.linkedin.com/pulse/next-generation-educational-analytics-part-2-proposed-peter-cuttance?published=t

    https://www.linkedin.com/pulse/next-generation-educational-analytics-part-3-asking-data-cuttance?published=t

    ReplyDelete
  2. What a trader requires is a triumphant procedure. To make itFree Articles, information examination assumes urgent job to give the clients a chance to convince for acquiring. data science course in pune

    ReplyDelete
  3. I was blown out after viewing the article which you have shared over here. So I just wanted to express my opinion on Data Analytics, as this is best trending medium to promote or to circulate the updates, happenings, knowledge sharing.. Aspirants & professionals are keeping a close eye on Data analytics course in Mumbai to equip it as their primary skill.

    ReplyDelete
  4. Such a very useful article. Very interesting to read this article.I would like to thank you for the efforts you had made for writing this awesome article. I would like to state about something which creates curiosity in knowing more about it. It is a part of our daily routine life which we usually don`t notice in all the things which turns the dreams in to real experiences. Back from the ages, we have been growing and world is evolving at a pace lying on the shoulder of technology. "data science course
    "
    will be a great piece added to the term technology. Cheer for more ideas & innovation which are part of evolution.

    ReplyDelete
  5. I feel very grateful that I read this. It is very helpful and very informative and I really learned a lot from it.
    pmp certification in bangalore

    ReplyDelete
  6. Such a very useful article. I have learn some new information.thanks for sharing.
    data scientist course in mumbai

    ReplyDelete
  7. You completed certain reliable points there. I did a search on the subject and found nearly all persons will agree with your blog.
    Data science course in mumbai

    ReplyDelete
  8. Such a very useful Blog. Very interesting to read this article. I have learn some new information.thanks for sharing. know more about

    ReplyDelete
  9. Such a very useful Blog. Very interesting to read this article. I have learn some new information.thanks for sharing. know more about

    ReplyDelete

Popular Posts

Get Sponsored by Big Brands