Posted by Barbara Brazil on June 10, 2020 at 13:32:40:
In Reply to: Re: Reporter problem posted by Grant E Foraker on June 10, 2020 at 13:27:28:
OK the problem is that earn.amount and earn.hours are defined in #CFILES as STRING fields, not NUMERIC. You can't TOTAL them. When you use a string field in a TOTAL statement it just prints the last value. That's exactly what it is doing.
You should keep the SELECT and SORT before REPORT since you are only using primary file fields.
Post a Followup
Each file can be a maximum of 1MB in length Uploaded files will be purged from the server on a regular basis.