Solved

SSRS 2005 Subtotal on matrix returning first record

Posted on 2014-07-30
4
271 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 65

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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

Suggested Solutions

Written by Valentino Vranken. Introduction: In a previous article (http://www.experts-exchange.com/articles/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Reporting-On-Data-From-Stored-Procedures-part-1.html) I announced that I would writ…
Introduction: This article is aimed at report developers who are used to developing reports using relational databases and have gotten a first-time assignment to develop reports on OLAP cubes. It demonstrates how to build a report using SQL Ser…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

831 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