title: SSRS: Trouble understanding Grouping in Report
body: <p>I have a relatively simple report that is 'working'.
  It has a main Group based on an Expression - with one sort in the Group - and then another 'Group' named 'Details' under that in the Row Groups pane.</p>
  
  <p>The Main Group is repeating itself for no reason that I can figure.
  I expect that if there is a Group called 'A' - then all the Detail rows in that Group will display till the next Group - right?</p>
  
  <p>Like this:</p>
  
  <pre><code>A
  Bob      1   Texas
  Jane     2   California
  Devin    4   New York
  
  B
  Jack     3   Texas
  Mary     6   Maine
  Peter    5   Michigan
  
  C
  . . .
  </code></pre>
  
  <p>Instead, the report is doing something like this:</p>
  
  <pre><code>A
  Bob      1   Texas
  Jane     2   California
  
  A
  Devin    4   New York
  
  B
  Jack     3   Texas
  
  B
  Mary     6   Maine
  Peter    5   Michigan
  
  C
  . . .
  </code></pre>
  
  <p>If I delete the Details Group I lose some data &amp; the report goes from 5 pages [57 detail recs] to about two pages.
  If I delete the Main Group as well - I go down to just one record in the entire report.</p>
  
  <p>I need to keep all the data that is on the report - but have it Group correctly by the Main Group [without repeats of the Group Header] and then within each group - sort by a couple of different fields.</p>
  
  <p>Any idea how I should go about Troubleshooting the issue?</p>
  
  <p>Thanks!!</p>