Re: Reporter problem

[ Follow Ups ] [ Post Followup ] [ Forum ]

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.

Follow Ups:

Post a Followup



What is the name of the main Signature System's Product?  


Optional Link URL:
Link Title:
Optional Image URL:

You may attach up to 5 files to your followup (see below):

Each file can be a maximum of 1MB in length Uploaded files will be purged from the server on a regular basis.

[ Follow Ups ] [ Post Followup ] [ Forum ]