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.
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.
Now you will see this window and click on the Next button.
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.
Step 5: Set connection properties
The next step is to set the connection property and click on the OK button.
Step 6: Proceed
Then click on the "Next" button.
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.
Step 8: Query design window
Now in this window, add a table.
Step 9: Select the table
Select the table from your database and add it.
Step 10: Select columnsThe 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.
Now you can see the query string.
Step 11: Select report typeThe next step is to select the report type for displaying the report as a table and matrix.
Step 12: Design the tableThe next step is to design the table, in other words how to display the data in the table.
Step 13: Select table styleThe next step is to select the table style for the table.
Step 14: Select deployment locationThe next step is to select the deployment location to deploy the report to.
Step 15: Completing report wizardThe next step is to provide a name to the service and click
Finish to create the new report.
Step 16
Now you can see the design of the report.
Step 17: Preview of reportNow you can see a preview of the report.
Step 18
If you want to export the report in various types then select type.
Then this window will be opened and save the report.
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.