joining two datasets

chait

hi seniors
i have two datasets each one displaying a list of employee id's .
i have got each one dataset onto each row in a grid. So, the left column of my report shows a list and my right another.
now i need to take the count of each and plot them on a pie chart..
how can i do that?

thanks in advance
krishna chaitanya

mwilliams

Hi krishna,

There may be other ways to do this as well, but here's one way that definitely does work. You can create two new datasets that do count statements to count the results of the query. Then, you could create a joint dataset with a full outer join of these two datasets with a computed column that puts both values in the same column. Then you can chart those values in your pie chart.

Using a scripted dataSet could be a possibility as well. I haven't tried anything with that though.