title: How to add a dynamically pivot table result to SSRS Report?
body: <p>I'm new to Pivot &amp; SSRS, I need to create a report which is something similar to Pivot Table.</p>
  
  <p>The report layout is as follow:</p>
  
  <pre><code>           Area_1  Area_2  Area_3  Area_4  ...  Area_N
  A_Percent
  B_Percent
  C_Percent
  D_Percent
  </code></pre>
  
  <p>Since the "Area_N" is dynamic, hence my table layout is as follow:</p>
  
  <pre><code>Area   A_Percent   B_Percent   C_Percent   D_Percent
  ----   ---------   ---------   ---------   ---------
  Area_1    45           55         66           77
  Area_2    22           33         11           55 
  Area_3    12           45         88           36
  Area_4    67           23         37           28
  ...
  Area_N    76           67         35           28
  </code></pre>
  
  <p>So my question is:</p>
  
  <ol>
  <li>How to create the Pivot table base on the above structure?</li>
  <li>Can my SSRS Report reads data from the Pivot Table?</li>
  </ol>
  
  <p>Welcome all gurus comment.
  Thanks very much!</p>