I want to create a report from the file & provide, Maximum, Minimum, Average & Total based on values present in the first 10 characters.
I have used the below DISPLAY statement using ICETOOL
Code:
DISPLAY FROM(INDD01) LIST(SPOOLDD) -
ON(1,10,CH) ON(11,30,CH) ON(41,8,ZD) BREAK(1,10,CH) -
TITLE('SAMPLE TITLE SHOULD BE PROVIDED HERE FOR REF') -
BTITLE('BREAK TITLE PRINTED HERE REF') -
HEADER('PART1 DATA') HEADER('PART 2 DATA') HEADER('PART 3') -
BTOTAL('TOTAL') BMINIMUM('MINIMUM') BMAXIMUM('MAXIMUM') -
BAVERAGE('AVERAGE')
Now, the O/P is printing the BREAK values along with BTITLE.
A section of O/P file is provided below:
Code:
1SAMPLE TITLE SHOULD BE PROVIDED HERE FOR REF
AAAAAAA BREAK TITLE PRINTED HERE REF
PART1 DATA PART 2 DATA PART
-------------------- ------------------------------ ---------------
AAAAAAA 1111111111111111 +00000000000010
AAAAAAA 2222222222222222 +00000000000020
AAAAAAA 1223 +00000000000030
TOTAL +00000000000060
MINIMUM +00000000000010
MAXIMUM +00000000000030
AVERAGE +00000000000020
1SAMPLE TITLE SHOULD BE PROVIDED HERE FOR REF
BBBBBBB BREAK TITLE PRINTED HERE REF
PART1 DATA PART 2 DATA PART
-------------------- ------------------------------ ---------------
BBBBBBB 33333333 +00000000000040
BBBBBBB 5555555555555555 +00000000000050
TOTAL +00000000000090
MINIMUM +00000000000040
MAXIMUM +00000000000050
AVERAGE +00000000000045
1SAMPLE TITLE SHOULD BE PROVIDED HERE FOR REF
CCCCCCCCCC BREAK TITLE PRINTED HERE REF
PART1 DATA PART 2 DATA PART
-------------------- ------------------------------ ---------------
CCCCCCCCCC 66666666666 +00000000000060
TOTAL +00000000000060
MINIMUM +00000000000060
MAXIMUM +00000000000060
AVERAGE +00000000000060
Here you may see that "AAAAAAA" or "BBBBBBB" or "CCCCCCCCCC" is printed before each break title. I want to suppress these values.
Is there a way it can be done using the same DISPLAY statement?
Optional break operands can be used to modify the break title for each section (the break value is always printed as part of the break title)
The designers assumed it should look like this:
Code:
XXXXXXXXX - group description section
FYI: If you are interested, the sectioning of reports is designed differently in SYNCSORT (moderators prohibit mentioning SYNCSORT in DFSORT topics, and vice versa)