Data Extracted using calculate field but table become not editable

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

Sir,

I Need Following Report in Grid

1.    Trainer’s Student Load- Batch Status wise
Colum are…
Trainer Name List, Total Student Count, Not Schedule Count, Running Count, Break Count, Completed Count
2.    Trainer Software Load- Batch Status wise
Colum are…
Trainer Handing Software List, Total Student Count in Stoftware, Not Schedule Count, Running Count, Break Count, Completed Count
3.    Trainer’s Batch Status Load- Batch Time Wise
Colum are…
Trainer Batch Status List, Total Student Count in Batch Status, Student Count in Batch Time 9-12pm, 12-3pm, 3-6pm, 6-9pm

At selecting Report 1 - Trainer, it will show report 2 and 3.

Can Scripting will work for this, instates of calculated field,
If yes, then please give me.

Please see attach Photo, that will tell you, what i need, and did.

Regards
Nitin Ingale

I would like to try to help you but my system has flagged your download file as having a virus in it.

I adjusted your calc fields. Your admin works now.

Sir,

1. Have used Calculated Field In Software table: But becouse of this table becoume not editable.

Cal_SoftEmpTotal
(select count(id) from Deliverable where Deliverable.id_Software = Software.id and Deliverable.id_EmployeeDB = EmployeeDB.id)

2. Ehwagner sir help me and table become editable: But Result showing wrong.

(select count(Deliverable.id) from Deliverable
   Left Outer Join EmployeeDB On EmployeeDB.id = Deliverable.id_EmployeeDB
where Deliverable.id_Software = Software.id)

3. I added Deliverable.id_EmployeeDB = EmployeeDB.id to count properly but showing no change, but it should count.

(select count(Deliverable.id) from Deliverable
   Left Outer Join EmployeeDB On EmployeeDB.id = Deliverable.id_EmployeeDB
where Deliverable.id_Software = Software.id and Deliverable.id_EmployeeDB = EmployeeDB.id)

Please help.

Please find updated file in attachment.

Regards
Nitin Ingale

DrivesSoft,

Please help me.

Regards
Nitin Ingale

Sir,

Thank you,

A. Summary Trainer

1. Child Software table : Trainer handling software list is showing, In that I need the count of student, belongs to respective trainer.
2. Child Batch Time Table : Trainer's handing student status list is showing, In that I need the count of student belong to respective trainer.

B. Summary Software

1. Child Trainer table : Software handling Trainer list is showing, In that I need the count of student belong to respective software.

2. Child Batch Time Table : Software's handling student status list is showing, In that I need the count of student belong to respective software.

Child count is showing wrong result

Please see attach photo.

Regards
Nitin Ingale

Thank very much Sir,

One more last problem, please help,

A. Summary Trainer

in Child: Batch Time: the problem is, its showing all student batch status, Time Wise.

I Also need the Batch Time wise data of each software belong to trainer handing.

I added one more child grid to get software wise  Batch Time.

Please write SQL code for this button.

Please find attach updated file.

Thanks Sir,

Regards
Nitin Ingale

Sir,

Thank you very much for SQL coding,
Your Valuable efforts makes the true ERP System.
Thanks again for spending your valuable time to help me.

Have a Good Day Sir

Regards
Nitin Ingale

Just remove this script

procedure DeliverableTracking_OnShow (Sender: string; Action: string);
begin
    DeliverableTracking.TableGrid2.Options := DeliverableTracking.TableGrid2.Options + goFooter;
    DeliverableTracking.TableGrid3.Options := DeliverableTracking.TableGrid3.Options + goFooter;
    DeliverableTracking.TableGrid5.Options := DeliverableTracking.TableGrid5.Options + goFooter;
    DeliverableTracking.TableGrid6.Options := DeliverableTracking.TableGrid6.Options + goFooter;
    DeliverableTracking.TableGrid8.Options := DeliverableTracking.TableGrid8.Options + goFooter; 
end;

Set option goFooter using Object inspector for TableGrids.