locked
Showing Total and grand total in rdlc RRS feed

  • Question

  • User293174396 posted

    Hi All,

    I have RDLC report. My Detail report is bringing the data group by the criteria selected. For example I select the criteria Age. so all data with age 11 comes up, then all data with age 12 comes up.Till here I am able to do with stored proc but now what I want is, Say there are 4 rows with age 11,  I want total at the bottom of row to show 4. Then say there are 6 rows with age 12 , At the bottom of 12 age show Total 6. Then Grand total = 10 (4+6 ). How do I achieve this. Any Idea..I want something like (This one sorted by Contact Relationship)

    Child's Name Age Contact Name Contact Relationship    Agency Date Received
    Phil Drummond 16 Paul Berryman Family Member DCF 5/22/2008
    Lawrence Higgins 1 Fredrick Pleasant Family Member DPH 7/12/2008
    Paul Cote 9 Kittie Hawkins Family Member DCF 7/14/2008
    Devlin Harris 11 Cheri Glasser Family Member DYS 9/19/2008
           
    Total:  4
    Robert Sherman 12 Ron Smith Social Worker DYS 5/3/2008
    Brian Montgomery 5 Deice Drumgold Social Worker DYS 6/30/2008
    Peter Zimmerman 16 Dale Everson Social Worker DCF 8/21/2008
    Sean Johnson 17 Glen Mondale Social Worker DTA 9/17/2008
           
    Total:  4
    Roger Donoghue 17 Jesse Venture Unknown DYS 6/30/2008
    Kevin Draper 14 Gary Forester Unknown DYS 8/27/2008
           
    Total:  2
           
    Grand Total:  10

    Monday, January 5, 2009 4:28 PM

Answers

  • User161497555 posted

    Hello,

     Add a Group Footer. And in that write expression as =CountRows("GroupName").

    Add a Table Footer and in that write expression as = CountRows("TableName")

     

    Hope this helps

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, January 6, 2009 12:39 AM

All replies

  • User161497555 posted

    Hello,

     Add a Group Footer. And in that write expression as =CountRows("GroupName").

    Add a Table Footer and in that write expression as = CountRows("TableName")

     

    Hope this helps

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, January 6, 2009 12:39 AM
  • User293174396 posted

    Thanks..That worked.

     

    -Anu

    Tuesday, January 6, 2009 9:51 AM
  • User-1596001782 posted

    Hi Shilpa,

    I have a master detail report in rdlc.

    The list report has a table data region. On the list report I am displaying the customer info and in the table data region I am displaing the details. I have grouped the list report on customer number. I would like to calculate the grand total of all the customers.

    So, if I add a group footer on my table data region it will give me the grand total only for that customer because list report is grouped on customer no.

    I checked to see if the list report has a group footer and looks like the list report does not come with a group footer.

    Do you know of a way how to display the grand total of all the customers in this scenario?

    Thanks much

    Madhu 

    Monday, September 13, 2010 3:45 PM
  • User334127605 posted

    thanks. it worked well. i have another question here.

     

    i want to limit the number of records to 20 for a page. Also, if the 20th record is in a middle of a group, i want to start that goup on next page. is it possible?

     

    thanks

    Tuesday, May 24, 2011 6:47 AM