title: SSRS combine multiple datasets into one graph
body: <p>I've been looking around online for a way to fully combine datasets in SSRS (2008 R2).</p>
  
  <p>Basically, I need to create a single table and graph composed of a number of different datasets (all with the same columns as below) which are retrieved from multiple sql servers (preventing me from combining them in a single query)</p>
  
  <p>Can the datasets be combined into a single dataset or table from which I can produce a single graph (this is the requirement I was given) as shown below?</p>
  
  <p>Thanks in advance. </p>
  
  <pre><code>DataSetA (ServerA)
  ProductName    Sold    Remaining
  Product1       4       8
  Product2       13      7
  Product3       34      57
  
  DataSetB (ServerB)
  ProductName    Sold    Remaining
  Product4       34      12
  Product5       21      32
  Product6       16      20
  
  DataSetC (ServerC)
  ProductName    Sold    Remaining
  Product7       45      28
  Product8       22      56
  Product9       7       4
  
  --&gt;Combined into
  
  Table/DataSetD 
  ProductName    Sold    Remaining
  Product1       4       8
  Product2       13      7
  Product3       34      57
  Product4       34      12
  Product5       21      32
  Product6       16      20
  Product7       45      28
  Product8       22      56
  Product9       7       4
  </code></pre>