Now how can i get result like
Name job_done , job_failed, score
AA---------2----------0----------50
AB---------0----------1----------0
AC---------2----------0----------25
AD---------0----------1----------0
AE---------1----------1----------70
AF---------0----------1----------0
Hi r937
Thanks for ur reply. it just an example. here 1 is not a job name its a quantity of job given whether it failed or done. my software using this pattern so i cant change table format.i just want to generate report like i want.
Hi,
can anyone show me the procedure to make this happen, i am new on this.
emp_id–Name
1-------AA
2-------AB
3-------AC
4-------AD
5-------AE
6-------AF
7-------AZ
Now how can i get result like
Name - -job_done - job_failed -score - job_handled - success_rate
AA---------2----------0----------50-------- 2 -----------100%
AB---------0----------1----------0 -------- 1 ----------- 0%
AC---------2----------0----------25-------- 2 -----------100%
AD---------0----------1----------0 -------- 1 ----------- 0%
AE---------1----------1----------70-------- 2 ----------- 50%
AF---------0----------1----------0 -------- 1 ----------- 0%
1)here date will not visible but i must able to search by date from both job_done and failed date by one selected range but i’m only can manage with one date either table 2 or 3 .
2)if a employee like ‘AZ’ not give any job will exclude from report.