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

SSRS 2005 Additional Group Sum at bottom

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?
1 Solution
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?


rwheeler23Author Commented:
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.
Alpesh PatelAssistant ConsultantCommented:
Please select the Group in Row group and add Group Total at Bottom.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

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

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