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     [SOLVED] ON TABLE SUMMARIZE produces linebreaks

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] ON TABLE SUMMARIZE produces linebreaks
 Login/Join
 
Stefan
Gold member
posted
Hi there,

I got my code:

 
DEFINE FILE myFile
myMeasure2/D6=myMeasure;
END

TABLE FILE myFile
SUM
	AVE.myMeasure2 NOPRINT
BY myMonth NOPRINT

SUM
	myMeasure AS 'Measure'
BY myMonth NOPRINT
BY myMonthDisplay  AS 'Month'
ACROSS mySort
ACROSS mySortNAme  AS ''
COMPUTE 'Average'/D6=AVE.myMeasure2;

ON TABLE SUMMARIZE AVE.

ON TABLE SET PAGE-NUM NOLEAD

ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     UNITS=CM,
     LEFTMARGIN=0.000000,
     TOPMARGIN=2.469136,
     SQUEEZE=ON,
     ORIENTATION=LANDSCAPE,
$
TYPE=REPORT,
     BORDER-TOP=LIGHT,
     BORDER-BOTTOM=LIGHT,
     BORDER-LEFT=LIGHT,
     BORDER-RIGHT=LIGHT,
     BORDER-COLOR=RGB(148 142 165),
     FONT='ARIAL',
     SIZE=8,
$
TYPE=TITLE,
     COLOR='WHITE',
     BACKCOLOR=RGB(0 90 148),
     STYLE=BOLD,
$
TYPE=HEADING,
     LINE=1,
     OBJECT=TEXT,
     ITEM=1,
     STYLE=NORMAL,
$
TYPE=ACROSSTITLE,
     STYLE=BOLD,
$
TYPE=ACROSSVALUE,
     SIZE=9,
$
TYPE=GRANDTOTAL,
     BACKCOLOR=RGB(210 210 210),
     STYLE=BOLD,
$
TYPE=REPORT,
     COLUMN=N1,
$
ENDSTYLE
END


