1 Reply Latest reply: Aug 13, 2013 4:47 AM by Vishwaranjan Kumar RSS

    how to display

      how to display count of employees in each department in the below table format

      load * from employee;

      load * from department;

       

      departmentcount(employees)
      sales10
      HR10
      finance25
      corporate45
      Total90

       

      whenver I clik on concerned department those details are to be displayed in ohter table

      i.e. when i click i slaes all the 10 records are to be displyed as below

       

      departmentemployee numberEmplyee typesalarycountrymanager
      sales1Regular40kINDXXX
      sales2Temp50kINDYYYY
      ...............
      sales10temp60kINDZZZZZ