none
Multiple datasets in a single chart?

    Question

  • Is 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!

    Saturday, August 20, 2005 4:23 AM

Answers

  • Sorry 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.

    -- Robert
    Thursday, December 08, 2005 5:42 AM
    Owner

All replies

  • Did 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.
    Wednesday, September 14, 2005 12:59 PM
  • Sorry 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.

    -- Robert
    Thursday, December 08, 2005 5:42 AM
    Owner
  • Does this work now (2 years later)?
    • Proposed as answer by jazzyg Friday, March 05, 2010 9:13 AM
    Thursday, December 13, 2007 5:29 AM
  • 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, November 21, 2008 11:29 PM
  • Does 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, March 05, 2010 9:12 AM
  • I need to know the answer too.

    Does this work with SSRS 2008?

    Please answer.

    Friday, July 08, 2011 3:43 PM
  • Hi Hognose,

    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)

     

     

    Amit

    Please mark as answer if useful.



    • Proposed as answer by krysolov Thursday, March 07, 2013 3:32 PM
    Saturday, July 09, 2011 1:24 PM
  • Can you help me?

    I have the same problem: 

    http://social.msdn.microsoft.com/Forums/en-US/MSWinWebChart/thread/e5bf10a6-702d-4c24-bcf8-e3501877355b
    Thursday, February 23, 2012 11:20 AM