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
 

 

Need help in report printing in Easytrieve

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

Active User


Joined: 10 Aug 2009
Posts: 158
Location: India

PostPosted: Thu Sep 13, 2012 7:36 pm    Post subject: Need help in report printing in Easytrieve
Reply with quote

Hi All,

First of all, thank you very much for all your kind help.

I need to print the total number of records and the total of payment field at the end of report in easytrieve.

File Layout:

Code:

FILE INFLE  FB(45 0)                     
IN-REC                      01   45  A   
IN-KEY                      01   10  N   
IN-PAYMENT                  26   12  N 2


Report Definition:

Code:

REPORT REPORT1 LINESIZE 132 PRINTER RPTDD01 SUMCTL ALL
CONTROL IN-PAYMENT                               
TITLE 01 'TITLE - 1'             
TITLE 02 'TITLE - 2'         
LINE  01  IN-KEY              +                       
          IN-PAYMENT                           


Sample Input Data:

Code:

----+----1----+----2----+----3----+----4----+
0012345678               001234567899       
0045612300               091234567899       
0010089078               711234567899       


Sample Output:
Code:

             TITLE - 1
             TITLE - 2
  IN-KEY                  IN-PAYMENT
0012345678               0012345678.99       
0045612300               0912345678.99       
0010089078               7112345678.99       
     3                   8037037036.97


Tried with different options using SUMMARY, TALLY, etc... But I could not get the desired output.

Can anyone help me in this regard.

Please help.

Thanks,
Sati
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 Sep 13, 2012 10:14 pm    Post subject:
Reply with quote

Hello,

Try using SUMMARY for the report definition.
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7315

PostPosted: Fri Sep 14, 2012 12:30 am    Post subject: Reply to: Need help in report printing in Easytrieve
Reply with quote

It is unusual to specify an amount as a control-field. If you want final totals, youl need CONTROL FINAL as well.

Do you have a manual? If not, get one. This is about the 2nd simplest report you'll ever see, so you've really got to crack it on your own, and it is all in the manual.

If your manual is delayed, look at other Easytrieve Plus programs at your site. I'm not going to say ask a co-worker. You need to do this yourself, from the manual and what sample code you can find. If someone "gives" on all of this, you'll have lost a good learning opportunity which you need when starting out with it.
Back to top
View user's profile Send private message
satish.ms10

Active User


Joined: 10 Aug 2009
Posts: 158
Location: India

PostPosted: Mon Sep 17, 2012 12:24 pm    Post subject:
Reply with quote

Thanks a lot Dick and Bill for your pointers.

I have learnt new things on report concept in easytrieve.

I got my output using below report definition.

Code:

REPORT REPORT1 LINESIZE 132 PRINTER RPTDD01 SUMMARY SUMCTL DTLCOPY DTLCTL EVERY
SEQUENCE IN-KEY
CONTROL FINAL NOPRINT IN-KEY


Thanks again.

Thanks,
Sati
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7315

PostPosted: Mon Sep 17, 2012 2:02 pm    Post subject: Reply to: Need help in report printing in Easytrieve
Reply with quote

Glad to hear it. Thanks for letting us know.
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 UNIT=AFF for Easytrieve code gandikk JCL & VSAM 7 Wed Jul 12, 2017 11:42 pm
No new posts JES2 doesn't honor the priority of th... Aron Lendvai JCL & VSAM 7 Thu Jun 29, 2017 1:41 pm
No new posts Report cost in CA-dispatch Nileshkul CA Products 3 Wed Jun 07, 2017 10:32 pm
No new posts READ A PACKED "NEGATIVE" FI... jdesouza CA Products 3 Tue May 02, 2017 11:43 pm
No new posts Splitting of single report to seperat... abdulrafi TSO/ISPF 7 Mon Mar 27, 2017 3:59 pm


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