Getting Started with Adobe After Effects - Part 6: Motion Blur


Upload Image Close it
Select File

This tutorial will help you to get started with SQL Server Reporting Services (SSRS)

Getting Started with SSRS (SQL Server Reporting Services)

Getting Started with SSRS - Part 9 - Creating Matrix Report with inbuilt styles in SSRS

Dec 20 2011 12:00AM by Karthikeyan Anbarasan   

Introduction

In this article we are going to see how to create a Matric Report with the help of the Report Wizard and Report Designer. In our earlier articles, we have covered how to design and deploy the report to the server with the option to design using the wizard and also with the report designer. However, in this article we are going to see how to make a matrix type report, since most of the business reports are developed based on the pivot format to analyze. Now, let us see how to design the report and get the report in a much formatted matrix format.

Steps

Open Microsoft SQL Server Business Intelligence Development Studio and select the new Report Server Project Wizard as shown in the screen below.

Creating a new Report Server Wizard Project

As the Report Wizard opens, click Next to proceed further as shown in the screen below.

Report Wizard Launched

Next step is to select the data source. In this example we are going to use the Employee table as shown in the screen below. Click on Edit button to open the options to select the database and table.

Selecting the data source to access the data

Now select the database by providing valid credentials and then select the table as shown in the screen below.

Selecting the database to access the data

Now click on OK to complete the connection properties and proceed to next step by clicking on Next button. This will open the query designer window. Using this window we can select the query based on the requirement. To design the query click on Query Builder button as shown in the screen below.

Selecting the Query Builder

Now write the query to fetch the desired data. Once verified that the data is correct, click on OK to complete this task and click Next to proceed to the next window as shown in the screen below.

Customizing the Query to fetch the data

Now we need to select the report type. Since in this article we are going to concentrate on the Matrix type report, select Matrix and click on Next button to proceed further as shown in the screen below.

Selecting the Matrix Report Type

Now select the columns based on the requirement such as which columns should be applicable to be a column and in rows along with the details as shown in the screen below.

Selecting the Columns and Rows

Now click on Next button to proceed further and select the design for the report from the list of predefined templates as shown in the screen below.

Selecting the Matrix Style

Now click on Finish button to complete the design. This will close the wizard and the report designer opens as shown in the screen below.

Report designer view of the customized Matrix Report

Now build and execute the report by clicking on the Run button or F5 functional key button from the keyboard. Once the building is completed, we can see the Matrix report as shown in the screen below.

Matrix Report Output

Conclusion

So in this article we have seen how to make use of the Matrix template to design and use the report in a much analytical format for easy analysis.

Table Script: Create table EmployeeInfo ( EmpIDint, EmpFnameVarchar(100), EmpLnameVarchar(100), EmpStateVarchar(100), EmpSalary money )


Karthikeyan Anbarasan
52 · 4% · 1176
5 Readers Liked this
Khyati Patel Liked this on 12/20/2011 1:11:00 AM
Profile · Facebook · Twitter
Jacob Sebastian Liked this on 12/20/2011 1:31:00 AM
Profile · Blog · Facebook · Twitter
Dinesh Sodani Liked this on 12/20/2011 8:02:00 AM
Profile · Blog · Facebook · Twitter
Guru Samy Liked this on 3/23/2012 3:25:00 AM
Profile · Blog
Neha Mewara Liked this on 10/15/2012 8:18:00 AM
Profile
5
Liked



Submit

Your Comment


Sign Up or Login to post a comment.

"Getting Started with SSRS - Part 9 - Creating Matrix Report with inbuilt styles in SSRS" rated 5 out of 5 by 5 readers
Getting Started with SSRS - Part 9 - Creating Matrix Report with inbuilt styles in SSRS , 5.0 out of 5 based on 5 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]