Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
lavvu
Starting Member
13 Posts |
 Posted - 2008-12-09 : 07:30:15
|
| Can anyone tell me if it is possible to use data from multiple dataset in a chart?I have the unit name and total employees in one dataset and approved employees for these units in another dataset. I cannot combain these two into one dataset. I need to use a ratio of approved employees / total employees for a these unit names in the chart as a stacked bar chart. Is it possible?ThanksLavvu. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
lavvu
Starting Member
13 Posts |
Posted - 2008-12-09 : 22:55:55
|
| I cant join them because if i join these tables i wont be able to get the total number of employees in a unit. I will only get the total number of approved employees in a unit. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-10 : 03:00:45
|
quote:
Originally posted by lavvu
I cant join them because if i join these tables i wont be able to get the total number of employees in a unit. I will only get the total number of approved employees in a unit.
then use left join rather than inner join. this way you will get all employees detail regardless of whther they are approved or not. |
|
|
|
|
|
|
Multiple dataset in a chart