Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Easytrieve Report issue

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CA Products
View previous topic :: :: View next topic  
Author Message
svsarath

New User


Joined: 30 May 2006
Posts: 16

PostPosted: Wed Dec 03, 2008 8:34 pm    Post subject: Easytrieve Report issue
Reply with quote

Please help me.

Code:
DT       TYPE   NET PAID   ID             
20090309  B        1.00    15         
20090309  B        2.00    25         
20090309  B        2.00    25
20090309  B        3.00    30
20090309  B        5.00    35
20090309  B        5.00    35
20090309  C        5.00    35
                 11.00

REPORT REPORT1 LINESIZE 50 SPACE 1 PRINTER REPFORM1
CONTROL
LINE 1  DT TYPE NET-PAID +
        ID TALLY

Here the NET PAID amount is same for a similar ID
but I need the total NET PAID for all different ID's. In the above example
the total NET PAID should be 11.00, but by using the above Report
statement I am getting total as 23.00.
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Wed Dec 03, 2008 11:23 pm    Post subject:
Reply with quote

Hello,

Quote:
but by using the above Report
statement I am getting total as 23.00
Yes, because 23.00 is the correct answer. If the value is in the report, it will be totaled. Why would you want items on the report to not be totaled?
Back to top
View user's profile Send private message
svsarath

New User


Joined: 30 May 2006
Posts: 16

PostPosted: Wed Dec 03, 2008 11:46 pm    Post subject:
Reply with quote

Dear d.sch,

Actually I need to display those duplicate records also, but there is another field(FIELD1) which is unique for each and every record. Becauseeventhough the value is in the report, it shouldn't be totaled.

Please see the below test data.

Code:
DT       TYPE   NET PAID   ID  FIELD1           
20090309  B        1.00    15   1       
20090309  B        2.00    25   2       
20090309  B        2.00    25   3
20090309  B        3.00    30   4
20090309  B        5.00    35   5
20090309  B        5.00    35   6
20090309  C        5.00    35   7
                 11.00

REPORT REPORT1 LINESIZE 50 SPACE 1 PRINTER REPFORM1
CONTROL
LINE 1  DT TYPE NET-PAID +
        ID FIELD1 TALLY


I hope I am clear.
Thanks
Sarath
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu Dec 04, 2008 3:05 am    Post subject:
Reply with quote

Hello,

You might add a new column (WS-SUM-PAID) to the report and move zeros to the duplicate entries. Then only the first amount would be summed for each "key".
Back to top
View user's profile Send private message
svsarath

New User


Joined: 30 May 2006
Posts: 16

PostPosted: Thu Dec 04, 2008 7:42 am    Post subject:
Reply with quote

Thanks for help..

Thanks
Sarath
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu Dec 04, 2008 7:44 am    Post subject: Reply to: Easytrieve Report issue
Reply with quote

You're welcome icon_smile.gif

Your reply does mean that is it now working, correct?

d
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CA Products All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Execessive parameter issue Sumeendar JCL & VSAM 5 Mon Dec 19, 2016 4:35 pm
No new posts DFHRESPONSE returns issue divated CICS 3 Wed Nov 02, 2016 6:32 pm
No new posts Can sending 5 MB data between cobol p... Kevin Vaz CICS 12 Tue Oct 18, 2016 4:50 pm
No new posts Detailed Transaction History report f... Kyle Carroll CICS 5 Tue Oct 18, 2016 12:42 am
No new posts Easytrieve - Report writing - Only 1 ... Abhi Nature CA Products 2 Wed Sep 14, 2016 11:40 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us