I look online to fully combine datasets in SSRS (2008 R2).
Basically, I need to create a single table and graph consisting of several different data sets (all with the same columns as below) that are extracted from several SQL servers (which prevents me from combining them in one query)
Can a dataset be combined into a single dataset or table from which I can create a single graph (this is a requirement that I was given), as shown below?
Thanks in advance.
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
-->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
source
share