# Showing Total and grand total in rdlc

• ### 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

• 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 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 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

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