title: Controlling row group in ssrs
body: <p>I am converting crystal report to SSRS and i need to group by a variable. I grouped by the variable and report looked fine except for one thing. Consider the following which was grouped by Section (row grouping)</p>
  
  <pre><code>+---------+------+----------+
  | Section | Name |  Number  |
  +---------+------+----------+
  |       1 | AAA  | 111-1111 |
  |         | BBB  | 222-2222 |
  |         | CCC  | 333-3333 |
  |       2 | DDD  | 444-4444 |
  |         | EEE  | 555-5555 |
  +---------+------+----------+
  </code></pre>
  
  <p>The only thing i am trying to achieve is to have the section number as a heading instead of the column and it is not the column group i am talking about. So the report i am trying to achieve is to move the section as the heading to each group and the report would look like</p>
  
  <pre><code>+-----------+----------+
  | Section   | 1        |
  |Name       | Number   |
  | AAA       | 111-1111 |
  | BBB       | 222-2222 |
  | CCC       | 333-3333 |
  | Section 2 |          |
  | Name      | Number   |
  | DDD       | 444-4444 |
  | EEE       | 555-5555 |
  +-----------+----------+
  </code></pre>
  
  <p>I have been trying to make this change but end up changing the structure of the report. when i googled about grouping it gave me column level and row level grouping which i understand to some extent but could not figure out changing the Section so any help related to this will be very helpful.Any links are also welcome to get grouping like this. And i am not grouping in the query, so the query is straightforward select statement.</p>