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: 7251

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: 7251

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 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
No new posts TXT2PDF problem - printing @ in PDF vipul65 All Other Mainframe Topics 9 Thu Aug 25, 2016 12:48 am
No new posts Daily report to be extracted from CA ... polymathtarun DFSORT/ICETOOL 5 Mon Jul 11, 2016 4:33 pm
No new posts Report view in Mobile devices Robert Sample All Other Mainframe Topics 0 Thu Jun 23, 2016 7:05 pm


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