Kalan
Member
Greetings,
I am having a problem using "break by" feature to consolidate 9 columns on the report. My code is similar to below template,
FOR EACH < Table Name> Break by Col1 by Col2 by Col3 by Col4 by Col5 by Col6 by Col7 By Col8 by Col9:
IF First-of(Col1) AND ....First-of(Col9) THEN DO:
Initialize variables.
END.
Calculation part.
IF Last-of(Col1) AND ....Last-of(Col9) THEN DO:
Printing the report row.
END.
The problem here, Grouping works mainly to column specified with BREAK BY keyword, rest of the 8 columns not effective on grouping. i.e. Its not recognizing the distinct value appears in Col8, incorrectly it combines with non-identical column values. Is there any limitation on using Break by option for multiple fields? Could someone pls suggest the correct approach for the above example? - Thanks.
I am having a problem using "break by" feature to consolidate 9 columns on the report. My code is similar to below template,
FOR EACH < Table Name> Break by Col1 by Col2 by Col3 by Col4 by Col5 by Col6 by Col7 By Col8 by Col9:
IF First-of(Col1) AND ....First-of(Col9) THEN DO:
Initialize variables.
END.
Calculation part.
IF Last-of(Col1) AND ....Last-of(Col9) THEN DO:
Printing the report row.
END.
The problem here, Grouping works mainly to column specified with BREAK BY keyword, rest of the 8 columns not effective on grouping. i.e. Its not recognizing the distinct value appears in Col8, incorrectly it combines with non-identical column values. Is there any limitation on using Break by option for multiple fields? Could someone pls suggest the correct approach for the above example? - Thanks.