Tally the number of items in report

cvadlamudi · New User Joined: 19 Apr 2007 Posts: 68 Location: India

Hi,

I have a report with a list of detail lines, which includes Account numbers and Amounts with other information. I have to include the Count of Total number of Account numbers in the report. Each Account number may or may not have duplicates. Similar to Tally is there any other option.

EX:
A/C
000122
000122
000122
000233
000444
000444
000555
000555

The Count should be 4

Thanks in Advance

Thanks,
Mouli.V

anandinmainframe · Active User Joined: 31 May 2007 Posts: 171 Location: India

Mouli,
Can we have the sort as the first step.

Anuj Dhawan · Posted: Mon Mar 23, 2009 3:52 pm

Hi,

This post is in CA-Products part of the forum, so not sure if you can use Sort? If yes, which sort product is in use at your shop?

cvadlamudi · New User Joined: 19 Apr 2007 Posts: 68 Location: India

Yes, but how the Sort will get the count ?

Thanks,
Mouli.V

anandinmainframe · Active User Joined: 31 May 2007 Posts: 171 Location: India

Mouli,
This might be helpful to you.
www.ibmmainframes.com/about19056.html

cvadlamudi · New User Joined: 19 Apr 2007 Posts: 68 Location: India

Hi,

Sort or any other utility is not needed here, Since i am trying to create a report using EZT and have to display the count in the report.

Thanks,
Mouli.V

anandinmainframe · Active User Joined: 31 May 2007 Posts: 171 Location: India

Mouli,
Whether you will have the records in the same order as mentioned in OP i.e) Duplicates followed by the original values. if yes Move the Acc no to a working storage and then compare your Working storage and the input record(Acc no) if they are same then don't increment the value(Working storage for count) for input count if not then increment the value by 1. at last EOF display that working storage.

cvadlamudi · New User Joined: 19 Apr 2007 Posts: 68 Location: India

No, i am looking for an option similar to TALLY