Trailing Grand Summary not calculating
My report is based on the Jobs table, and each job can have multiple related records in the JobLineItems table (these are entered via a portal). I created a summary field that summarizes all of the line items in each job (a line item has a qty X $price). The summary field seems to be caculating fine on a per job basis from what I can see, as it's correctly calculating the sum of all the line items for each job.
However, if I switch to the report layout, based on the same Jobs table, the trailing grand summary shows values from the last record in my find, not a grand total. The grand total field is the same summary field used to total each job, and it's in a part defined as a trailing grand summary. Help!