title: Is it possible to specify separate locations in an ssrs report for data that share a column?
body: <p>Apologies for muddy wording on the question, I'm not sure how to concisely capture what I'm trying to do. This is running on SQL Server 2012.</p>
  
  <p>I have a table that looks like this:</p>
  
  <pre><code>Form     Date        Label       Description
  -------- ----------- ----------- -----------------
    A      1/17/2018   Food        Apple               
    B      1/16/2018   Food        Celery              
    C      1/15/2018   Food        Pork                
    C      1/15/2018   Topping     Gravy               
    C      1/15/2018   Side        Mashed Potatoes  
  </code></pre>
  
  <p>And I would like to generate a report that looks like this:</p>
  
  <pre><code>Form A    Date: 1/17/2018
  
      Food        Topping       Side
      ------      --------      ------
      Apple        None          None
  
  Form B    Date: 1/16/2018
  
      Food        Topping       Side
      ------      --------      ------
      Celery      None          None
  
  Form C    Date: 1/15/2018
  
      Food        Topping       Side
      ------      --------      ------
      Pork        Gravy         Mashed Potatoes
  </code></pre>
  
  <p>Is there a way to display these Description values in specific positions when they all share the same column? I've tried making visibility expressions based on the Label column value, but it just hides the field altogether.</p>
  
  <p>I would create a row group on the Label column if I could but in this instance the positions are fixed constraints. Currently the only grouping is the Form row group.</p>