I want to create an emailed report of time spent on a project during the last week. I have a scaled down drawing to show the relations.
From the Project table my script finds the records in the Time table between a range in Time Date field.
Records are sorted by __kf_Designer ID.
I have a calculation field on the Project table that takes the Time Length seconds value from the Time table and puts it into hh:mm:ss.
I also have a summary field on the Project table that totals the hh:mm:ss from the calculation above.
I'm trying to use the GetSummary(Project:Time Log Summary;Project:_kf_DesignerID) while looping thru the groups, when a change in _kf_DesignerID is detected, to get only the records that are within the range but it doesn't seem to work correctly.
Can anyone tell me how to go about doing this?