-SET &ECHO=ALL; -SET &WFFMT='HTML'; -*-SET &WFFMT='EXL2K'; SET PAGE=NOLEAD SET HTMLCSS=ON SET BYDISPLAY=ON DEFINE FILE CAR COL_FLAG/A1 = IF COUNTRY EQ 'ITALY' THEN 'Y' ELSE 'N'; END TABLE FILE CAR SUM WARRANTY STANDARD HEIGHT AS 'A LONG COLUMN TITLE FOR HEIGHT' WEIGHT AS 'A LONG COLUMN TITLE FOR WEIGHT' LENGTH AS 'A LONG COLUMN TITLE FOR LENGTH' WIDTH SALES FUEL_CAP AS 'FUEL CAP' BHP AS 'BRUTE HORSEPOWER' COL_FLAG BY COUNTRY AS 'COUNTRY' BY CAR AS 'CAR' ON TABLE SET STYLE * TYPE=DATA, BACKCOLOR=(WHITE SILVER), $ TYPE=DATA, COLOR=RED, WHEN=COL_FLAG EQ 'Y', $ TYPE=REPORT, COLUMN=COUNTRY, WRAP=OFF, $ TYPE=REPORT, COLUMN=WARRANTY, WRAP=OFF, $ TYPE=REPORT, COLUMN=WEIGHT, WRAP=80, $ TYPE=REPORT, COLUMN=HEIGHT, WRAP=80, $ TYPE=REPORT, COLUMN=LENGTH, WRAP=80, $ ENDSTYLE ON TABLE PCHOLD FORMAT &WFFMT ENDThis message has been edited. Last edited by: Francis Mariani,
TYPE=DATA, BACKCOLOR=(WHITE SILVER), $
In FOCUS since 1986 | WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2 | ||
WebFOCUS App Studio 8.2.06 standalone on Windows 10 |
-SET &ECHO=ALL; -SET &WFFMT='HTML'; -*-SET &WFFMT='EXL2K'; SET PAGE=NOLEAD SET HTMLCSS=ON SET BYDISPLAY=ON DEFINE FILE CAR COL_FLAG/A1 = IF COUNTRY EQ 'ITALY' THEN 'Y' ELSE 'N'; END TABLE FILE CAR SUM WARRANTY STANDARD HEIGHT AS 'A LONG COLUMN TITLE FOR HEIGHT' WEIGHT AS 'A LONG COLUMN TITLE FOR WEIGHT' LENGTH AS 'A LONG COLUMN TITLE FOR LENGTH' WIDTH SALES FUEL_CAP AS 'FUEL CAP' BHP AS 'BRUTE HORSEPOWER' COL_FLAG BY COUNTRY AS 'COUNTRY' BY CAR AS 'CAR' ON TABLE SET STYLE * TYPE=DATA, BACKCOLOR=(WHITE SILVER), $ TYPE=DATA, COLOR=RED, WHEN=COL_FLAG EQ 'Y', $ TYPE=DATA, COLUMN=COUNTRY, COLOR=RED, WHEN=COL_FLAG EQ 'Y', $ TYPE=DATA, COLUMN=WARRANTY, COLOR=RED, WHEN=COL_FLAG EQ 'Y', $ TYPE=DATA, COLUMN=HEIGHT, COLOR=RED, WHEN=COL_FLAG EQ 'Y', $ TYPE=DATA, COLUMN=WEIGHT, COLOR=RED, WHEN=COL_FLAG EQ 'Y', $ TYPE=DATA, COLUMN=LENGTH, COLOR=RED, WHEN=COL_FLAG EQ 'Y', $ TYPE=REPORT, COLUMN=COUNTRY, WRAP=OFF, $ TYPE=REPORT, COLUMN=WARRANTY, WRAP=OFF, $ TYPE=REPORT, COLUMN=WEIGHT, WRAP=80, $ TYPE=REPORT, COLUMN=HEIGHT, WRAP=80, $ TYPE=REPORT, COLUMN=LENGTH, WRAP=80, $ ENDSTYLE ON TABLE PCHOLD FORMAT &WFFMT END
$ TYPE=REPORT, COLUMN=NAME, WRAP=3.00000, $ TYPE = DATA, BACKCOLOR = RGB(215 235 194), WHEN = FLAG EQ 1,$ TYPE = DATA, BACKCOLOR = RGB(255 255 255), WHEN = FLAG EQ 2,$
$ TYPE=DATA, COLUMN=NAME, WRAP=3.00000, $ TYPE = DATA, BACKCOLOR = RGB(215 235 194), WHEN = FLAG EQ 1,$ TYPE = DATA, BACKCOLOR = RGB(255 255 255), WHEN = FLAG EQ 2,$
$ $ TYPE=REPORT, COLUMN=NAME, WRAP=3.00000, BACKCOLOR = RGB(215 235 194), WHEN = FLAG EQ 1,$ $ TYPE=REPORT, COLUMN=NAME, WRAP=3.00000, BACKCOLOR = RGB(255 255 255), WHEN = FLAG EQ 2, $ TYPE = DATA, BACKCOLOR = RGB(215 235 194), WHEN = FLAG EQ 1,$ TYPE = DATA, BACKCOLOR = RGB(255 255 255), WHEN = FLAG EQ 2,$
$ TYPE = DATA, BACKCOLOR = RGB(215 235 194), WHEN = FLAG EQ 1,$ TYPE = DATA, BACKCOLOR = RGB(255 255 255), WHEN = FLAG EQ 2,$ TYPE=REPORT, COLUMN=NAME, WRAP=3.00000, BACKCOLOR = RGB(215 235 194), WHEN = FLAG EQ 1,$ $ TYPE=REPORT, COLUMN=NAME, WRAP=3.00000, BACKCOLOR = RGB(255 255 255), WHEN = FLAG EQ 2, $
$ TYPE = DATA, BACKCOLOR = RGB(215 235 194), WHEN = FLAG EQ 1,$ TYPE = DATA, BACKCOLOR = RGB(255 255 255), WHEN = FLAG EQ 2,$ TYPE=HEADING, COLUMN=CLIENTNAME, WRAP=3.00000, BACKCOLOR = RGB(215 235 194), WHEN = FLAG EQ 1,$ $ TYPE=HEADING, COLUMN=CLIENTNAME, WRAP=3.00000, BACKCOLOR = RGB(255 255 255), WHEN = FLAG EQ 2, $