I have a table which contains data as below,
Emp_No Emp_Name Designation DOB Posted_at Address Type 1 A1 X 19-Aug-81 P FGF II 2 A2 Y 10-Jun-85 P FNH I 3 B3 X 25-Jul-79 Q LKNFKJN I 4 N6 Z 28-Apr-80 R HDSZS I 5 J8 Y 13-Oct-80 P NBGFJ II 6 F7 X 19-Aug-81 P NDJ I 7 M3 Z 12-Sep-84 Q BDSE III 8 F6 Y 10-Jun-85 R NJUK IV 9 W2 X 26-Jun-85 P NFYTH V
Now how can I generate following reports,
1. Staff Position Office Wise
Office X Y Z Total P 3 2 0 5 Q 1 0 1 2 R 0 1 1 2 Total 4 3 2
2. Staff Position Details
Designation ‘X’ P 3 1 Mr. A1 FGF II 2 Ms. F7 NDJ I 3 Ms. W2 NFYTH V Q 1 1 Mr. B3 LKNFKJN I R 0 Designation ‘Y’ P 2 1 Mr. A2 FNH I 2 Ms. J8 NBGFJ II Q 0 R 1 1 Mr. F6 NJUK IV Designation ‘Z’ P 0 Q 1 1 Mr. M3 BDSE III R 1 1 Ms. N6 HDSZS I