Solved

SSRS Sub Total Base on Group

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

A recent question popped up and the discussion heated up regarding updating a COMMENTS (TXT) field in a table using SSRS. http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_27475269.html?cid=1572#a37227028 (htt…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

803 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