title: Blank out duplicate column values in SQL Reporting Services
body: <p>This has to be stupid easy to do, but I'm not seeing it.</p>
  
  <p>I have a SQL Reporting Services (SQL 1008 R2) report.</p>
  
  <p>I'm using a tablix to basically show:</p>
  
  <pre><code>COL 1 |  COL 2 |  COL 3 |  COL 4
  ----------------------------------
  100   |  100   |  100   |  Item 1
  100   |  100   |  101   |  Item 2
  100   |  100   |  102   |  Item 3
  100   |  110   |  110   |  Item 4
  100   |  110   |  110   |  Item 4
  100   |  110   |  111   |  Item 5
  100   |  110   |  112   |  Item 6
  </code></pre>
  
  <p>But I want to suppress repeating values in those first two columns so it looks like this:</p>
  
  <pre><code>COL 1 |  COL 2 |  COL 3 |  COL 4
  ----------------------------------
  100   |  100   |  100   |  Item 1
        |        |  101   |  Item 2
        |        |  102   |  Item 3
        |  110   |  110   |  Item 4
        |        |  110   |  Item 4
        |        |  111   |  Item 5
        |        |  112   |  Item 6
  </code></pre>
  
  <p>I thought it might be as easy as right clicking the column and selecting "Hide duplicate values", but I'm not seeing that.
  I'll apologize now because I'm going to feel stupid when someone points out how easy it is to do or find.</p>