title: Crosstab Report With Dynamic Columns in PRD
body: <p>i want to create a crosstab report in PRD but with dynamic columns based on report filter</p>
  
  <p>For example i want to generate summary purchase report based on selected date</p>
  
  <p>Sample of table :</p>
  
  <pre><code>Date    Purchase No Total Value
  1-Jan   PO001    $10.00 
  5-Jan   PO002    $20.00 
  7-Jan   PO003    $30.00 
  7-Jan   PO004    $40.00 
  20-Jan  PO005    $50.00 
  22-Jan  PO006    $60.00 
  22-Jan  PO007    $70.00 
  25-Jan  PO008    $10.00 
  30-Jan  PO009    $20.00 
  </code></pre>
  
  <p>So if my filter is from 1 Jan to 15 Jan then my report should looks like this:</p>
  
  <pre><code>Description              1-Jan      5-Jan      7-Jan
  Purchase total value     $10.00      $20.00      $70.00 
  </code></pre>
  
  <p>Then if my filter is from 1 Jan to 30 Jan it will looks like :</p>
  
  <pre><code>Description              1-Jan      5-Jan      7-Jan      20-Jan     22-Jan     25-Jan    30-Jan
  Purchase total value     $10.00      $20.00      $70.00      $50.00      $130.00     $10.00      $20.00 
  </code></pre>
  
  <p>Any idea how to create this on PRD ?
  currently i have PRD 3.9 &amp; 5.0</p>