• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 898
  • Last Modified:

SSRS Subtotal matrix

Hi All,

I have a matrix that I'm trying to subtotal and can't figure out how to do this.  Essentialy across the top I have a variety of projects and across the left side is a variety of categories.

For example:

                ProjectA                ProjB                ProjC                           Status Totals (NEED)
                  #       $               #      $                #     $                         #                   $
Live         200    1.5M         5       50k             1     1M                      206         2.5M + 50k

OnHold      10    250k         1       10k             5     500k                   16              760K

Project Totals (NEED)
               210    1.75M         6       60K         6       1.5M                   222            3.31M


How do I get the project totals (to subtotal vertically)  and Status totals (subtotal horizontally) into the matrix for both # and $?

Thanks.  
0
Kyle Abrahams
Asked:
Kyle Abrahams
  • 2
  • 2
1 Solution
 
Nico BontenbalCommented:
What version of SSRS are you using.
If it is 2005 you can right click the project header and choose subtotal, and right click the stutus header and click subtotal.
If it is 2008 you can right click the Row- and Column Groups at the bottom of your screen and select Add Total|After.
0
 
Kyle AbrahamsSenior .Net DeveloperAuthor Commented:
Thanks for the response.  I actually had to add sum(Fields!Count.Value) instead of just Fields!Count.Value in my inner matrix.  Will give you the points if you can tell me why.
0
 
Nico BontenbalCommented:
The matrix does grouping as well. So your result could come in like this:
ProjectA, Live, 150, 1000000
ProjectA, Live, 50, 500000
ProjectB, Live, 3, 40000
ProjectB, Live, 2, 10000
etc.

And your matrix would still have the values as in your example. So SSRS wants to know what do with the multiple values. It doesn't know in advance that you only supply unique values, so it wants an aggregate (for example sum) function.
0
 
Kyle AbrahamsSenior .Net DeveloperAuthor Commented:
Thanks.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now