Page 1 of 1

How to hide a SUM field in detail lines

PostPosted: Fri Feb 17, 2017 4:53 pm
by Haltar Dhrim
Hi all,
I have to print a report with a total at the bottom, but i cannot use TALLY because I have to count only a certain type of records.
I thought about printing a COUNTER field in the detail line, which value is 1 if the record is to be counted, then summing it up in the total line.
The problem is, I shouldn't write that COUNTER on the detail line, but only in the total line.
Is there some way to hide the field?

Thanks in advance!

Re: How to hide a SUM field in detail lines

PostPosted: Fri Feb 17, 2017 10:46 pm
by Haltar Dhrim
I found out how to hide the COUNTER.
You have to overwrite it with a blank string, like this:


LINE 1 COL 01 FIELD-01 +
       COL 21 FIELD-02 +
       COL 41 COUNTER  +
       COL 41 '        '
 

Re: How to hide a SUM field in detail lines

PostPosted: Sat Feb 18, 2017 2:37 am
by BillyBoyo
Use a SUM statement. Items named on the SUM can include fields which do not appear on a LINE statement. Then just use that field in relevant Report Procedure.