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!
How to hide a SUM field in detail lines
-
- Posts: 2
- Joined: Fri Feb 17, 2017 4:43 pm
- Skillset: COBOL, CICS, DB2, JCL, EASYTRIEVE, CHANGEMAN
- Referer: Search Engines
-
- 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
I found out how to hide the COUNTER.
You have to overwrite it with a blank string, like this:
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 ' '
-
- 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
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
-
- 1
- 1779
-
by sergeyken
View the latest post
Fri Mar 26, 2021 11:59 pm
-
-
compare number lines of two dataset
by samb01 » Wed Nov 13, 2024 8:46 pm » in DFSORT/ICETOOL/ICEGENER - 6
- 2120
-
by sergeyken
View the latest post
Fri Nov 15, 2024 12:41 pm
-
-
- 2
- 1578
-
by sergeyken
View the latest post
Sun Jan 26, 2025 3:07 am
-
-
sort card to add zeros to varying alphanumeric field.
by longfall » Thu Mar 09, 2023 12:03 am » in DFSORT/ICETOOL/ICEGENER - 1
- 1823
-
by sergeyken
View the latest post
Thu Mar 09, 2023 2:04 am
-