title: Dynamic Columns In Reporting Services Tablix
body: <p>I have a data query that returns data in the following format:</p>
  
  <pre><code>Name    Period    Value
  -----------------------------
  Bob     Jan       123 
  Bob     Feb       456 
  Bob     Mar       789
  Tom     Jan       321 
  Tom     Feb       654 
  Tom     Mar       987
  Joe     Jan       147 
  Joe     Feb       258 
  Joe     Mar       369
  </code></pre>
  
  <p>The different periods are constant between names, but will be different between executions of the report (ie, I may query a report on Jan/Feb/Mar now, or Apr/May/Jun later). I'm trying to put that into a table in my Reporting Services report, that would look something like this:</p>
  
  <pre><code>Name    Jan    Feb    Mar
  ----------------------------
  Bob     123    456    789
  Tom     321    654    987
  Joe     147    258    369
  </code></pre>
  
  <p>Can anyone point me to an example of doing something like that? I'm not even sure how to describe that 'rotation'(?) of the data. The columns should be dynamic based on what Period values are in the dataset. </p>