Create Report Services in Business Intelligence Development Studio

This article describes how to create SQL Reporting Services in Business Intelligence Development Studio. We create the same reporting services in Excel and QlikView also but cannot deploy these reporting services.

In Business Intelligence Development Studio, there are so many reporting services connection wizard. SQL Server Reporting Services is very useful. After creating the report we can import this report to any file, like Excel, PDF, Word and so on.

So to overcome this problem, we create the same reporting services in Business Intelligence Development Studio.

What is Business Intelligence Development Studio?

In my previous article I provided an Introduction of Business Intelligence Development Studio and how to install

Creation of SQL report service in Business Intelligence Development Studio

So let's start with the procedure.

Step 1: Create Project

Open Visual Studio and select "File" -> "New" -> "Project...".

The first and major step is to open Visual Studio and select a new project.

visual studio

Step 2: Select report service type

The next step is to select the report service type in the business intelligence project templates then click on the OK button.

report service

Now you will see this window and click on the Next button.

wizard

Step 3: Select data source

Now the next step is to select a data source from which to obtain data for this report and also select data source type.

Step 4: Select edit button

The next step is to select the edit button for setting the connection properties.

edit

Step 5: Set connection properties

The next step is to set the connection property and click on the OK button.

connection

Step 6: Proceed

Then click on the "Next" button.

next

Step 7: Design the query


The next step is to specify a query to execute to get the data for the report. In this window either you define a query directly or specify a query string.

query

Step 8: Query design window


Now in this window, add a table.

 

add

Step 9: Select the table
 
Select the table from your database and add it.

table

Step 10: Select columns


The next step is to select the column from the table that we want to show as a table in the report and click on the "OK" button.

column

Now you can see the query string.

string

Step 11: Select report type

The next step is to select the report type for displaying the report as a table and matrix.

matrix

Step 12: Design the table


The next step is to design the table, in other words how to display the data in the table.

design

Step 13: Select table style

The next step is to select the table style for the table.

style

Step 14: Select deployment location

The next step is to select the deployment location to deploy the report to.

deploy

Step 15: Completing report wizard

The next step is to provide a name to the service and click Finish to create the new report.

finish

Step 16
 
Now you can see the design of the report.

design1

Step 17: Preview of report


Now you can see a preview of the report.

preview

Step 18
 
If you want to export the report in various types then select type.

export

Then this window will be opened and save the report.

save

Summary

This article described how to create SQL Server Reporting Services using the Business Intelligence Development Studio. This article defines a very simple way to create a report. I hope this is useful for you.