February 11, 2010, 07:10 AM
Stefan [SOLVED] ON TABLE SUMMARIZE produces linebreaks
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 , February 17, 2010 05:40 AM February 11, 2010, 12:30 PM
Dan Satchell 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'
February 15, 2010, 02:12 PM
Doug 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
February 17, 2010, 05:36 AM
Stefan Da,
thanks a lot. This works fine, even if I still do not know why ;-)
Regards,
Stefan