[Closed] FORMAT EXL2K : SUBTOTAL line splits on 2 lines (MVS Focus 7.6.11)
Bonjour, The SubTotal Line is not unique but * Total xxx on one line and the totalled columns on Next line. More Over, these Totalled Columns are centered when the Detail Columns are Aligned Right and Title Centered... I'm sure I've Read about this Classic Problem. Something like How to determine size of First columns to avoid the unwilled Break, but no way to refind where ... Cordially and Focusely PS : Edit of the two SubTotal Lines
#3 - Rank: 16 TECHNIQUE: How to display Excel SUBTOTAL on one line. Abstract: How to display Excel SUBTOTAL on one line. The code was generating a SUBTOTAL on two lines instead of one line as desired. To address this issue, use a SUBFOOT instead. _______________
#7 - Rank: 16 TECHNIQUE: Multiple SUBTOTALs are are displayed across 2 lines. Abstract: The SUBTOTAL is being displayed across 2 line -- the literal values on one line and the data value on another. This is complicated by the fact that there is more than one SUBTOTAL.
If this still doesn't help please feel free to open a case with our customer support.
Sincerely,
Kathleen Butler Information Builders
June 27, 2012, 04:36 AM
Baillecl
Thanks for your previse and efficient Help. I don't want to change a SubTotal into a SubFoot because they are not on the same idea ( SubFoot is more powerful and more complicated to code, SubTotal / Recompute are simple and stick to their goal - if less powerful) My point was originated by NOPRINT on the BY Fields => No Place to write SubTotal / Recompute information => 2 Lines. I created an artificial ZON_BIDON/A04 WITH xx = ' '; and Added at the right place a BY ZON_BIDON AS ' , , ' to give place for Subtotal to write what they had to. For those who prefer concease explanations, they'll enjoy Kathleen Butler's message ( I very much thank her for it, by the way) Cordially and Focusely
Focus Mainframe 7.6.11 Dev Studio 7.6.11 and !!! PC Focus, Focus for OS/2, FFW Six, MSO