DEFINE FILE CAR FIRST_HEAD1/A20='subhead1'; SECOND_HEAD2/A10='subhead2'; A/A3=''; THIRD_HEAD3/A60='Target'; HEAD1/A15='>10%'; HEAD2/A15='>20%'; HEAD3/A15='>30%'; END TABLE FILE CAR PRINT * WHERE RECORDLIMIT EQ 30 HEADING "Car heading" "Source data" "Data Current as of today" " " "<A<FIRST_HEAD1<SECOND_HEAD2<A<THIRD_HEAD3" "<A<HEAD1<HEAD2<HEAD3" ON TABLE PCHOLD FORMAT HTML ON TABLE SET PAGE NOLEAD ON TABLE SET HTMLCSS OFF ON TABLE SET STYLE * TYPE=REPORT,SQUEEZE=ON,FONT='ARIAL',SIZE=9,GRID=ON,BORDER=1.5,TITLETEXT='Car report',$ TYPE=HEADING,HEADALIGN=BODY,$ TYPE=HEADING,LINE=1,JUSTIFY=CENTER,COLSPAN=18,COLOR='BLACK',FONT='ARIAL',SIZE= 10,STYLE=BOLD,$ TYPE=HEADING,LINE=2,JUSTIFY=CENTER,COLSPAN=18,COLOR='BLACK',FONT='ARIAL',SIZE= 9,STYLE=BOLD+ITALIC,$ TYPE=HEADING,LINE=3,JUSTIFY=CENTER,COLSPAN=18,COLOR='BLACK',FONT='ARIAL',SIZE= 9,STYLE=BOLD+ITALIC,$ TYPE=HEADING,LINE=5,ITEM=1,COLSPAN=3,COLOR='BLACK',$ TYPE=HEADING,LINE=5,ITEM=2,COLSPAN=1,JUSTIFY=CENTER,COLOR='BLACK',FONT='ARIAL' ,SIZE=9,STYLE=BOLD,BACKCOLOR=RGB(210 210 210),$ TYPE=HEADING,LINE=5,ITEM=3,COLSPAN=1,JUSTIFY=CENTER,COLOR='BLACK',FONT='ARIAL' ,SIZE=9,STYLE=BOLD,BACKCOLOR=RGB(210 210 210),$ TYPE=HEADING,LINE=5,ITEM=4,COLSPAN=6,JUSTIFY=CENTER,COLOR='BLACK',FONT='ARIAL' ,SIZE=9,STYLE=BOLD,$ TYPE=HEADING,LINE=5,ITEM=5,COLSPAN=7,JUSTIFY=CENTER,COLOR=RGB(153 0 0),FONT='ARIAL',SIZE=9,STYLE=BOLD,BACKCOLOR=RGB(210 210 210),$ TYPE=HEADING,LINE=6,ITEM=1,COLSPAN=3,COLOR='BLACK',$ TYPE=HEADING,LINE=6,ITEM=2,COLSPAN=4,JUSTIFY=CENTER,COLOR='BLACK',FONT='ARIAL' ,SIZE=9,STYLE=BOLD,BACKCOLOR=RGB(210 210 210),$ TYPE=HEADING,LINE=6,ITEM=3,COLSPAN=4,JUSTIFY=CENTER,COLOR='BLACK',FONT='ARIAL' ,SIZE=9,STYLE=BOLD,BACKCOLOR=RGB(210 210 210),$ TYPE=HEADING,LINE=6,ITEM=4,COLSPAN=7,JUSTIFY=CENTER,COLOR='BLACK',FONT='ARIAL' ,SIZE=9,STYLE=BOLD,BACKCOLOR=RGB(210 210 210),$ TYPE=TITLE,FONT='ARIAL',SIZE=9,STYLE=BOLD,COLOR='BLACK',JUSTIFY=CENTER,BACKCOL OR=RGB(169 169 169),$ TYPE=DATA,FONT='ARIAL',SIZE=9,STYLE=NORMAL,JUSTIFY=LEFT,BORDER=ON,$ END -RUN -EXITThis message has been edited. Last edited by: Tamra,
DEFINE FILE CAR FIRST_HEAD1/A20='subhead1'; SECOND_HEAD2/A10='subhead2'; A/A3=''; THIRD_HEAD3/A60='Target'; HEAD1/A15='>10%'; HEAD2/A15='>20%'; HEAD3/A15='>30%'; END TABLE FILE CAR PRINT * WHERE RECORDLIMIT EQ 30 HEADING "Car heading" "Source data" "Data Current as of today" " " "<A<FIRST_HEAD1<SECOND_HEAD2<A<THIRD_HEAD3" "<A<HEAD1<HEAD2<HEAD3" ON TABLE PCHOLD FORMAT HTML ON TABLE SET PAGE NOLEAD ON TABLE SET HTMLCSS OFF ON TABLE SET STYLE * TYPE=REPORT,SQUEEZE=ON,FONT='ARIAL',SIZE=9,GRID=ON,BORDER=1.5,TITLETEXT='Car report',$ TYPE=HEADING,HEADALIGN=BODY,$ TYPE=HEADING,LINE=1,JUSTIFY=CENTER,COLSPAN=18,COLOR='BLACK',FONT='ARIAL',SIZE=10,STYLE=BOLD,$ TYPE=HEADING,LINE=2,JUSTIFY=CENTER,COLSPAN=18,COLOR='BLACK',FONT='ARIAL',SIZE=9,STYLE=BOLD+ITALIC,$ TYPE=HEADING,LINE=3,JUSTIFY=CENTER,COLSPAN=18,COLOR='BLACK',FONT='ARIAL',SIZE=9,STYLE=BOLD+ITALIC,$ TYPE=HEADING,LINE=5,ITEM=1,COLSPAN=3,COLOR='BLACK',$ TYPE=HEADING,LINE=5,ITEM=2,COLSPAN=1,JUSTIFY=CENTER,COLOR='BLACK',FONT='ARIAL',SIZE=9,STYLE=BOLD,BACKCOLOR=RGB(210 210 210),$ TYPE=HEADING,LINE=5,ITEM=3,COLSPAN=1,JUSTIFY=CENTER,COLOR='BLACK',FONT='ARIAL',SIZE=9,STYLE=BOLD,BACKCOLOR=RGB(210 210 210),$ TYPE=HEADING,LINE=5,ITEM=4,COLSPAN=6,JUSTIFY=CENTER,COLOR='BLACK',FONT='ARIAL',SIZE=9,STYLE=BOLD,$ TYPE=HEADING,LINE=5,ITEM=5,COLSPAN=7,JUSTIFY=CENTER,COLOR=RGB(153 0 0),FONT='ARIAL',SIZE=9,STYLE=BOLD,BACKCOLOR=RGB(210 210 210),$ TYPE=HEADING,LINE=6,ITEM=1,COLSPAN=3,COLOR='BLACK',$ TYPE=HEADING,LINE=6,ITEM=2,COLSPAN=4,JUSTIFY=CENTER,COLOR='BLACK',FONT='ARIAL',SIZE=9,STYLE=BOLD,BACKCOLOR=RGB(210 210 210),$ TYPE=HEADING,LINE=6,ITEM=3,COLSPAN=4,JUSTIFY=CENTER,COLOR='BLACK',FONT='ARIAL',SIZE=9,STYLE=BOLD,BACKCOLOR=RGB(210 210 210),$ TYPE=HEADING,LINE=6,ITEM=4,COLSPAN=7,JUSTIFY=CENTER,COLOR='BLACK',FONT='ARIAL',SIZE=9,STYLE=BOLD,BACKCOLOR=RGB(210 210 210),$ TYPE=TITLE,FONT='ARIAL',SIZE=9,STYLE=BOLD,COLOR='BLACK',JUSTIFY=CENTER,BACKCOLOR=RGB(169 169 169),$ TYPE=DATA,FONT='ARIAL',SIZE=9,STYLE=NORMAL,JUSTIFY=LEFT,BORDER=ON,$ END -RUN -EXIT
-HTMLFORM BEGIN <style> table {border: solid black 3px;} </style> -HTMLFORM END
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 |
DEFINE FILE CAR FIRST_HEAD1/A20='subhead1'; SECOND_HEAD2/A10='subhead2'; A/A3=''; THIRD_HEAD3/A60='Target'; HEAD1/A15='>10%'; HEAD2/A15='>20%'; HEAD3/A15='>30%'; END TABLE FILE CAR PRINT * WHERE RECORDLIMIT EQ 30 HEADING "Car heading" "Source data" "Data Current as of today" " " "<A<FIRST_HEAD1<SECOND_HEAD2<A<THIRD_HEAD3" "<A<HEAD1<HEAD2<HEAD3" -*ON TABLE PCHOLD FORMAT HTML ON TABLE HOLD AS HOLD_FILE FORMAT HTML ON TABLE SET PAGE NOLEAD ON TABLE SET HTMLCSS OFF ON TABLE SET STYLE * TYPE=REPORT,SQUEEZE=ON,FONT='ARIAL',SIZE=9,GRID=OFF,BORDER=1.5,TITLETEXT='Car report',$ TYPE=HEADING,HEADALIGN=BODY,$ TYPE=HEADING,LINE=1,JUSTIFY=CENTER,COLSPAN=18,COLOR='BLACK',FONT='ARIAL',SIZE=10,STYLE=BOLD,$ TYPE=HEADING,LINE=2,JUSTIFY=CENTER,COLSPAN=18,COLOR='BLACK',FONT='ARIAL',SIZE=9,STYLE=BOLD+ITALIC,$ TYPE=HEADING,LINE=3,JUSTIFY=CENTER,COLSPAN=18,COLOR='BLACK',FONT='ARIAL',SIZE=9,STYLE=BOLD+ITALIC,$ TYPE=HEADING,LINE=5,ITEM=1,COLSPAN=3,COLOR='BLACK',$ TYPE=HEADING,LINE=5,ITEM=2,COLSPAN=1,JUSTIFY=CENTER,COLOR='BLACK',FONT='ARIAL',SIZE=9,STYLE=BOLD,BACKCOLOR=RGB(210 210 210),$ TYPE=HEADING,LINE=5,ITEM=3,COLSPAN=1,JUSTIFY=CENTER,COLOR='BLACK',FONT='ARIAL',SIZE=9,STYLE=BOLD,BACKCOLOR=RGB(210 210 210),$ TYPE=HEADING,LINE=5,ITEM=4,COLSPAN=6,JUSTIFY=CENTER,COLOR='BLACK',FONT='ARIAL',SIZE=9,STYLE=BOLD,$ TYPE=HEADING,LINE=5,ITEM=5,COLSPAN=7,JUSTIFY=CENTER,COLOR=RGB(153 0 0),FONT='ARIAL',SIZE=9,STYLE=BOLD,BACKCOLOR=RGB(210 210 210),$ TYPE=HEADING,LINE=6,ITEM=1,COLSPAN=3,COLOR='BLACK',$ TYPE=HEADING,LINE=6,ITEM=2,COLSPAN=4,JUSTIFY=CENTER,COLOR='BLACK',FONT='ARIAL',SIZE=9,STYLE=BOLD,BACKCOLOR=RGB(210 210 210),$ TYPE=HEADING,LINE=6,ITEM=3,COLSPAN=4,JUSTIFY=CENTER,COLOR='BLACK',FONT='ARIAL',SIZE=9,STYLE=BOLD,BACKCOLOR=RGB(210 210 210),$ TYPE=HEADING,LINE=6,ITEM=4,COLSPAN=7,JUSTIFY=CENTER,COLOR='BLACK',FONT='ARIAL',SIZE=9,STYLE=BOLD,BACKCOLOR=RGB(210 210 210),$ TYPE=TITLE,FONT='ARIAL',SIZE=9,STYLE=BOLD,COLOR='BLACK',JUSTIFY=CENTER,BACKCOLOR=RGB(169 169 169),$ TYPE=DATA,FONT='ARIAL',SIZE=9,STYLE=NORMAL,JUSTIFY=LEFT,BORDER=ON,$ END -RUN -HTMLFORM BEGIN <style> table {border: solid black 3px;} </style> !IBI.FIL.HOLD_FILE; -HTMLFORM END -EXIT
-HTMLFORM BEGIN <style> table {border: solid black 3px;} </style> -HTMLFORM END DEFINE FILE CAR FIRST_HEAD1/A20='subhead1'; SECOND_HEAD2/A10='subhead2'; A/A3=''; THIRD_HEAD3/A60='Target'; HEAD1/A15='>10%'; HEAD2/A15='>20%'; HEAD3/A15='>30%'; END TABLE FILE CAR PRINT * WHERE RECORDLIMIT EQ 30 HEADING "Car heading" "Source data" "Data Current as of today" " " "<A<FIRST_HEAD1<SECOND_HEAD2<A<THIRD_HEAD3" "<A<HEAD1<HEAD2<HEAD3" ON TABLE PCHOLD FORMAT HTML ON TABLE SET PAGE NOLEAD ON TABLE SET HTMLCSS OFF ON TABLE SET STYLE * TYPE=REPORT,SQUEEZE=ON,FONT='ARIAL',SIZE=9,GRID=OFF,BORDER=1.5,TITLETEXT='Car report',$ TYPE=HEADING,HEADALIGN=BODY,$ TYPE=HEADING,LINE=1,JUSTIFY=CENTER,COLSPAN=18,COLOR='BLACK',FONT='ARIAL',SIZE=10,STYLE=BOLD,$ TYPE=HEADING,LINE=2,JUSTIFY=CENTER,COLSPAN=18,COLOR='BLACK',FONT='ARIAL',SIZE=9,STYLE=BOLD+ITALIC,$ TYPE=HEADING,LINE=3,JUSTIFY=CENTER,COLSPAN=18,COLOR='BLACK',FONT='ARIAL',SIZE=9,STYLE=BOLD+ITALIC,$ TYPE=HEADING,LINE=5,ITEM=1,COLSPAN=3,COLOR='BLACK',$ TYPE=HEADING,LINE=5,ITEM=2,COLSPAN=1,JUSTIFY=CENTER,COLOR='BLACK',FONT='ARIAL',SIZE=9,STYLE=BOLD,BACKCOLOR=RGB(210 210 210),$ TYPE=HEADING,LINE=5,ITEM=3,COLSPAN=1,JUSTIFY=CENTER,COLOR='BLACK',FONT='ARIAL',SIZE=9,STYLE=BOLD,BACKCOLOR=RGB(210 210 210),$ TYPE=HEADING,LINE=5,ITEM=4,COLSPAN=6,JUSTIFY=CENTER,COLOR='BLACK',FONT='ARIAL',SIZE=9,STYLE=BOLD,$ TYPE=HEADING,LINE=5,ITEM=5,COLSPAN=7,JUSTIFY=CENTER,COLOR=RGB(153 0 0),FONT='ARIAL',SIZE=9,STYLE=BOLD,BACKCOLOR=RGB(210 210 210),$ TYPE=HEADING,LINE=6,ITEM=1,COLSPAN=3,COLOR='BLACK',$ TYPE=HEADING,LINE=6,ITEM=2,COLSPAN=4,JUSTIFY=CENTER,COLOR='BLACK',FONT='ARIAL',SIZE=9,STYLE=BOLD,BACKCOLOR=RGB(210 210 210),$ TYPE=HEADING,LINE=6,ITEM=3,COLSPAN=4,JUSTIFY=CENTER,COLOR='BLACK',FONT='ARIAL',SIZE=9,STYLE=BOLD,BACKCOLOR=RGB(210 210 210),$ TYPE=HEADING,LINE=6,ITEM=4,COLSPAN=7,JUSTIFY=CENTER,COLOR='BLACK',FONT='ARIAL',SIZE=9,STYLE=BOLD,BACKCOLOR=RGB(210 210 210),$ TYPE=TITLE,FONT='ARIAL',SIZE=9,STYLE=BOLD,COLOR='BLACK',JUSTIFY=CENTER,BACKCOLOR=RGB(169 169 169),$ TYPE=DATA,FONT='ARIAL',SIZE=9,STYLE=NORMAL,JUSTIFY=LEFT,BORDER=ON,$ END -RUN
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 |
(FOC757) WARNING. YOU REQUESTED PRINT * OR COUNT * FOR A MULTIPATH FILE
quote:color in black for the entire report
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 |
DEFINE FILE CAR FIRST_HEAD1/A20='subhead1'; SECOND_HEAD2/A10='subhead2'; A/A3=''; THIRD_HEAD3/A60='Target'; HEAD1/A15='>10%'; HEAD2/A15='>20%'; HEAD3/A15='>30%'; END TABLE FILE CAR PRINT * WHERE RECORDLIMIT EQ 30 HEADING "Car heading" "Source data" "Data Current as of today" " " "<A<FIRST_HEAD1<SECOND_HEAD2<A<THIRD_HEAD3" "<A<HEAD1<HEAD2<HEAD3" ON TABLE HOLD AS HOLD_FILE FORMAT HTML ON TABLE SET PAGE NOLEAD ON TABLE SET HTMLCSS OFF ON TABLE SET STYLE * TYPE=REPORT,SQUEEZE=ON,FONT='ARIAL',SIZE=9,GRID=OFF,BORDER=1.5,TITLETEXT='Car report',$ TYPE=HEADING,HEADALIGN=BODY,$ TYPE=HEADING,LINE=1,JUSTIFY=CENTER,COLSPAN=18,COLOR='BLACK',FONT='ARIAL',SIZE=10,STYLE=BOLD,$ TYPE=HEADING,LINE=2,JUSTIFY=CENTER,COLSPAN=18,COLOR='BLACK',FONT='ARIAL',SIZE=9,STYLE=BOLD+ITALIC,$ TYPE=HEADING,LINE=3,JUSTIFY=CENTER,COLSPAN=18,COLOR='BLACK',FONT='ARIAL',SIZE=9,STYLE=BOLD+ITALIC,$ TYPE=HEADING,LINE=4,COLSPAN=18,COLOR='BLACK',$ TYPE=HEADING,LINE=5,ITEM=1,COLSPAN=3,COLOR='BLACK',$ TYPE=HEADING,LINE=5,ITEM=2,COLSPAN=1,JUSTIFY=CENTER,COLOR='BLACK',FONT='ARIAL',SIZE=9,STYLE=BOLD,BACKCOLOR=RGB(210 210 210),$ TYPE=HEADING,LINE=5,ITEM=3,COLSPAN=1,JUSTIFY=CENTER,COLOR='BLACK',FONT='ARIAL',SIZE=9,STYLE=BOLD,BACKCOLOR=RGB(210 210 210),$ TYPE=HEADING,LINE=5,ITEM=4,COLSPAN=6,JUSTIFY=CENTER,COLOR='BLACK',FONT='ARIAL',SIZE=9,STYLE=BOLD,$ TYPE=HEADING,LINE=5,ITEM=5,COLSPAN=7,JUSTIFY=CENTER,COLOR=RGB(153 0 0),FONT='ARIAL',SIZE=9,STYLE=BOLD,BACKCOLOR=RGB(210 210 210),$ TYPE=HEADING,LINE=6,ITEM=1,COLSPAN=3,COLOR='BLACK',$ TYPE=HEADING,LINE=6,ITEM=2,COLSPAN=4,JUSTIFY=CENTER,COLOR='BLACK',FONT='ARIAL',SIZE=9,STYLE=BOLD,BACKCOLOR=RGB(210 210 210),$ TYPE=HEADING,LINE=6,ITEM=3,COLSPAN=4,JUSTIFY=CENTER,COLOR='BLACK',FONT='ARIAL',SIZE=9,STYLE=BOLD,BACKCOLOR=RGB(210 210 210),$ TYPE=HEADING,LINE=6,ITEM=4,COLSPAN=7,JUSTIFY=CENTER,COLOR='BLACK',FONT='ARIAL',SIZE=9,STYLE=BOLD,BACKCOLOR=RGB(210 210 210),$ TYPE=TITLE,FONT='ARIAL',SIZE=9,STYLE=-UNDERLINE,COLOR='BLACK',JUSTIFY=CENTER,BACKCOLOR=RGB(169 169 169),$ TYPE=DATA,FONT='ARIAL',SIZE=9,STYLE=NORMAL,JUSTIFY=LEFT,BORDER=ON,$ END -RUN -HTMLFORM BEGIN <style> table, th, td { border: 1px solid black; border-collapse: collapse; } </style> !IBI.FIL.HOLD_FILE; -HTMLFORM END -EXIT