What I have on my table headings: | Thickness | Packed by Shift (m2) |
MONTH Day S1 S2 S3 N Out N Yield M Out M Yield A Out A Yield
11 1 2 2 2 90.9 90.9 90.9 90.9 90.9 90.9
2 2-3 3 90.9 90.9 90.9 90.9 90.9 90.9 90.9
3 4 4 90.9 90.9 90.9 90.9 90.9 90.9
4 4 4-5 90.9 90.9 90.9 90.9 90.9 90.9 90.9
What I need is a just a Main Title on the report: Guardian do Brasil Vidros Planos LTDA - Morning Report WTC 2016 | Thickness | Packed by Shift (m2) |
MONTH Day S1 S2 S3 N Out N Yield M Out M Yield A Out A Yield
11 1 2 2 2 90.9 90.9 90.9 90.9 90.9 90.9
2 2-3 3 90.9 90.9 90.9 90.9 90.9 90.9 90.9
3 4 4 90.9 90.9 90.9 90.9 90.9 90.9
4 4 4-5 90.9 90.9 90.9 90.9 90.9 90.9 90.9
What I got when I use HEADING: | Thickness | Packed by Shift (m2) |
Guardian do Brasil Vidros Planos LTDA - Morning Report WTC 2016 MONTH Day S1 S2 S3 N Out N Yield M Out M Yield A Out A Yield
11 1 2 2 2 90.9 90.9 90.9 90.9 90.9 90.9
2 2-3 3 90.9 90.9 90.9 90.9 90.9 90.9 90.9
3 4 4 90.9 90.9 90.9 90.9 90.9 90.9
4 4 4-5 90.9 90.9 90.9 90.9 90.9 90.9 90.9
How to get what I want? Part of my fex:
TABLE FILE DAILYREPORTDAILYDATAVIEW
SUM DAILYREPORTDAILYDATAVIEW.DAILYREPORTDAILYDATAVIEW.PACKEDSHIFT1/D20.0 AS 'N,Out'
YIELD_SHIFT_N AS 'N,Yield'
DAILYREPORTDAILYDATAVIEW.DAILYREPORTDAILYDATAVIEW.PACKEDSHIFT2/D20.0 AS 'M,Out'
YIELD_SHIFT_M AS 'M,Yield'
DAILYREPORTDAILYDATAVIEW.DAILYREPORTDAILYDATAVIEW.PACKEDSHIFT3/D20.0 AS 'A,Out'
YIELD_SHIFT_A AS 'A,Yield'
TOTAL_PULL AS 'In'
DAILYREPORTDAILYDATAVIEW.DAILYREPORTDAILYDATAVIEW.TOTALPACKED/D20.0 AS 'Out'
TOTAL_YIELD AS 'Yield'
EFFICIENCY AS 'Effic.'
DAILYREPORTDAILYDATAVIEW.DAILYREPORTDAILYDATAVIEW.SHIPPEDTONS1/D20.0 AS 'TT,Bra'
DAILYREPORTDAILYDATAVIEW.DAILYREPORTDAILYDATAVIEW.SHIPPEDTONS2/D20.0 AS 'TT,Oth'
DAILYREPORTDAILYDATAVIEW.DAILYREPORTDAILYDATAVIEW.SHIPPEDTONS3/D20.0 AS 'TT,Tot'
DAILYREPORTDAILYDATAVIEW.DAILYREPORTDAILYDATAVIEW.SHIPPEDTONS4/D20.0 AS 'PR,Bra'
DAILYREPORTDAILYDATAVIEW.DAILYREPORTDAILYDATAVIEW.SHIPPEDTONS6/D20.0 AS 'PR,Tot'
DAILYREPORTDAILYDATAVIEW.DAILYREPORTDAILYDATAVIEW.SHIPPEDTONS7/D20.0 AS 'FO,Bra'
DAILYREPORTDAILYDATAVIEW.DAILYREPORTDAILYDATAVIEW.SHIPPEDTONS9/D20.0 AS 'FO,Tot'
DAILYREPORTDAILYDATAVIEW.DAILYREPORTDAILYDATAVIEW.SHIPPEDTONS10/D20.0 AS 'TOTAL,Bra'
DAILYREPORTDAILYDATAVIEW.DAILYREPORTDAILYDATAVIEW.SHIPPEDTONS11/D20.0 AS 'TOTAL,Oth'
DAILYREPORTDAILYDATAVIEW.DAILYREPORTDAILYDATAVIEW.SHIPPEDTONS12/D20.0 AS 'TOTAL,Tot'
DAILYREPORTDAILYDATAVIEW.DAILYREPORTDAILYDATAVIEW.SHIPPEDTONS13/D20.0 AS 'To PR'
DAILYREPORTDAILYDATAVIEW.DAILYREPORTDAILYDATAVIEW.SHIPPEDTONS14/D20.0 AS 'To FO'
BY DAILYREPORTDAILYDATAVIEW.DAILYREPORTDAILYDATAVIEW.DRYEAR NOPRINT
BY MONTHTOTALS AS 'MONTH'
BY DAILYREPORTDAILYDATAVIEW.DAILYREPORTDAILYDATAVIEW.DRDAY AS 'Day'
BY DAILYREPORTDAILYDATAVIEW.DAILYREPORTDAILYDATAVIEW.THICKNESSSHIFT1 AS 'S1'
BY DAILYREPORTDAILYDATAVIEW.DAILYREPORTDAILYDATAVIEW.THICKNESSSHIFT2 AS 'S2'
BY DAILYREPORTDAILYDATAVIEW.DAILYREPORTDAILYDATAVIEW.THICKNESSSHIFT3 AS 'S3'
WHERE (DAILYREPORTDAILYDATAVIEW.DAILYREPORTDAILYDATAVIEW.DRMONTH EQ &DRMONTH.(FIND DAILYREPORTDAILYDATAVIEW.DAILYREPORTDAILYDATAVIEW.DRMONTH IN DAILYREPORTDAILYDATAVIEW).Month:.) AND (DAILYREPORTDAILYDATAVIEW.DAILYREPORTDAILYDATAVIEW.DRYEAR EQ &DRYEAR.(FIND DAILYREPORTDAILYDATAVIEW.DAILYREPORTDAILYDATAVIEW.DRYEAR IN DAILYREPORTDAILYDATAVIEW).Year:.) AND (DAILYREPORTDAILYDATAVIEW.DAILYREPORTDAILYDATAVIEW.DRPLANT EQ 'G. Tatui');
HEADING
"Guardian do Brasil Vidros Planos LTDA - Morning Report WTC 2016"
ON TABLE SUBHEAD
" <+0> <+0>Thickness<+0>Packed by Shift (m2)<+0>Daily Production (m2)<+0>Sales by Plant / Country (m2)<+0>Transfer (m2)<+0>"
ON TABLE SET STYLE *
-INCLUDE IBFS:/CFG/FILE/IBI_HTML_DIR/javaassist/intl/EN/ENDefaultTableStyle.sty
TYPE=TABHEADING,HEADALIGN=BODY,$
TYPE=TABHEADING, LINE=1, ITEM=1, COLSPAN=1,JUSTIFY=CENTER,$
TYPE=TABHEADING, LINE=1, ITEM=2, COLSPAN=1,JUSTIFY=CENTER,$
TYPE=TABHEADING, LINE=1, ITEM=3, COLSPAN=3,JUSTIFY=CENTER,$
TYPE=TABHEADING, LINE=1, ITEM=4, COLSPAN=6,JUSTIFY=CENTER,$
TYPE=TABHEADING, LINE=1, ITEM=5, COLSPAN=11,JUSTIFY=CENTER,$
TYPE=TABHEADING, LINE=1, ITEM=6, COLSPAN=3,JUSTIFY=CENTER,$
TYPE=TABHEADING, LINE=1, ITEM=7, COLSPAN=2,JUSTIFY=CENTER,$
TYPE=TABHEADING, BACKCOLOR = rgb(147 172 219)
TYPE=TABHEADING, COLOR = rgb(255 255 255)
TYPE=REPORT,
FONT='ARIAL',
SIZE=9,
GRID=ON,
$
TYPE=DATA, COLUMN=MONTHTOTALS,
JUSTIFY=RIGHT,
$
TYPE=TITLE, COLUMN=MONTHTOTALS,
JUSTIFY=RIGHT,
$
TYPE=TITLE,
STYLE=-UNDERLINE,
$
DEFMACRO=COND0001, MACTYPE=RULE, WHEN=DAILYREPORTDAILYDATAVIEW.DAILYREPORTDAILYDATAVIEW.DRDAY GT 31, $
TYPE=DATA, MACRO=COND0001, COLUMN=DAILYREPORTDAILYDATAVIEW.DAILYREPORTDAILYDATAVIEW.DRDAY,
COLOR=rgb(234 234 255),
BACKCOLOR=rgb(234 234 255),
$
TYPE=TITLE, COLUMN=DAILYREPORTDAILYDATAVIEW.DAILYREPORTDAILYDATAVIEW.THICKNESSSHIFT1, BACKCOLOR=rgb(168 207 255), $
TYPE=DATA, COLUMN=DAILYREPORTDAILYDATAVIEW.DAILYREPORTDAILYDATAVIEW.THICKNESSSHIFT1, BACKCOLOR=rgb(209 235 255), $
TYPE=TITLE, COLUMN=DAILYREPORTDAILYDATAVIEW.DAILYREPORTDAILYDATAVIEW.THICKNESSSHIFT2, BACKCOLOR=rgb(168 207 255), $
TYPE=DATA, COLUMN=DAILYREPORTDAILYDATAVIEW.DAILYREPORTDAILYDATAVIEW.THICKNESSSHIFT2, BACKCOLOR=rgb(209 235 255), $
TYPE=TITLE, COLUMN=DAILYREPORTDAILYDATAVIEW.DAILYREPORTDAILYDATAVIEW.THICKNESSSHIFT3, BACKCOLOR=rgb(168 207 255), $
TYPE=DATA, COLUMN=DAILYREPORTDAILYDATAVIEW.DAILYREPORTDAILYDATAVIEW.THICKNESSSHIFT3, BACKCOLOR=rgb(209 235 255), $
TYPE=TITLE, COLUMN=TOTAL_PULL, BACKCOLOR=rgb(168 207 255), $
TYPE=DATA, COLUMN=TOTAL_PULL, BACKCOLOR=rgb(209 235 255), $
TYPE=TITLE, COLUMN=DAILYREPORTDAILYDATAVIEW.DAILYREPORTDAILYDATAVIEW.TOTALPACKED, BACKCOLOR=rgb(168 207 255), $
TYPE=DATA, COLUMN=DAILYREPORTDAILYDATAVIEW.DAILYREPORTDAILYDATAVIEW.TOTALPACKED, BACKCOLOR=rgb(209 235 255), $
TYPE=TITLE, COLUMN=TOTAL_YIELD, BACKCOLOR=rgb(168 207 255), $
TYPE=DATA, COLUMN=TOTAL_YIELD, BACKCOLOR=rgb(209 235 255), $
TYPE=TITLE, COLUMN=EFFICIENCY, BACKCOLOR=rgb(168 207 255), $
TYPE=DATA, COLUMN=EFFICIENCY, BACKCOLOR=rgb(209 235 255), $
TYPE=TITLE, COLUMN=DAILYREPORTDAILYDATAVIEW.DAILYREPORTDAILYDATAVIEW.SHIPPEDTONS1, BACKCOLOR=rgb(168 207 255), $
TYPE=DATA, COLUMN=DAILYREPORTDAILYDATAVIEW.DAILYREPORTDAILYDATAVIEW.SHIPPEDTONS1, BACKCOLOR=rgb(209 235 255), $
TYPE=TITLE, COLUMN=DAILYREPORTDAILYDATAVIEW.DAILYREPORTDAILYDATAVIEW.SHIPPEDTONS2, BACKCOLOR=rgb(168 207 255), $
TYPE=DATA, COLUMN=DAILYREPORTDAILYDATAVIEW.DAILYREPORTDAILYDATAVIEW.SHIPPEDTONS2, BACKCOLOR=rgb(209 235 255), $
TYPE=TITLE, COLUMN=DAILYREPORTDAILYDATAVIEW.DAILYREPORTDAILYDATAVIEW.SHIPPEDTONS3, BACKCOLOR=rgb(168 207 255), $
TYPE=DATA, COLUMN=DAILYREPORTDAILYDATAVIEW.DAILYREPORTDAILYDATAVIEW.SHIPPEDTONS3, BACKCOLOR=rgb(209 235 255), $
TYPE=TITLE, COLUMN=DAILYREPORTDAILYDATAVIEW.DAILYREPORTDAILYDATAVIEW.SHIPPEDTONS4, BACKCOLOR=rgb(168 207 255), $
TYPE=DATA, COLUMN=DAILYREPORTDAILYDATAVIEW.DAILYREPORTDAILYDATAVIEW.SHIPPEDTONS4, BACKCOLOR=rgb(209 235 255), $
TYPE=TITLE, COLUMN=DAILYREPORTDAILYDATAVIEW.DAILYREPORTDAILYDATAVIEW.SHIPPEDTONS6, BACKCOLOR=rgb(168 207 255), $
TYPE=DATA, COLUMN=DAILYREPORTDAILYDATAVIEW.DAILYREPORTDAILYDATAVIEW.SHIPPEDTONS6, BACKCOLOR=rgb(209 235 255), $
TYPE=TITLE, COLUMN=DAILYREPORTDAILYDATAVIEW.DAILYREPORTDAILYDATAVIEW.SHIPPEDTONS7, BACKCOLOR=rgb(168 207 255), $
TYPE=DATA, COLUMN=DAILYREPORTDAILYDATAVIEW.DAILYREPORTDAILYDATAVIEW.SHIPPEDTONS7, BACKCOLOR=rgb(209 235 255), $
TYPE=TITLE, COLUMN=DAILYREPORTDAILYDATAVIEW.DAILYREPORTDAILYDATAVIEW.SHIPPEDTONS9, BACKCOLOR=rgb(168 207 255), $
TYPE=DATA, COLUMN=DAILYREPORTDAILYDATAVIEW.DAILYREPORTDAILYDATAVIEW.SHIPPEDTONS9, BACKCOLOR=rgb(209 235 255), $
TYPE=TITLE, COLUMN=DAILYREPORTDAILYDATAVIEW.DAILYREPORTDAILYDATAVIEW.SHIPPEDTONS13, BACKCOLOR=rgb(168 207 255), $
TYPE=DATA, COLUMN=DAILYREPORTDAILYDATAVIEW.DAILYREPORTDAILYDATAVIEW.SHIPPEDTONS13, BACKCOLOR=rgb(209 235 255), $
TYPE=TITLE, COLUMN=DAILYREPORTDAILYDATAVIEW.DAILYREPORTDAILYDATAVIEW.SHIPPEDTONS14, BACKCOLOR=rgb(168 207 255), $
TYPE=DATA, COLUMN=DAILYREPORTDAILYDATAVIEW.DAILYREPORTDAILYDATAVIEW.SHIPPEDTONS14, BACKCOLOR=rgb(209 235 255), $
ENDSTYLE
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET HTMLCSS OFF
ON TABLE SET STYLEMODE FULL
ON TABLE NOTOTAL
ON TABLE SET HTMLENCODE ON
END
-* End Report Assistant
This message has been edited. Last edited by: <Emily McAllister>, December 04, 2016 08:49 PM WF 7703, Windows 2003 Server