I have a report which contains a Parent group called 'Area' and a Child group called 'Status'. I want to show the total for each Status depending on the Value of Area. e.g. Area can be 'A' or 'B' , Status can be 'New' or 'Open' or 'Closed' I want to be able to display the Count of each Status in Each Area i.e. Count of Status New in Area A = xxx Count of Status Open in Area B = xxx Anyone know what the expression is for this or how to do the calculation? Thanks.

Hi There Please right click on your detail group and add total after or before and just add the expression count (Status ) Many Thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.

Hi There Please right click on your area group and add total after or before and just add the expression count (Status ) Many Thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.

Thanks Syed, that was great. Maybe you can take a look at my next question :) http://social.technet.microsoft.com/Forums/en/sqlreportingservices/thread/c3e0de03-dbc2-4590-88da-48f0b5a1d197