[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

SSRS Sum totals of each machine

Posted on 2014-08-21
4
Medium Priority
?
225 Views
Last Modified: 2014-08-22
Hello Experts Exchange
I have a SSRS report that has totals for all the machines names data all together, I want a total for each machine.

Is it possible to get a total for each machine?

I have attached my current report.

Regards

SQLSearcher
OEE-Report-Totals2.rdl
0
Comment
Question by:SQLSearcher
  • 2
  • 2
4 Comments
 
LVL 15

Expert Comment

by:Vikas Garg
ID: 40275816
Hi,

You need to add row group so that the total for each group will be shown in the group.
0
 

Author Comment

by:SQLSearcher
ID: 40275975
Hello Vikas
I have tried your solution but I can not get a total for each machine just a total for all of the machines together.

So I still need some help to get a total for each machine.

Regards

SQLSearcher
0
 
LVL 15

Accepted Solution

by:
Vikas Garg earned 2000 total points
ID: 40275992
Hi,

If you have created Row Group then insert one blank row and add the expression

=SUM(Fields!FieldName.Value, "GroupName")
0
 

Author Closing Comment

by:SQLSearcher
ID: 40278541
Thank you for your help.
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

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

Written by Valentino Vranken. Introduction: The first step of creating a SQL Server Reporting Services (SSRS) report involves setting up a connection to the data source and programming a dataset to retrieve data from that data source.  The data…
Introduction Earlier I wrote an article about the new lookup functions (http://www.experts-exchange.com/A_3433.html) that ship with SQL Server 2008 R2.  In this article I’m going to show you another new feature of SSRS 2008 R2, this time in the vis…
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…
Suggested Courses

872 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