title: SSRS How to display only one row in groups column
body: <p>I'm making a RS but I can't find on how to display only one cell for the group column.</p>
  
  <p>The upper report is what I'm making and I want my report to be look like the bottom report</p>
  
  <p><a href="https://i.stack.imgur.com/kIjgj.png" rel="nofollow noreferrer">![The upper report is what I'm making and I want my report to be look like the 
  bottom report]<a href="https://i.stack.imgur.com/kIjgj.png" rel="nofollow noreferrer">1</a></a></p>
  
  <p>Also is there a way to edit the report again. I mean to display the Report Wizard again and assign if either the column is gonna be <code>page,groups or details</code></p>
  
  <p>Edit 1:</p>
  
  <p>I tried deleting the columns and adding group manually. But the output is wrong
  The column <code>[Agent Name]</code> is the only drillable column, you can refer to the image.</p>
  
  <p><a href="https://i.stack.imgur.com/5shQQ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/5shQQ.png" alt="enter image description here"></a></p>