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     [SOLVED] ON TABLE SUMMARIZE produces linebreaks
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] ON TABLE SUMMARIZE produces linebreaks
 Login/Join
 
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, 2009Reply With QuoteReport This Post
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, 2007Reply With QuoteReport This Post
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: 3066 | Location: Middle Tennessee [8204M Gen48 in Test&Prod] | Registered: February 23, 2005Reply With QuoteReport This Post
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, 2009Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] ON TABLE SUMMARIZE produces linebreaks

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