Sir,
Yes definitely there is mistake.
I use software.id to count software wise no of student with batch status of each trained.
Please see description below.
A) Summary : Trainer Wise – Software – Batch Time
1. At Group: EmployeeDB – Trainers
Description:
In grid, I call ‘EmployeeDB’ table to list down ‘Trainer Name’.
To know, how much student with each ‘Trainers’, I added calculated field ‘Cal_Total’, this will count from ‘Deliverable’ where it is connected. This give me total student.
(select count(id) from Deliverable where Deliverable.id_EmployeeDB = EmployeeDB.id)
Similarly,
To know status of total student, I added calculated field ‘Cal_NotSchedule’, this give me total count with ‘BatchStatus’ each id.
(select count(id) from Deliverable where Deliverable.id_EmployeeDB = EmployeeDB.id and Deliverable.id_BatchStatus = 1)
Up to this Ok, EmployeeDB is editable.
2. At Group: Deliverable Load – Software
Description:
In this grid, using search button, I search above grid, in that ‘EmployeeDB’ table ‘Trainer Name’ is listed down.
To know, how much ‘software’ each ‘Trainers’ handling, for that, I search ‘EmployeeDB, and call Cal_Software from ‘Deliverable’. Now it listed down ‘software’ for each employee.
Up to this Ok, EmployeeDB is editable.
But problem start now.
I want total number of student each software wise of each trainer.
In grid, it’s properly showing software list, of each trainer handling, now to know total number of student, software wise….
For that, I added calculated field ‘Cal_EmpTotal’ in ‘EmployeeDB’ that is….
(select count(id) from Deliverable where Deliverable.id_EmployeeDB = EmployeeDB.id and Deliverable.id_Software = Software.id)
This give the result correct, but because of this, ‘EmployeeDB’ become not editable.
Sir,
I want trainer wise software handling list and the total no of student software wise as well as its status wise.
And that is working correctly. But employee table become not editable.
In derivable grid, I can filter data and count data, but this become lengthy to summarise data and difficult to understand it at one attempt.
Thats why I created trainer wise summary. This give me complete picture.
What should I do?
Please help me.
Regards
Nitin Ingale