Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [Closed] FORMAT EXL2K : SUBTOTAL line splits on 2 lines (MVS Focus 7.6.11)
Go
New
Search
Notify
Tools
Reply
  
[Closed] FORMAT EXL2K : SUBTOTAL line splits on 2 lines (MVS Focus 7.6.11)
 Login/Join
 
Platinum Member
posted
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
 
Posts: 134 | Registered: November 06, 2007Reply With QuoteReport This Post
Master
posted Hide Post
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
 
Posts: 429 | Location: New York | Registered: September 20, 2006Reply With QuoteReport This Post
Platinum Member
posted Hide Post
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
 
Posts: 134 | Registered: November 06, 2007Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [Closed] FORMAT EXL2K : SUBTOTAL line splits on 2 lines (MVS Focus 7.6.11)

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.