The result is like this

 
TABLE { border-collapse:collapse; }
TD { vertical-align:top; padding-left:6pt; padding-right:6pt; }
.x10 { font-family:ARIAL; font-size:8pt;
 border-top: 1.00pt SOLID #948EA5; border-bottom: NONE; border-right: NONE; border-left: NONE; }
.x6 { font-family:ARIAL; font-size:8pt;
 border-top: 1.00pt SOLID #948EA5; border-bottom: NONE; border-right: NONE; border-left: 1.00pt SOLID #948EA5; }
.x7 { font-family:ARIAL; font-size:8pt;
 border-top: 1.00pt SOLID #948EA5; border-bottom: NONE; border-right: 1.00pt SOLID #948EA5; border-left: 1.00pt SOLID #948EA5; }
.x4 { font-family:ARIAL; font-size:8pt; font-weight:bold; color:#FFFFFF; background-color:#005A94;
 border-top: 1.00pt SOLID #948EA5; border-bottom: NONE; border-right: NONE; border-left: 1.00pt SOLID #948EA5; }
.x5 { font-family:ARIAL; font-size:8pt; font-weight:bold; color:#FFFFFF; background-color:#005A94;
 border-top: 1.00pt SOLID #948EA5; border-bottom: NONE; border-right: 1.00pt SOLID #948EA5; border-left: 1.00pt SOLID #948EA5; }
.x2 { font-family:ARIAL; font-size:9pt;
 border-top: 1.00pt SOLID #948EA5; border-bottom: NONE; border-right: NONE; border-left: 1.00pt SOLID #948EA5; }
.x3 { font-family:ARIAL; font-size:9pt;
 border-top: 1.00pt SOLID #948EA5; border-bottom: NONE; border-right: 1.00pt SOLID #948EA5; border-left: 1.00pt SOLID #948EA5; }
.x1 { font-family:ARIAL; font-size:8pt; font-weight:bold;
 border-top: 1.00pt SOLID #948EA5; border-bottom: NONE; border-right: 1.00pt SOLID #948EA5; border-left: 1.00pt SOLID #948EA5; }
.x8 { font-family:ARIAL; font-size:8pt; font-weight:bold; background-color:#D2D2D2;
 border-top: 1.00pt SOLID #948EA5; border-bottom: NONE; border-right: NONE; border-left: 1.00pt SOLID #948EA5; }
.x9 { font-family:ARIAL; font-size:8pt; font-weight:bold; background-color:#D2D2D2;
 border-top: 1.00pt SOLID #948EA5; border-bottom: NONE; border-right: 1.00pt SOLID #948EA5; border-left: 1.00pt SOLID #948EA5; }
-->
</STYLE>
</HEAD>
<BODY>
<TABLE CELLPADDING=1 style='margin-left:0pt;margin-right:18pt;margin-top:70pt;margin-bottom:18pt'>
<TR>
<TD></TD>
<TD COLSPAN=6 class='x1'>mySort</TD>
</TR>
<TR>
<TD></TD>
<TD class='x2'>015</TD>
<TD class='x2'>020</TD>
<TD class='x2'>025</TD>
<TD class='x2'>030</TD>
<TD class='x3'>040</TD>
<TD class='x3'>066</TD>
</TR>
<TR>
<TD></TD>
<TD class='x2'>A</TD>
<TD class='x2'>B</TD>
<TD class='x2'>C</TD>
<TD class='x2'>D</TD>
<TD class='x3'>E</TD>
<TD class='x3'>F</TD>
<TD class='x3'>Month</TD>
</TR>
<TR>
<TD style="vertical-align:bottom" class='x4'>Monat</TD>
<TD ALIGN=RIGHT style="vertical-align:bottom" class='x4'>Measure</TD>
<TD ALIGN=RIGHT style="vertical-align:bottom" class='x4'>Measure</TD>
<TD ALIGN=RIGHT style="vertical-align:bottom" class='x4'>Measure</TD>
<TD ALIGN=RIGHT style="vertical-align:bottom" class='x4'>Measure</TD>
<TD ALIGN=RIGHT style="vertical-align:bottom" class='x4'>Measure</TD>
<TD ALIGN=RIGHT style="vertical-align:bottom" class='x4'>Measure</TD>
<TD style="vertical-align:bottom" class='x5'></TD>
</TR>
<TR>
<TD class='x6'>JAN 2009</TD>
<TD ALIGN=RIGHT class='x6'>179</TD>
<TD ALIGN=RIGHT class='x6'>237</TD>
<TD ALIGN=RIGHT class='x6'>377</TD>
<TD ALIGN=RIGHT class='x6'>334</TD>
<TD ALIGN=RIGHT class='x6'>309</TD>
<TD ALIGN=RIGHT class='x6'>298</TD>
<TD ALIGN=RIGHT class='x7'>289</TD>
</TR>
<TR>
<TD class='x6'>FEB 2009</TD>
<TD ALIGN=RIGHT class='x6'>284</TD>
<TD ALIGN=RIGHT class='x6'>176</TD>
<TD ALIGN=RIGHT class='x6'>395</TD>
<TD ALIGN=RIGHT class='x6'>290</TD>
<TD ALIGN=RIGHT class='x6'>208</TD>
<TD ALIGN=RIGHT class='x6'>297</TD>
<TD ALIGN=RIGHT class='x7'>275</TD>
</TR>
<TR>
<TD class='x6'>MAR 2009</TD>
<TD ALIGN=RIGHT class='x6'>144</TD>
<TD ALIGN=RIGHT class='x6'>245</TD>
<TD ALIGN=RIGHT class='x6'>314</TD>
<TD ALIGN=RIGHT class='x6'>290</TD>
<TD ALIGN=RIGHT class='x6'>232</TD>
<TD ALIGN=RIGHT class='x6'>220</TD>
<TD ALIGN=RIGHT class='x7'>241</TD>
</TR>
<TR>
<TD class='x6'>APR 2009</TD>
<TD ALIGN=RIGHT class='x6'>123</TD>
<TD ALIGN=RIGHT class='x6'>194</TD>
<TD ALIGN=RIGHT class='x6'>319</TD>
<TD ALIGN=RIGHT class='x6'>252</TD>
<TD ALIGN=RIGHT class='x6'>139</TD>
<TD ALIGN=RIGHT class='x6'>207</TD>
<TD ALIGN=RIGHT class='x7'>206</TD>
</TR>
<TR>
<TD class='x6'>MAI 2009</TD>
<TD ALIGN=RIGHT class='x6'>113</TD>
<TD ALIGN=RIGHT class='x6'>148</TD>
<TD ALIGN=RIGHT class='x6'>304</TD>
<TD ALIGN=RIGHT class='x6'>203</TD>
<TD ALIGN=RIGHT class='x6'>193</TD>
<TD ALIGN=RIGHT class='x6'>160</TD>
<TD ALIGN=RIGHT class='x7'>187</TD>
</TR>
<TR>
<TD class='x6'>JUN 2009</TD>
<TD ALIGN=RIGHT class='x6'>97</TD>
<TD ALIGN=RIGHT class='x6'>185</TD>
<TD ALIGN=RIGHT class='x6'>283</TD>
<TD ALIGN=RIGHT class='x6'>217</TD>
<TD ALIGN=RIGHT class='x6'>182</TD>
<TD ALIGN=RIGHT class='x6'>228</TD>
<TD ALIGN=RIGHT class='x7'>199</TD>
</TR>
<TR>
<TD class='x6'>JUL 2009</TD>
<TD ALIGN=RIGHT class='x6'>184</TD>
<TD ALIGN=RIGHT class='x6'>147</TD>
<TD ALIGN=RIGHT class='x6'>392</TD>
<TD ALIGN=RIGHT class='x6'>196</TD>
<TD ALIGN=RIGHT class='x6'>186</TD>
<TD ALIGN=RIGHT class='x6'>271</TD>
<TD ALIGN=RIGHT class='x7'>229</TD>
</TR>
<TR>
<TD class='x6'>AUG 2009</TD>
<TD ALIGN=RIGHT class='x6'>156</TD>
<TD ALIGN=RIGHT class='x6'>155</TD>
<TD ALIGN=RIGHT class='x6'>312</TD>
<TD ALIGN=RIGHT class='x6'>189</TD>
<TD ALIGN=RIGHT class='x6'>169</TD>
<TD ALIGN=RIGHT class='x6'>131</TD>
<TD ALIGN=RIGHT class='x7'>185</TD>
</TR>
<TR>
<TD class='x6'>SEP 2009</TD>
<TD ALIGN=RIGHT class='x6'>130</TD>
<TD ALIGN=RIGHT class='x6'>177</TD>
<TD ALIGN=RIGHT class='x6'>283</TD>
<TD ALIGN=RIGHT class='x6'>319</TD>
<TD ALIGN=RIGHT class='x6'>286</TD>
<TD ALIGN=RIGHT class='x6'>235</TD>
<TD ALIGN=RIGHT class='x7'>238</TD>
</TR>
<TR>
<TD class='x6'>OKT 2009</TD>
<TD ALIGN=RIGHT class='x6'>276</TD>
<TD ALIGN=RIGHT class='x6'>238</TD>
<TD ALIGN=RIGHT class='x6'>340</TD>
<TD ALIGN=RIGHT class='x6'>283</TD>
<TD ALIGN=RIGHT class='x6'>295</TD>
<TD ALIGN=RIGHT class='x6'>204</TD>
<TD ALIGN=RIGHT class='x7'>273</TD>
</TR>
<TR>
<TD class='x6'>NOV 2009</TD>
<TD ALIGN=RIGHT class='x6'>141</TD>
<TD ALIGN=RIGHT class='x6'>178</TD>
<TD ALIGN=RIGHT class='x6'>402</TD>
<TD ALIGN=RIGHT class='x6'>260</TD>
<TD ALIGN=RIGHT class='x6'>257</TD>
<TD ALIGN=RIGHT class='x6'>185</TD>
<TD ALIGN=RIGHT class='x7'>237</TD>
</TR>
<TR>
<TD class='x6'>DEZ 2009</TD>
<TD ALIGN=RIGHT class='x6'>128</TD>
<TD ALIGN=RIGHT class='x6'>257</TD>
<TD ALIGN=RIGHT class='x6'>361</TD>
<TD ALIGN=RIGHT class='x6'>221</TD>
<TD ALIGN=RIGHT class='x6'>223</TD>
<TD ALIGN=RIGHT class='x6'>204</TD>
<TD ALIGN=RIGHT class='x7'>232</TD>
</TR>
<TR>
<TD class='x6'>JAN 2010</TD>
<TD ALIGN=RIGHT class='x6'>257</TD>
<TD ALIGN=RIGHT class='x6'>192</TD>
<TD ALIGN=RIGHT class='x6'>336</TD>
<TD ALIGN=RIGHT class='x6'>231</TD>
<TD ALIGN=RIGHT class='x6'>254</TD>
<TD ALIGN=RIGHT class='x6'>327</TD>
<TD ALIGN=RIGHT class='x7'>266</TD>
</TR>
<TR>
<TD class='x9'>TOTAL</TD>
</TR>
<TR>
<TD class='x8'> </TD>
<TD ALIGN=RIGHT class='x8'>170</TD>
<TD ALIGN=RIGHT class='x8'>194</TD>
<TD ALIGN=RIGHT class='x8'>339</TD>
<TD ALIGN=RIGHT class='x8'>252</TD>
<TD ALIGN=RIGHT class='x8'>225</TD>
<TD ALIGN=RIGHT class='x8'>228</TD>
<TD ALIGN=RIGHT class='x9'>235</TD>
</TR>
<TR>
<TD  class='x10'> </TD>
<TD  class='x10'> </TD>
<TD  class='x10'> </TD>
<TD  class='x10'> </TD>
<TD  class='x10'> </TD>
<TD  class='x10'> </TD>
<TD  class='x10'> </TD>
<TD  class='x10'> </TD>
</TR>


My problem is that my code produces three table rows (
TR
), I just want the totals on one single row.

This message has been edited. Last edited by: Stefan,


WF 7.6.9
PMF 5.1.3
BID 7.6.9

Win XP
HTML, PDF, Excel, PowerPoint
 
Posts: 69 | Location: Germany | Registered: September 21, 2009Report This Post
Dan Satchell
Virtuoso
posted Hide Post
Try using the exact same BY phrases in both parts of your multi-verb request:

TABLE FILE myFile
 SUM AVE.myMeasure2 NOPRINT
 BY myMonth NOPRINT
 BY myMonthDisplay  AS 'Month'   <-- I added this

 SUM myMeasure AS 'Measure'
 BY myMonth NOPRINT
 BY myMonthDisplay  AS 'Month'
 ACROSS mySort
 ACROSS mySortNAme  AS ''
 COMPUTE 'Average'/D6=AVE.myMeasure2;

 ON TABLE SUMMARIZE AVE.
 .
 .


Also... I don't know the audience for this report, but personally I wouldn't allow WebFOCUS to default the label for SUMMARIZE AVE. to "TOTAL". I would change it to something like "Average" to avoid any misunderstanding about the values in that row:

 ON TABLE SUMMARIZE AVE. AS 'Average'


WebFOCUS 7.7.05
 
Posts: 1213 | Location: Seattle, Washington - USA | Registered: October 22, 2007Report This Post
Doug
Expert
posted Hide Post
has this been resolved? If so, mark it as such. If not: can you duplicate the issue with the CAR file, or another IB sample file so that we can see the issue and resolve it for you?

Thanks,
Doug
 
Posts: 3132 | Location: Tennessee, Nashville area | Registered: February 23, 2005Report This Post
Stefan
Gold member
posted Hide Post
Da,

thanks a lot. This works fine, even if I still do not know why ;-)

Regards,

Stefan
 
Posts: 69 | Location: Germany | Registered: September 21, 2009Report 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     [SOLVED] ON TABLE SUMMARIZE produces linebreaks

Copyright © 1996-2020 Information Builders