Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

SSRS 2005 Subtotal on matrix returning first record

Posted on 2014-07-30
4
Medium Priority
?
285 Views
Last Modified: 2014-08-04
Hi Experts

I have a subtotal on matrix, the matrix has three groups (County, City, Town), with the last two groups a drill down based upon the first group. My subtotal is on the 2nd group (City)  - I would expect it to to subtotal all the results for city based upon the column values, but it's just returning the first record's value, any ideas>
0
Comment
Question by:MrDavidThorn
  • 2
4 Comments
 
LVL 66

Expert Comment

by:Jim Horn
ID: 40228897
Give us a screen shot of your SSRS report in design view, and make sure to include the grey-box row headers on the left side, and the row/groups on the bottom.
0
 
LVL 21

Expert Comment

by:Alpesh Patel
ID: 40229022
You have to add Group total for all of your groups. So, It will give you total for all.

I think you added group total row outside the group.
0
 

Accepted Solution

by:
MrDavidThorn earned 0 total points
ID: 40229108
sorry the post was a little vague, Have resolved the problem, it was because It wasn't using the "Sum" function in the output field. Doh!
0
 

Author Closing Comment

by:MrDavidThorn
ID: 40238545
posted vague question and couldnt provide data beacuse of secutity
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

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

In this short article I will be talking about two functions in the SQL Server Reporting Services (SSRS) function stack.  Those functions are IIF() and Switch().  And I'll be showing you how easy it is to add an Else part to the Switch function. T…
Introduction In the following article I’ll be discussing and demonstrating several different ways of how images can be put on a report. I’m using SQL Server Reporting Services 2008 R2 CTP, more precisely version 10.50.1352.12, but the methods ex…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?

564 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