title: How to group this SSRS report?
body: <p>I have an SSRS report. It looks like this:</p>
  
  <p><a href="https://i.stack.imgur.com/DXhl9.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/DXhl9.png" alt="enter image description here"></a></p>
  
  <p>Its definition looks like this:</p>
  
  <p><a href="https://i.stack.imgur.com/ZNRk9.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ZNRk9.png" alt="enter image description here"></a></p>
  
  <p>As you can see it's just a bunch of numbers in different columns A to G. Those numbers were grouped by A then B then C. For each row in the report, column D,E,F,G are my detailed data. The problem is, for each group (I mean grouped by A,B,C), I need all rows for the D&amp;E column. For F&amp;G column, I don't want the duplicates. So for example, for the very first group, we can see for column F&amp;G there are duplicates, the data <strong>20, 30</strong> appeared twice. Essentially what I want is something like this (note the duplicates were removed compared to the aforementioned report result):</p>
  
  <p><a href="https://i.stack.imgur.com/NOv9r.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/NOv9r.png" alt="enter image description here"></a></p>
  
  <p>Take a look at the data with yellow background, that's the part where I want duplicates removed. I don't know how to implement this in SSRS. Hope someone can point me to the right direction. You can download the report I'm testing at <a href="https://www.dropbox.com/s/qxvloaeuj31m0mj/Report1.rdl?dl=0" rel="nofollow noreferrer">https://www.dropbox.com/s/qxvloaeuj31m0mj/Report1.rdl?dl=1</a>. This simple report was created to isolate the problem I met in a more complex report. I can't change the logic and have to find a way to implement this. Thanks in advance.</p>