title: RowNumber for group in SSRS 2005
body: <p>I have a table in a SSRS report that is displaying only a group, not the table details.  I want to find out the row number for the items that are being displayed so that I can use color banding.  I tried using "Rowcount(Nothing)", but instead I get the row number of the detail table.  </p>
  
  <p>My underlying data is something like </p>
  
  <pre><code>ROwId   Team      Fan
  
  1       Yankees   John
  2       Yankees   Russ
  3       Red Socks Mark
  4       Red Socks Mary
  ...         
  8       Orioles   Elliot
  ...         
  29      Dodgers   Jim
  ...
  43      Giants    Harry 
  </code></pre>
  
  <p>My table showing only the groups looks like this:</p>
  
  <pre><code>ROwId   Team
  2       Yankees
  3       Red Socks   
  8       Orioles
  29      Dodgers 
  43      Giants  
  </code></pre>
  
  <p>I want it to look like</p>
  
  <pre><code>ROwId   Team
  1       Yankees
  2       Red Socks   
  3       Orioles
  4       Dodgers 
  5       Giants  
  </code></pre>