title: SSRS reporting. How to repeat group of rows using list control
body: <p>I want to be able to display a report something like:</p>
  
  <p><strong>District1</strong></p>
  
  <p><strong><pre>Store Name     Product      Price per piece     Quantity sold     Total Price</pre></strong></p>
  
  <pre>XYZ store     Product1              10                  6                  60</pre>
  
  <pre>              Product2               8                  5                  40</pre>
  
  <p><strong>District2</strong></p>
  
  <p><strong><pre>Store Name     Product      Price per piece     Quantity sold     Total Price</pre></strong></p>
  
  <pre>XYZ store     Product1              11                  5                  55</pre>
  
  <pre>              Product2              10                  4                  40</pre>
  
  <p><strong>District3</strong></p>
  
  <p><strong><pre>Store Name     Product      Price per piece     Quantity sold     Total Price</pre></strong></p>
  
  <pre>ABC store     Product1               10                  5                  50</pre>
  
  <pre>              Product2               7                   8                  56</pre>
  
  <p><strong>District4</strong><br>
  <strong>....</strong><br><strong>....</strong><br>
  <strong>....</strong><br>
  <strong>District N</strong>
  <br><br>
  The way data is stored in database is:</p>
  
  <pre><strong>District      StoreName       Product       Price       Qty</strong><br>
  District1     XYZ Store       Product1      10          6<br>
  District1     XYZ Store       Product2       8          5<br>
  District2     XYZ Store       Product1       11         5<br>
  District2     XYZ Store       Product2       10         4<br>
  District3     ABC Store       Product1       10         5<br>
  District3     ABC Store       Product2       7          8</pre>
  
  <p>I tried using List control for repeating the group of rows but no luck so far. please help.</p>