Solved

SSRS 2005 Additional Group Sum at bottom

Posted on 2011-09-13
3
307 Views
Last Modified: 2012-05-12
I have an SSRS 2005 report that list transactions per job per company. So let's say I have jobs 1000,1001 and 1002 and companies A,B and C. Right now the report will list all transactions for job 1000 and then if anyone from companies A,B or C worked on the job it will do subtotal per job per company. Now they are asking for an additional footer summary at the bottom that will list the subtotals per company. So they want a total for company A, company B and company C. How do I set up the report so I can get these totals at the bottom that reflect the total for each company just before the totals for all companies for all jobs?
0
Comment
Question by:rwheeler23
[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
3 Comments
 
LVL 29

Accepted Solution

by:
sammySeltzer earned 500 total points
ID: 36538393
Here, the checked (Accepted Answer) is the answer to your question, both how to do the summary and sticking it on the footer.

Is the issue about coding the summary or laying them out on the footer?

http://stackoverflow.com/questions/636573/create-sum-of-calculated-rows-in-microsoft-reporting-services

0
 

Author Comment

by:rwheeler23
ID: 36545913
I think the anser lies is creating a second dataset for the report. The secind data set will be grouped by company and will simply be the sums per company. I will giver this a try.
0
 
LVL 21

Expert Comment

by:Alpesh Patel
ID: 36547813
Please select the Group in Row group and add Group Total at Bottom.
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Steps to solve SSRS SQL 2008 R2 User Access Control (UAC) Permission Error With the introduction of SQL Server 2008 R2 and Vista (Windows 7 as well) came new enhanced security features. One of the features included was User Access Control (UAC) t…
A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…

734 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