title: How do I add a footer row displaying row count to a matrix in SQL Reporting Services?
body: <p>I have a matrix on my report that is displaying a data set that contains one row for each person in a company:</p>
  
  <blockquote>
  <pre><code>Company     Position   Name
  -------     --------   -----
  Acme Inc.   CEO        Bob
  Acme Inc.   COO        Alice
  Beta Corp.  CEO        Frank
  Beta Corp.  CTO        Rob
  Beta Corp.  COO        Bill
  (etc)
  </code></pre>
  </blockquote>
  
  <p>The matrix has a column grouping for Position, and a row grouping for Company. The final report looks like this:</p>
  
  <blockquote>
  <pre><code>  Company        CEO      CTO     COO
  -----------------------------------------
  | Acme Inc.   |  Bob              Alice |
  | Beta Corp   |  Frank    Rob     Bill  |
  | Foo, Inc.   |           Paul          |
  | Bar Corp    |  Mary                   |
  </code></pre>
  </blockquote>
  
  <p>I want to add a footer row at the bottom of the matrix that counts how many CEOs, CTOs, etc there are.</p>
  
  <blockquote>
  <pre><code>-------------------------------------
  People in role | 3         2        2
  </code></pre>
  </blockquote>
  
  <p>How do I do this in SQL Reporting Services 2005? Unfortunately, Matrix controls in SSRS 2005 don't seem so support footer rows like Table controls do. I think the solution will involve some trickery involving row groups, but I don't know enough about the Matrix control to figure it out.</p>