calculating no. of values using Another dataprovider using s

I have to develop the students reports who has completed the course and also i have to calculate Total no. of employess completed …and total no .of employees and % of employees…

If i use another data provider for the total no of employess …I got the reul in one report …When i tried to do the same for "Non Completion report …I couldn’t get that By using another document …Can anyone can help me ?
I have created the total no of employees in the designer itself …


pks (BOB member since 2004-07-11)

% completed will just be 100 * number completed/total number

If you have a completed flag or date in the database then you could use CASE statements. Search will reveal example CASE statements if you don’t know how to write these.