Data from Multiple DataSets in Graph

All Replies

• Thursday, January 31, 2013 9:43 AM

   

   
  

  0

  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.

  
  
  
  
  

  • Edited by Eswararao C Thursday, January 31, 2013 9:46 AM
  •  
  • Reply
  • Quote

   
• Thursday, January 31, 2013 9:56 AM

   

   
  

  0

  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

  • Reply
  • Quote

   
• Thursday, January 31, 2013 9:58 AM

   

   
  

  0

  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.

  • Marked As Answer by Manjunath C Bhat Thursday, January 31, 2013 10:00 AM
  •  
  • Reply
  • Quote

   
• Thursday, January 31, 2013 10:00 AM

   

   
  

  0

  HIEswararao,

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

  ---

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

  • Reply
  • Quote