Data from Multiple DataSets in Graph

Question

Hi Team,

I have 2 datasets.

Something similar to Below. How can i achieve this.

---

Thanks & Regards,
Manjunath C Bhat,
http://manjunathcbhat.blogspot.com
http://manjunathcbhat.wordpress.com

Answer 1

Why can't you change your query and get the result in one dataset

Like

Select Label,Series,value from table where username='me'

Union all

Select Label,Series,Sum(Value) Value from table Group by Label,Series

so that the data will be like this

Then it will be easy to build the graph as you wished

---

Please don't forget to Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful. It will helpful to other users.

Answer 2

Hi Eswararao,

Thank you. I was able to get this done exactly by combining both of my datasets using UNION ALL. Thank you.

Just one more question, how did you bring completed in first bar and active in second bar, anything to do with order by?

---

Thanks & Regards,
Manjunath C Bhat,
http://manjunathcbhat.blogspot.com
http://manjunathcbhat.wordpress.com

Answer 3

You have design the report like this:

Regards,Eshwar.

---

Please don't forget to Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful. It will helpful to other users.

Answer 4

HIEswararao,

Thank you. I got my chart working. thanks again,

---

Thanks & Regards,
Manjunath C Bhat,
http://manjunathcbhat.blogspot.com
http://manjunathcbhat.wordpress.com