title: How do I write report from 2 different dataset linked by ID?
body: <p>I am building a report in report builder.  I have 2 dataset, they <strong>can't be merged</strong> because of their complexity.  What I would like to do is make a report where it use the ID from the first dataset to look up data in the 2nd dataset.  Is this possible?  The following are example, not exact code, but what I need:</p>
  
  <p>First Dataset:</p>
  
  <pre><code>select itemID from Items
  </code></pre>
  
  <p>Second Dataset:</p>
  
  <pre><code>select itemID, saleAmount, salePrice from Sales
  </code></pre>
  
  <p>I would like to setup my report like this:</p>
  
  <pre><code>ItemID        | Sale Count                                                  | Sale Price 
  --------------+-------------------------------------------------------------+------------
  Items.itemID  | sum(Sales.saleAmount) where items.itemID = Sales.itemID     | sum(Sales.salePrice ) where items.itemID = Sales.itemID
  </code></pre>
  
  <p>So the end result will be like this:</p>
  
  <pre><code>ItemID        | Sale Count                                                  | Sale Price 
  --------------+-------------------------------------------------------------+------------
  1             | 11223                                                       | $123123
  2             | 4537                                                        | $8375
  </code></pre>
  
  <p>Is this possible?  Maybe with Conditional Lookup?</p>