Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


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)

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[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, 2007Report 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: 391 | Location: New York | Registered: September 20, 2006Report 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, 2007Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

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-2020 Information Builders