SSRS Sum totals of each machine

Posted on 2014-08-21
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.


Question by:SQLSearcher
    LVL 14

    Expert Comment

    by:Vikas Garg

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

    Author Comment

    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.


    LVL 14

    Accepted Solution


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

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

    Author Closing Comment

    Thank you for your help.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    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

    In this short article I will be talking about two functions in the SQL Server Reporting Services (SSRS) function stack.  Those functions are IIF() and Switch().  And I'll be showing you how easy it is to add an Else part to the Switch function. T…
    A recent question popped up and the discussion heated up regarding updating a COMMENTS (TXT) field in a table using SSRS. (htt…
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    746 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

    15 Experts available now in Live!

    Get 1:1 Help Now