Solved

SSRS Sub Total Base on Group

Posted on 2014-09-15
4
223 Views
Last Modified: 2014-09-23
I have a report in which I would like to add a sub total to the footer base on "Product Code" for each line.  Not sure how to go about doing this, but I had attached what I want.  Is this possible?

Item highlighted in Yellow and Green is what I am after.
Example
0
Comment
Question by:holemania
  • 2
  • 2
4 Comments
 
LVL 3

Expert Comment

by:prequel_server
ID: 40324444
yes, you would create a row group on the Product code and then you can put in the sub totals line in your table.

Another way is to insert a separate sub total table that groups by the product code
0
 

Author Comment

by:holemania
ID: 40325544
So would I just create 2 footer in my table, and then group it on product code?

Example:

Example
0
 
LVL 3

Accepted Solution

by:
prequel_server earned 500 total points
ID: 40325552
a footer in an SSRS report a section of the report that would show at the bottom of each page. This is probably not what you want.

It would be easier for me to help you if you show screenshots of your working report in SSRS designer/data tools, not excel. Start by creating the table without the subtotals.
0
 

Author Closing Comment

by:holemania
ID: 40339906
I was able to resolve the issue by installing SSRS 2008, since the grouping there was a lot easier.
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Suggested Solutions

Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
How to use Variables  and Custom code in SSRS report and Assembly reference to use compile shared code in SSRS. Its big question for all who are working with SSRS. It is easy to create assembly and refer in SSRS report, still there are some steps…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

860 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