How to hide a SUM field in detail lines



Unicenter CA-Easytrieve Plus Report Generator: CA's information retrieval and data management tool

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!

These users thanked the author Haltar Dhrim for the post:
mywave86ba (Sat Jun 10, 2017 12:36 pm)
Haltar Dhrim
 
Posts: 2
Joined: Fri Feb 17, 2017 4:43 pm
Has thanked: 0 time
Been thanked: 1 time

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:


LINE 1 COL 01 FIELD-01 +
       COL 21 FIELD-02 +
       COL 41 COUNTER  +
       COL 41 '        '
 
Haltar Dhrim
 
Posts: 2
Joined: Fri Feb 17, 2017 4:43 pm
Has thanked: 0 time
Been thanked: 1 time

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.

These users thanked the author BillyBoyo for the post:
mywave86ba (Sat Jun 10, 2017 12:37 pm)
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times


Return to CA-Easytrieve

 


  • Related topics
    Replies
    Views
    Last post