using a calculated figure in my selection criteria 1

[SamLN]

Hi all
firstly I apologise in advance for my lack of crystal knowledge!

I am using crystal reports 2008 The purpose of the report is to find which employees have had more than 173.33 hours paid to them.

There may be anywhere from 1 row or data per employee to 50 rows per employee.

I need to sum all of the rows to get total hours per employee and then compare that to see if they are greater than 173.33.

my question is how to I get a selection criteria to work based on the sum of all records per employee, when the sum of records has not been completed at selection criteria time?.

TIA
Sam

 

[pmax9999]

I would start by Grouping on the Employee ID field. Then create a Group Selection Formula as follows (substituting the correct Table/Field names):

Sum({Table.HoursWorked}, {Table.EmployeeID}) > 173.33

Hope this help
Pete

 

[SamLN]

thanks, that was very simple but worked very well.
Sam