This article is a part 9 of series of article on SQL Server Reporting Services. This will help you to get started with SQL Server Reporting Services (SSRS).
- Getting Started with SSRS – Part 1 – SQL Server Reporting Services Overview and Installing in Windows Server 2008
- Getting Started with SSRS – Part 2 – Designing a report using Report Wizard
- Getting Started with SSRS – Part 3 – Designing a report using Report Designer [more]
- Getting Started with SSRS – Part 4 – Configuring SQL Server Reporting Services in Windows Server 2008
- Getting Started with SSRS – Part 5 – Deploying a report to the Server
- Getting Started with SSRS – Part 6 – Creating Deleting and Moving a folder in SSRS Server
- Getting Started with SSRS – Part 7 – User Roles and Permissions in SSRS Server
- Getting Started with SSRS – Part 8 – Show SSRS Report in ASP.NET Web Page
- Getting Started with SSRS – Part 9 – Creating Matrix Report with inbuilt styles in SSRS
- Getting Started with SSRS – Part 10 – Creating a Report with Charts and Gauges
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.