Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

SQL Report Builder - Matrix Report

Posted on 2009-04-13
2
Medium Priority
?
561 Views
Last Modified: 2012-05-06
Hello,

I'm new to SQL Server Reporting Services. I have created a Report model and using the Report Builder, I'm trying to create a Matrix report from a Report Model. The matrix report I have created looks like below.

                    Diagnosis
------------------------------------------------------------------------
Age             Grade1        Grade2          Grade3          Total
------------------------------------------------------------------------
29                  1                                                               1
30                                        1                                         1
31                  1                                                               1
32                                                             1                    1

Total              2                     1                  1                     4


I have added the field 'Age' as the row group and 'Diagnosis' as the column group. Age has values 29, 30, 31, 32... and Diagnosis has values Grade1, Grade2 Grade3.....In the report builder, I would like to group based on the row values(grouping on 'Age') and I would like my report to be displayed like below. Any help is grately appreciated. Many Thanks.


                    Diagnosis
------------------------------------------------------------------------
Age             Grade1        Grade2          Grade3          Total
------------------------------------------------------------------------
0-30                  1                    1                                        2
31-40                1                                        1                    2
40-50                                                                                

Total                  2                    1                  1                    4
0
Comment
Question by:pnadakuditi
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 12

Assisted Solution

by:udaya kumar laligondla
udaya kumar laligondla earned 2000 total points
ID: 24131340
create a table which will have the age range values and the grade values in SQL. use the table in the reporting server.
you can not create a range in Reporting server.
0
 

Accepted Solution

by:
pnadakuditi earned 0 total points
ID: 24132397
Hi,

I was able to find a solution for this.. I basically edited the formula for the row group 'Age' using a switch statement to look like this...

SWITCH(AND(Age >=0, Age <=30), "0-30", AND (Age >=31, Age <=40), "31-40", AND(Age >=41, Age<=50), "41-50")

Thanks for your time.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hi, I have heard from my friends that it’s not possible to create Label Printing report using SSRS. I am amazed after hearing this words not possible in SSRS. I googled lot and found that it is possible to some of people know about the Report Bui…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This course is ideal for IT System Administrators working with VMware vSphere and its associated products in their company infrastructure. This course teaches you how to install and maintain this virtualization technology to store data, prevent vuln…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question