Sounds like the summary field should be defined in Time, not Projects,
I've tried a variation of that... From what I understand to use GetSummary() in a script I have to have the summary and the group by in the same table. I want to group by __kf_Designer ID which isn't in the Time table.
Yet the summary itself won't compute the correct totals or subtotals if not defined in the correct table for the totals desired. I Probably don't have all the details here, but if you are performing a find on the time table, you should be basing your layout and any needed calculations on the time table, not project.
I don't see yet why you would need the getsummary function for this particular task.
And summary fields are not your only options for computing aggregate values there are also aggregate functions that can sometimes be used.
Thank you for pointing me in the right direction. I'm almost there...
I built a layout based on the Time table. I find the records with a range of dates and I have a leading sub summary grouping them by Designer ID. I also have a trailing sub summary to total the individual groups with a summary field in the Time table.
Now I need to take each individual group and compose an email to send to each designer to show invested project time. This is where I was going to use the GetSummary to get the sum for each group by looping thru each record and detecting when ID changed.
Set Variable [$DesignerID; Value:__kf_Designer ID]
if [$DesignerID ≠ $DesignerIDLast
Send Mail [...GetSummary(Time::Time Summary;Project::_kf_Designer ID)]
Set Variable [$DesignerIDLast; Value:$DesignerID]
Go to Record/Request/Page [Next; Exit after last]
I would like to email each line of time and the sub summary to compute the total to each person like the layout shows but not whole report to a group. Is there a way to go about this?
There are multiple options. You can build a simple list of information in the body of the email or you can use this same layout in a separate window (to keep this report and found set unmodified) to produce a PDF of just one such group at a time for attachment to the email.
You'll need to decide which method you want to use here.
I'd like to try the pdf attachment of a single group first. I have the designer's email address in the Designer table. How do I iterate thru the groups to create this pdf. Sometimes not all available designers will have logged time, only the ones that show up on the original report need sent the information. Where do I start in taking this report and composing one group at a time into a pdf for sending email?