title: Total Row Count for Grouped Values in SSRS 2008
body: <p>I have a report that displays names of all accounts and activities performed under each of them. </p>
  
  <p>AccountName: ABC Corp
  Activity: Installation</p>
  
  <p>I want to group the AccountName and get the total number of Activities performed for each account.</p>
  
  <p>ABC Corp: 1</p>
  
  <p>How can I accomplish this in SSRS 2008? I am able to group the AccountName but I need a way to convert the Activity column to int so I can get the total.</p>
  
  <p>Help appreciated!</p>