title: Is it possible to display distinct record from dataset in RDLC report
body: <p>Did a quick search and couldn't find the answer I've been looking for.
  So I have a vb.net windows application which uses RDLC to generate invoice, delivery order, price list and other documents. To reduce server load as much as possible, information will only be pulled once from the server and it includes order items, price and other necessary data.</p>
  
  <p>Once the data is pulled (in xml) it will be filled into a dataset which will be used in generating various reports. Note that this same dataset is used in multiple RDLC reports to display different information.</p>
  
  <p>So the problem in my case is that I cannot do a SELECT DISTINCT from the SQL level because the same set of data will also be used generate the invoice, but I also need to display a price list from the same dataset which only include distinct order items.</p>
  
  <p>So the options I have:</p>
  
  <ol>
  <li><p>Have the RDLC to display distinct row, but I have no idea on how it can be achieved.</p></li>
  <li><p>Failing that, I might need to create another datatable in my xsd file using the existing dataset, separating the dataset into 2. Again, I have little idea on the details of execution.</p></li>
  </ol>
  
  <p>Any input is much appreciated. Thanks!</p>