title: SSRS column grouping..blank rows issue
body: <p>I am trying to build a SSRS report.</p>
  
  <p>I need a report like this.</p>
  
  <pre><code>TopGroup_Val1
    SecondGroup_Val1
      Deatils{Col1..Col2..Col3.........}
      .........................
    SecondGroup_Val2
      Col1..Col2..Col3.........
      .........................
   TopGroup_Val2
      SecondGroup_Val1
      Col1..Col2..Col3.........
  </code></pre>
  
  <p>For each Top group, there can be multiple second group elements. For each combination of top group and secong group, there can be multiple rows of data.</p>
  
  <p>I tried using colmn grouping. But I got a report like this 
  <img src="https://i.stack.imgur.com/hHjBm.png" alt="report "></p>
  
  <pre><code>   In the above picture, TopGroup is Company. Second group is Dept.
  </code></pre>
  
  <p>Currently DB has one Company with 3 depts and each dept with one employee each. The report has three pages. second page shows second dept of the company with one row of data and two blank rows.
  Design page looks as below.
  <img src="https://i.stack.imgur.com/mYSbv.png" alt="Design page">
  How can I achieve what I am looking for? Why is the data going to multiple pages even if I have only 3 rows of data? Why are blank rows coming? Please share the info.</p>