none
How to Add Multiple Sub Total against column values data set in SSRS 2008 Reports..?

    Question

  • Hi All,

    I have Requirement in SSRS 2008 Reports. I have to add Sub Totals rows to display the sum of Balance group by Staff ID. To understand the Requirement please refer below Table Data. The Detailed row is having group by Date, Department, Staff ID.  

    What I want to Achieve is:- For Staff ID 1 i want total of Cash Sales, Cancellations, Balance below space i have left in table similarly for Staff ID 2, 3 and  final total for all Staff ID's in extreme last row....

    Date

    Department

    Staff ID

    Cash Sales

    Cancellations

    Balance

    22/10/2010

    EEE

    1

    $177.90

    $177.92

    -$0.02

    25/10/2010

    EEE

    1

    $177.90

    $177.92

    -$0.02

    11/10/2010

    PPP

    2

    $200.00

    $0.00

    $200.00

    10/09/2010

    workshop

    3

    $90.00

    $90.00

    $0.00

    14/09/2010

    workshop

    3

    $20.00

    $20.00

    $0.00

    11/10/2010

    workshop

    3

    $70.00

    $70.00

    -$0.00

    21/07/2010

    E&C

    3

    $113.00

    $36.00

    $77.00

    19/07/2010

    E&C

    3

    $45.00

    $36.00

    $9.00

    Thanks & Regards,

    Bhushan 

                                      


    Monday, February 25, 2013 6:49 AM

Answers

  • Hi,

    If you group the report on "staff id", you will be able to create subtotals for each staff id in addition to the grand total

    If you create a group within the report, SSRS automatically adds subtotals for the groups. Just make sure the "Show Subtotals" option is selected when you right click on the group row in design view (I'm assuming you are using Report Builder to create this report).

    or you can also try with expressions

     Suppose the group is grouped by the staff id, then, in the group footer, set the expression:

    =sum(Fields!Cash Sales.Value)

    It will create the subtotals for each category.

    After that, in table footer set the same expression:

    =sum(Fields!Cash Sales.Value)

    It will create the grant total for the whole report.

    or for multiple subtotals if u r using ssrs 2008 u can go for the tablix option

    http://blogs.msdn.com/b/robertbruckner/archive/2009/08/10/tablix-multiple-subtotals-are-easy-aka-goodbye-inscope.aspx

    Hope this helps


    Best Regards,
    Silna
    Please feel free to ask if you have any doubts and remember to mark the correct replies as answers.


    Monday, February 25, 2013 9:33 AM

All replies