SSRS combines multiple datasets into one graph

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
+3
source share
2 answers

. , , (, ), .

, .

0

All Articles