Solved

SSRS 2005 Additional Group Sum at bottom

Posted on 2011-09-13
3
288 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
3 Comments
 
LVL 28

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SSRS parameters, tablix filter question 17 45
SQL Server 2014 - Report Server - Stored Procs 8 56
how to calculate Quintiles in ssrs 3 40
SSRS String Manipulation 6 40
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…
Have you ever had to extract data from a Microsoft SQL Server database and export it to an Excel file, but did not want to use a DTS package? The concept in this article is not new, but it is the answer and will also work on 64-bit SQL boxes.   …
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

912 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now