title: SQL Report Builder 3.0.Grouping Data from Dataset
body: <p>Good day Everybody.</p>
  
  <p>I am working on Sql Report Builder 3.0. I have a dataset with X records. From the data set i Supposed to display one or more table based on Some conditions. How can i do that..? I dint get solution from Google. Pls help me in this..</p>
  
  <h2>Scenario:</h2>
  
  <p>Let say I have 4 Records in Dataset.</p>
  
  <hr>
  
  <p><strong>OrderNo <em>_</em>__ Product <em>_</em>__ DeliveryDate <em>_</em>_____Address</strong></p>
  
  <p>11223 ---------- Prod1 ----------20-Sep-2013 ---------- 31, Woodlands drive</p>
  
  <p>11223 ---------- Prod2 ----------20-Sep-2013 ---------- 31, Woodlands drive</p>
  
  <p>23688 ---------- Prod1 ----------20-Sep-2013 ---------- 227, North Avenue</p>
  
  <p>23688 ---------- Prod2 ----------20-Sep-2013 ---------- 227, North Avenue</p>
  
  <p>I want to display my report as follows,</p>
  
  <h2><strong>Address:</strong> 31, Woodlands drive</h2>
  
  <h2>Order_No ---------- Product</h2>
  
  <p>112233 ---------- Prod1<br>
  112233 ---------- Prod2      </p>
  
  <p>.
  .
  .</p>
  
  <h2>Address: 227, North Avenue</h2>
  
  <h2>Order_No.......Product</h2>
  
  <p>236882 ---------- Prod1<br>
  236882 ---------- Prod2    </p>
  
  <p>--
  Thanks,
  Shami</p>