title: How to use 2 datasets on SSRS to compare and show the result
body: <p>I am using SSRS 2008 to build the report</p>
  
  <p>Functionality:</p>
  
  <p>I have created report which is having 2 datasets </p>
  
  <pre><code>1) dslocation
  2) prevdslocation
  
  There are few fields like say:
  
      1) locationId
      2) locationName
      3) mmpremium
      4) sspremium 
  </code></pre>
  
  <p>In my report I need to show the result as below :</p>
  
  <pre><code>Locationname        mmpremium(dslocation) - mmpremium (prevdslocation)
  
  SANDY                1000 - 2000
  RANSY                2000 - 3000
  </code></pre>
  
  <p>I want to do this in the report level instead of SQL to return as single dataset.</p>