Saturday, August 20, 2005 4:23 AMIs it possible to incorporate data from 2 datasets into a single chart? For example I have 1 set of data from 1 db which allows me to display datapoint "A" by week. I have a second dataset from another db which allows me to display datapoint "B" by week. I'd like to plot each of these separate datapoints on a single chart with the x axis being week and the y axis being a stacked bar chart incorporating both A and B values as individual data series. Further, assuming this is possible, is it then possible to have 1 series displayed as an area while the 2nd series is a column or line?
Thanks in advance!
Wednesday, September 14, 2005 12:59 PMDid you ever find a way to do this? In the middle of a Reporting Services 2005 evaluation and we are trying to reproduce this functionality.
Thursday, December 08, 2005 5:42 AMOwnerSorry this is currently not supported. You would need to join the two result sets already in the dataset query to be able to use it in the same chart.
Thursday, December 13, 2007 5:29 AMDoes this work now (2 years later)?
- Proposed As Answer by jazzyg Friday, March 05, 2010 9:13 AM
Friday, November 21, 2008 11:29 PM
I have a question about this...I have the results in the same dataset. The data is something like
DateTime field | Total Field | Project Field
11/20/2008 5 Destiny
11/20/2008 10 Foo
11/20/2008 12 Bar
I want to graph the data in a Stacked Area Chart where each area is a Project with their corresponding Total counts grouped by the DateTime field. My question is how can you have multiple areas in the chart if they are grouped this way?
I have tried using Filters across the entire chart, but that only works when using one Project. If I add addtional values, there is no way to add a clause to differentiate between the projects since I cannot put a simple Where clause using VB say something like this = Fields!Total.Value where Fields!project.Value = "Destiny" for the value.
Is this simply not possible?
Friday, March 05, 2010 9:12 AMDoes it work in SSRS 2008 ( again 2 Yrs later)? Or MS is just not able to get it to work and we can just lock this thread for ever!!
- Edited by jazzyg Friday, March 05, 2010 9:13 AM edit
Friday, July 08, 2011 3:43 PM
I need to know the answer too.
Does this work with SSRS 2008?
Saturday, July 09, 2011 1:24 PM
Though it is not possible to use two different DATASET in a same chart, but there is way to use the same.
Good news is that you can do this in SSRS 2008 R2 not even in SSRS 2008.
There is new functon LOOKUP, but what you need is one field common in both dataset.
Expression is :
=LookUP(field1(from dataset1), field2(from datset2),feild3(from datset2 which need to be used), "Dataset2")
it will show all the values for field3 from dataset2 for those field2 of dataset2=field1 of dataset1)
Please mark as answer if useful.
- Proposed As Answer by krysolov Thursday, March 07, 2013 3:32 PM
Thursday, February 23, 2012 11:20 AMCan you help me?
I have the same problem: