Solved

SSRS Sub Total Base on Group

Posted on 2014-09-15
4
208 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

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
Hi All, I am here to write a simple article to move SSRS (SQL Server Reporting Services) reports from one server to another. When I have faced the same issue to move reports those were developed by developer on development server and now need to …
This video discusses moving either the default database or any database to a new volume.
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

757 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

19 Experts available now in Live!

Get 1:1 Help Now