Focal Point
[Closed] FORMAT EXL2K : SUBTOTAL line splits on 2 lines (MVS Focus 7.6.11)

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/1137017026

May 30, 2012, 05:59 AM
Baillecl
[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
 <TR>
<TD style='white-space:nowrap' class=xl75>*  Total 12448</TD>
[COLOR:RED]</TR>
<TR>[/COLOR]
<TD style='white-space:nowrap' class=xl69> </TD>
<TD style='white-space:nowrap' class=xl70> </TD>
<TD style='white-space:nowrap' class=xl71> </TD>
<TD style='white-space:nowrap' class=xl72> </TD>
<TD style='white-space:nowrap' class=xl73> </TD>
<TD style='white-space:nowrap' class=xl74> </TD>
<TD style='white-space:nowrap' class=xl75> </TD>
<TD style='white-space:nowrap' X:NUM class=xl76P8C>72</TD>
<TD style='white-space:nowrap' X:NUM class=xl77P17_2C>149,846.66</TD>
<TD style='white-space:nowrap' X:NUM class=xl78P8C>62</TD>
<TD style='white-space:nowrap' X:NUM class=xl79P17_2C>51,417.44</TD>
<TD style='white-space:nowrap' X:NUM class=xl80P8C>10</TD>
<TD style='white-space:nowrap' X:NUM class=xl81P17_2C>98,429.22</TD>
<TD style='white-space:nowrap' X:NUM class=xl82P8C>10</TD>
<TD style='white-space:nowrap' X:NUM class=xl83P17_2C>98,429.22</TD>
<TD style='white-space:nowrap' X:NUM class=xl84P8C>0</TD>
<TD style='white-space:nowrap' X:NUM class=xl85P17_2C>.00</TD> 

And Class xl76P8C, for example, is centered
xl76P8C
        {mso-style-parent:style0;
        color:#000000;
        font-size:10.0pt;
        font-family:"ARIAL";
        [COLOR:RED]text-align:center[/COLOR];
        mso-number-format:"\#\,\#\#\#0";
        white-space:nowrap;
 border-style: NONE;
        mso-font-charset:0;}

This message has been edited. Last edited by: Kathleen Butler,


Focus Mainframe 7.6.11
Dev Studio 7.6.11 and !!!
PC Focus, Focus for OS/2, FFW Six, MSO
June 20, 2012, 03:04 PM
Kathleen Butler
Hi Bailleci,

I checked with our Information Builders Technical Staff and they provided the following resources:

#1 - Rank: 32
TECHNIQUE: How to Show/Hide Subtitles for SubHeadings or SubFootings Abstract: How to Show/Hide Subtitles for SubHeadings or SubFootings for Active Reports. Show/Hide Subtitles appears when there is a subtotal in the Active Report Request.
To remove Subtitles from the Active report menu, remove the...
_______________
#2 - Rank:32
TROUBLESHOOTING: Unable to line up SubTotals and Totals within EXL2K.
Abstract: Totals and SubTotals are getting generated on two lines. Unable to line up SubTotals and Totals within EXL2K. This issue is caused by first using a Multiveb Request and a NOPRINT on.
_______________

#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.
_______________

#4 - Rank: 16
TECHNIQUE: How to have RECOMPUTE SUBTOTAL appear on one line.Abstract: When inserting a COLUMN-TOTAL or RECOMPUTE SUBTOTAL to a procedure, the total line renders on two lines instead of one line.
_______________

#5 - Rank: 16
TROUBLESHOOTING: "Eyecatcher does not match" with JOIN that can't be cleared Abstract: A particular FOCEXEC was causing agents to crash. The problem was narrowed down to a DEFINE that was done while a required multi-table JOIN was in effect.

_______________

#6 - Rank: 16
TROUBLESHOOTING: Cannot have 2 different colored Subtotal lines Abstract: How to change the colors on two different Subtotals. TABLE FILE CAR PRINT DEALER_COST.

_______________

#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.

_______________

#8 - Rank: 16
TECHNIQUE: How to get TOTAL and value on same line when NOPRINT is used

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