I am relatively new to Crystral Reports.
I have three fields of concern in my projects table.
1) ProjectType
2) LeadHours
3) LeadRate
When I print a project type summary report, which summarizes a bunch of other fields in the same table, I also want to calculate the total labor cost for each job type. On a job-by-job basis, this is simply = (LeadHours * LeadRate). I want the report to calculate this for each record and place the total in a report field for each project type. I cannot figure out how to do this. I know that I can place a calculated field in the database to do this, but I am wondering if there is any way to do it in Crystal. It appears that summary fields cannot be based on calcualtions that are performed for each record, unless I am missing something.
I have three fields of concern in my projects table.
1) ProjectType
2) LeadHours
3) LeadRate
When I print a project type summary report, which summarizes a bunch of other fields in the same table, I also want to calculate the total labor cost for each job type. On a job-by-job basis, this is simply = (LeadHours * LeadRate). I want the report to calculate this for each record and place the total in a report field for each project type. I cannot figure out how to do this. I know that I can place a calculated field in the database to do this, but I am wondering if there is any way to do it in Crystal. It appears that summary fields cannot be based on calcualtions that are performed for each record, unless I am missing something.