SSRS : First simple example : How to use Sql Server Reporting Service and How to display report into Windows Application

Create the Report

1. Create new Project of Business Intelligence Projects –> Report Server Project

2. After that, click on Solution Explore, right click on “Shared Data Source” and create Data Source for the report.

3. Once Data Source is created, Again right click and Add the report. This is first time so I can explain using Wizard.

4. During the wizard, give the query so it will create “Data Set” for the report.

5. After finishing the wizard, now we can see the report on screen, click on “Preview”. if table has data , it will display.

 

Now this is the way to create simple report. The challenge is to set the “Reporting Server” and host the report to the server and run the report on the Windows / Web application.

Now I’ll explain how to set the “Reporting Services”

Configure the Reporting Server

1. Open All Programs –> Microsoft SQL 2008 –> Configuration Tool –> Reporting Service Confige  Manager

you will get following screen

2. Above is the Configuration tool to set the “Reporting Services”

If we click on “Web Service URL” tab, we will get the WEB url to access our server.

Now we have set the server. Now we will deploy our report to the server.

Deploy Report into the Reporting Server 

1. Go back to our solution which we have created.

2. Right Click to solution and click on Property. We have to set “TargetServerURL” property to our server. (URL of our reporting server)

2. Right click on solution and click on Deploy tab.

3. check on URL, now we will get one report hosted.

Now we have finished the hosting of report into the server.

Only one part is remaining and that is to display report into the WEB/WINDOWS application.

Display report into the WEB/WINDOWS application

1. Create the Windows Application and dreg MicrosoftReportViewer form the tool box.

2. Right click on the MicrosoftReportViewer and select the Property.

3. We have to set 2 property to get the report which is hosted in our “Reporting Server”.

ReportPath :- Path of the report into the report server

ReportServerURL : The URL of our “reporting Server”

Run the windows application, it will connect the server which we mention in “ReportServerURL “ property and execute the report which we mention in “ReportPath “ property.

I hope , this article may useful for the new person who wants to start SSRS.

Advertisement