?
Solved

SQL Report Builder - Matrix Report

Posted on 2009-04-13
2
Medium Priority
?
554 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

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

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

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 article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

764 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