0

I need to create something like this in SSRS:

enter image description here

My source dataset is fetchxml. I have actually two datasets.

One dataset is just the datapoint "347" whereas the other datapoint is "1000"

Dataset_Active returns 347
Dataset_InActive returns 1000

I have the option of using these fields for the following 3 categories:

enter image description here

My issue is that I cannot use values from multiple datasets.

How do I create a pie chart where the data comes from 2 different datasets? Also in the case that I just neeed to graph 2 values, should I use anything in the category/values/series or just use values?

Alex Gordon
  • 57,446
  • 287
  • 670
  • 1,062
  • Have a look here https://social.msdn.microsoft.com/Forums/sqlserver/en-US/53c5d2b1-36e4-4ef8-9bea-48adbf0475b4/multiple-datasets-in-a-single-chart It's saying the `Lookup` function gives you an option to get data from 2 datasets – artm Nov 11 '14 at 22:53
  • thanks! where would i put that? in the cateogry groups or series groups or values? http://screencast.com/t/bL0dcpI0 – Alex Gordon Nov 11 '14 at 23:43
  • Values I think but I'm not sure. – artm Nov 12 '14 at 00:16

0 Answers0