?
Solved

SQL Report Builder - Matrix Report

Posted on 2009-04-13
2
Medium Priority
?
564 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
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: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

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

Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
Introduction Earlier I wrote an article about the new lookup functions (http://www.experts-exchange.com/A_3433.html) that ship with SQL Server 2008 R2.  In this article I’m going to show you another new feature of SSRS 2008 R2, this time in the vis…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…

830 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