Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

SSRS Sub Total Base on Group

Posted on 2014-09-15
4
Medium Priority
?
249 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
[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
  • 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 2000 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

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

Question has a verified solution.

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

INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…

730 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