How to hide a SUM field in detail lines

Unicenter CA-Easytrieve Plus Report Generator: CA's information retrieval and data management tool
Haltar Dhrim
Posts: 2
Joined: Fri Feb 17, 2017 4:43 pm
Skillset: COBOL, CICS, DB2, JCL, EASYTRIEVE, CHANGEMAN
Referer: Search Engines

How to hide a SUM field in detail lines

Postby Haltar Dhrim » Fri Feb 17, 2017 4:53 pm

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!

Haltar Dhrim
Posts: 2
Joined: Fri Feb 17, 2017 4:43 pm
Skillset: COBOL, CICS, DB2, JCL, EASYTRIEVE, CHANGEMAN
Referer: Search Engines

Re: How to hide a SUM field in detail lines

Postby Haltar Dhrim » Fri Feb 17, 2017 10:46 pm

I found out how to hide the COUNTER.
You have to overwrite it with a blank string, like this:

Code: Select all


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

BillyBoyo
Global moderator
Posts: 3805
Joined: Tue Jan 25, 2011 12:02 am
Skillset: Easytrieve Plus, Cobol, Utilities, that sort of stuff
Referer: Google

Re: How to hide a SUM field in detail lines

Postby BillyBoyo » Sat Feb 18, 2017 2:37 am

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.


  • Similar Topics
    Replies
    Views
    Last post