quote:Originally posted by GinnyJakes:
There is a simpler way to alternate row colors. From Style, pick Data. On the right side of the wizard, see the section on background color. Select alternating colors and pick the two you want.
In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID |
TABLE FILE CAR SUM RCOST DCOST BY COUNTRY BY CAR BY MODEL ON TABLE SET HTMLCSS ON ON TABLE SET PAGE NOLEAD ON TABLE PCHOLD FORMAT HTML ON TABLE SET STYLE * TYPE=DATA, BACKCOLOR=(SILVER WHITE), $ ENDSTYLE 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 |
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 |
quote:Originally posted by susannah:
just stick in
TYPE=DATA,COLUMN=SALES,BACKCOLOR=( SILVER WHITE),$
and that should do it, quick and simple.
-* HTML Tool -* Created by Report Assistant -* FF Line do not change this line! Field Name -* FF Line do not change this line! Alias -* FF Line do not change this line! Format -* FF Line do not change this line! Segment -* FF Line do not change this line! ShowFieldTree -* FF Line do not change this line! displayTree=0 -* J001 J001 -* J002 J002 -* J003 J003 -* J004 J004 JOIN HCP_HC_OUTLINETREE.HCP_HC_OUTLINETREE.S_TYPE AND HCP_HC_OUTLINETREE.HCP_HC_OUTLINETREE.L_FOLDER IN HCP_HC_OUTLINETREE TO MULTIPLE HCP_HC_OUTLINEFILES.HCP_HC_OUTLINEFILES.S_TYPE AND HCP_HC_OUTLINEFILES.HCP_HC_OUTLINEFILES.L_FOLDER IN HCP_HC_OUTLINEFILES TAG J001 AS J001 END JOIN J001.HCP_HC_OUTLINEFILES.S_CODE IN HCP_HC_OUTLINETREE TO MULTIPLE HCP_HC_ASSETS.HCP_HC_ASSETS.S_COSTCENTRE IN HCP_HC_ASSETS TAG J002 AS J002 END JOIN J002.HCP_HC_ASSETS.S_CODE IN HCP_HC_OUTLINETREE TO MULTIPLE HCP_HC_LOG.HCP_HC_LOG.S_ENTITYCODE IN HCP_HC_LOG TAG J003 AS J003 END JOIN J002.HCP_HC_ASSETS.S_SUPPLIER IN HCP_HC_OUTLINETREE TO UNIQUE HCP_HARDCATSUPPLIERS1.HCP_HARDCATSUPPLIERS1.CODE IN HCP_HARDCATSUPPLIERS1 TAG J004 AS J004 END DEFINE FILE HCP_HC_OUTLINETREE -* DEFINE BEGIN NEW_LOC_CD NEW_LOC_CD/A20 = IF J003.HCP_HC_LOG.S_ITEMTYPE EQ 'CC' THEN J003.HCP_HC_LOG.S_TO ELSE ' '; -* DEFINE END NEW_LOC_CD -* DEFINE BEGIN FA_TYP FA_TYP/A1 = 'E'; -* DEFINE END FA_TYP -* DEFINE BEGIN NEW_SLOC_CD NEW_SLOC_CD/I5 = 0; -* DEFINE END NEW_SLOC_CD -* DEFINE BEGIN NEW_CMPX_BLDG NEW_CMPX_BLDG/A8 = IF J003.HCP_HC_LOG.S_ITEMTYPE EQ 'LN' THEN J003.HCP_HC_LOG.S_TO ELSE ''; -* DEFINE END NEW_CMPX_BLDG -* DEFINE BEGIN DOC_ID DOC_ID/A20 = IF J003.HCP_HC_LOG.S_TYPE EQ 'AU' THEN 'AU' || J003.HCP_HC_LOG.S_ENTITYCODE ELSE J003.HCP_HC_LOG.S_ITEMTYPE || J003.HCP_HC_LOG.S_ENTITYCODE; -* DEFINE END DOC_ID -* DEFINE BEGIN NEW_L_INV_DT NEW_L_INV_DT/A20 = IF J003.HCP_HC_LOG.S_TYPE EQ 'AU' THEN J003.HCP_HC_LOG.D_ACTUALDATE ELSE ''; -* DEFINE END NEW_L_INV_DT -* DEFINE BEGIN NEW_MANFR_NM NEW_MANFR_NM/A20 = IF J003.HCP_HC_LOG.S_FIELDCHANGED EQ '000' THEN UPCASE ( 20, J003.HCP_HC_LOG.S_TO , NEW_MANFR_NM ) ELSE ' '; -* DEFINE END NEW_MANFR_NM -* DEFINE BEGIN NEW_MDL_NO NEW_MDL_NO/A20 = IF J003.HCP_HC_LOG.S_FIELDCHANGED EQ 'S_User1' THEN UPCASE ( 20 , J003.HCP_HC_LOG.S_TO , NEW_MDL_NO ) ELSE ' '; -* DEFINE END NEW_MDL_NO -* DEFINE BEGIN NEW_SR_NO NEW_SR_NO/A20 = IF J003.HCP_HC_LOG.S_FIELDCHANGED EQ 'S_SerialNumber' THEN J003.HCP_HC_LOG.S_TO ELSE ' '; -* DEFINE END NEW_SR_NO -* DEFINE BEGIN NEW_FA_DSCR NEW_FA_DSCR/A20 = IF J003.HCP_HC_LOG.S_FIELDCHANGED EQ 'S_Description' THEN UPCASE ( 20 , J003.HCP_HC_LOG.S_TO , NEW_FA_DSCR ) ELSE ' '; -* DEFINE END NEW_FA_DSCR -* DEFINE BEGIN NEW_EXTD_DOC_DSCR NEW_EXTD_DOC_DSCR/A20 = IF J003.HCP_HC_LOG.S_FIELDCHANGED EQ '002' THEN UPCASE ( 20 , J003.HCP_HC_LOG.S_TO,NEW_EXTD_DOC_DSCR) ELSE ' '; -* DEFINE END NEW_EXTD_DOC_DSCR -* DEFINE BEGIN NEW_COMMENT NEW_COMMENT/A20 = IF J003.HCP_HC_LOG.S_FIELDCHANGED EQ '004' THEN UPCASE ( 20 , J003.HCP_HC_LOG.S_TO,NEW_EXTD_DOC_DSCR) ELSE ' '; -* DEFINE END NEW_COMMENT -* DEFINE BEGIN NEW_COND_CD NEW_COND_CD/A20 = IF J003.HCP_HC_LOG.S_FIELDCHANGED EQ '001' THEN J003.HCP_HC_LOG.S_TO ELSE ' '; -* DEFINE END NEW_COND_CD -* DEFINE BEGIN BSCNT BSCNT/D12 = 1; -* DEFINE END BSCNT END TABLE FILE HCP_HC_OUTLINETREE PRINT J001.HCP_HC_OUTLINEFILES.S_CODE NOPRINT J002.HCP_HC_ASSETS.S_CODE AS 'Asset No.' NEW_LOC_CD AS 'Cust' NEW_CMPX_BLDG AS 'Building' NEW_FA_DSCR AS 'Asset Desc' NEW_MANFR_NM AS 'Manufacturer' NEW_MDL_NO AS 'Model No.' NEW_SR_NO AS 'Serial No.' NEW_COND_CD AS 'Condition' NEW_EXTD_DOC_DSCR AS 'Extended Doc Desc' NEW_COMMENT AS 'Comments' J002.HCP_HC_ASSETS.S_SERIALNUMBER NOPRINT J002.HCP_HC_ASSETS.D_AUDITLAST AS 'NEW_L_INV_DT' NOPRINT J002.HCP_HC_ASSETS.S_USER2 NOPRINT J002.HCP_HC_ASSETS.S_DESCRIPTION NOPRINT J002.HCP_HC_ASSETS.M_PURCHPRICE NOPRINT HCP_HC_OUTLINETREE.HCP_HC_OUTLINETREE.S_FOLDERCODE NOPRINT J003.HCP_HC_LOG.S_FROM NOPRINT J003.HCP_HC_LOG.S_TO NOPRINT J003.HCP_HC_LOG.S_ITEMTYPE NOPRINT J003.HCP_HC_LOG.S_TYPE NOPRINT J003.HCP_HC_LOG.S_FIELDCHANGED NOPRINT J003.HCP_HC_LOG.S_USERID TOT.BSCNT NOPRINT BY HCP_HC_OUTLINETREE.HCP_HC_OUTLINETREE.S_TYPE NOPRINT BY J002.HCP_HC_ASSETS.S_CODE NOPRINT WHERE (HCP_HC_OUTLINETREE.HCP_HC_OUTLINETREE.S_TYPE EQ 'CC') AND (HCP_HC_OUTLINETREE.HCP_HC_OUTLINETREE.S_FOLDERCODE EQ '&CLASS') AND (J003.HCP_HC_LOG.D_ACTUALDATE GE '&START_DATE') AND (J003.HCP_HC_LOG.S_TYPE NE 'AU'); HEADING "ORANGE COUNTY COMPTROLLER" "PROPERTY ACCOUNTING" "CHANGES CAPTURED DURING INVENTORY" "CLASS #<HCP_HC_OUTLINETREE.HCP_HC_OUTLINETREE.S_DESCRIPTION" "&DATEtMDYY" "" FOOTING "Total Changes Captured: <TOT.BSCNT" ON TABLE SET STYLE * TYPE=REPORT, GRID=OFF, UNITS=IN, PAGESIZE='Legal', SQUEEZE=ON, ORIENTATION=LANDSCAPE, $ TYPE= HEADING,LINE=1,JUSTIFY=CENTER,$ TYPE= HEADING,LINE=1,OBJECT=TEXT,ITEM=1,STYLE=BOLD,$ TYPE= HEADING,LINE=2,JUSTIFY=CENTER,$ TYPE= HEADING,LINE=2,OBJECT=TEXT,ITEM=1,STYLE=BOLD,$ TYPE= HEADING,LINE=3,JUSTIFY=CENTER,$ TYPE= HEADING,LINE=3,OBJECT=TEXT,ITEM=1,STYLE=BOLD,$ TYPE= HEADING,LINE=4,JUSTIFY=CENTER,$ TYPE= HEADING,LINE=4,OBJECT=TEXT,ITEM=1,STYLE=BOLD,$ TYPE= HEADING,LINE=4,OBJECT=FIELD,ITEM=1,STYLE=BOLD,$ TYPE= HEADING,LINE=5,JUSTIFY=CENTER,$ TYPE= HEADING,LINE=5,OBJECT=TEXT,ITEM=1,STYLE=BOLD,$ TYPE= HEADING,LINE=6,JUSTIFY=CENTER,$ TYPE= FOOTING,LINE=1,JUSTIFY=RIGHT,$ TYPE= FOOTING,LINE=1,OBJECT=TEXT,ITEM=1,STYLE=BOLD,$ TYPE= FOOTING,LINE=1,OBJECT=FIELD,ITEM=1,STYLE=BOLD,$ TYPE=TITLE, COLUMN=J001.HCP_HC_OUTLINEFILES.S_CODE, STYLE=BOLD, JUSTIFY=CENTER, $ TYPE=TITLE, COLUMN=NEW_LOC_CD, STYLE=BOLD, JUSTIFY=CENTER, $ TYPE=TITLE, COLUMN=NEW_CMPX_BLDG, STYLE=BOLD, JUSTIFY=CENTER, $ TYPE=TITLE, COLUMN=NEW_FA_DSCR, STYLE=BOLD, JUSTIFY=CENTER, $ TYPE=TITLE, COLUMN=NEW_MANFR_NM, STYLE=BOLD, JUSTIFY=CENTER, $ TYPE=TITLE, COLUMN=NEW_MDL_NO, STYLE=BOLD, JUSTIFY=CENTER, $ TYPE=TITLE, COLUMN=NEW_SR_NO, STYLE=BOLD, JUSTIFY=CENTER, $ TYPE=TITLE, COLUMN=NEW_COND_CD, STYLE=BOLD, JUSTIFY=CENTER, $ TYPE=TITLE, COLUMN=NEW_EXTD_DOC_DSCR, STYLE=BOLD, JUSTIFY=CENTER, $ TYPE=TITLE, COLUMN=NEW_COMMENT, STYLE=BOLD, JUSTIFY=CENTER, $ TYPE=TITLE, COLUMN=J002.HCP_HC_ASSETS.S_SERIALNUMBER, STYLE=BOLD, JUSTIFY=CENTER, $ TYPE=TITLE, COLUMN=J002.HCP_HC_ASSETS.D_AUDITLAST, STYLE=BOLD, JUSTIFY=CENTER, $ TYPE=TITLE, COLUMN=J002.HCP_HC_ASSETS.S_USER2, STYLE=BOLD, JUSTIFY=CENTER, $ TYPE=TITLE, COLUMN=J002.HCP_HC_ASSETS.S_DESCRIPTION, STYLE=BOLD, JUSTIFY=CENTER, $ TYPE=DATA, COLUMN=J002.HCP_HC_ASSETS.M_PURCHPRICE, JUSTIFY=LEFT, $ TYPE=TITLE, COLUMN=J002.HCP_HC_ASSETS.M_PURCHPRICE, STYLE=BOLD, JUSTIFY=CENTER, $ TYPE=TITLE, COLUMN=HCP_HC_OUTLINETREE.HCP_HC_OUTLINETREE.S_FOLDERCODE, STYLE=BOLD, JUSTIFY=CENTER, $ TYPE=TITLE, COLUMN=J003.HCP_HC_LOG.S_FROM, STYLE=BOLD, JUSTIFY=CENTER, $ TYPE=TITLE, COLUMN=J003.HCP_HC_LOG.S_TO, STYLE=BOLD, JUSTIFY=CENTER, $ TYPE=TITLE, COLUMN=J003.HCP_HC_LOG.S_ITEMTYPE, STYLE=BOLD, JUSTIFY=CENTER, $ TYPE=TITLE, COLUMN=J003.HCP_HC_LOG.S_TYPE, STYLE=BOLD, JUSTIFY=CENTER, $ TYPE=TITLE, COLUMN=J003.HCP_HC_LOG.S_FIELDCHANGED, STYLE=BOLD, JUSTIFY=CENTER, $ TYPE=DATA, COLUMN=TOT.BSCNT, JUSTIFY=LEFT, $ TYPE=TITLE, COLUMN=TOT.BSCNT, STYLE=BOLD, JUSTIFY=CENTER, $ TYPE=TITLE, COLUMN=HCP_HC_OUTLINETREE.HCP_HC_OUTLINETREE.S_TYPE, STYLE=BOLD, JUSTIFY=CENTER, $ TYPE=TITLE, COLUMN=J002.HCP_HC_ASSETS.S_CODE, STYLE=BOLD, JUSTIFY=CENTER, $ ENDSTYLE ON TABLE PCHOLD FORMAT PDF ON TABLE NOTOTAL END -* End Report Assistant
TABLE FILE HCP_HC_OUTLINETREE PRINT S_CODE NOPRINT S_CODE AS 'Asset No.' NEW_LOC_CD AS 'Cust' NEW_CMPX_BLDG AS 'Building' NEW_FA_DSCR AS 'Asset Desc' NEW_MANFR_NM AS 'Manufacturer' NEW_MDL_NO AS 'Model No.' NEW_SR_NO AS 'Serial No.' NEW_COND_CD AS 'Condition' NEW_EXTD_DOC_DSCR AS 'Extended Doc Desc' NEW_COMMENT AS 'Comments' S_SERIALNUMBER NOPRINT D_AUDITLAST NOPRINT AS 'NEW_L_INV_DT' S_USER2 NOPRINT S_DESCRIPTION NOPRINT M_PURCHPRICE NOPRINT S_FOLDERCODE NOPRINT S_FROM NOPRINT S_TO NOPRINT S_ITEMTYPE NOPRINT S_TYPE NOPRINT S_FIELDCHANGED NOPRINT S_USERID TOT.BSCNT NOPRINT BY S_TYPE NOPRINT BY S_CODE NOPRINT HEADING "ORANGE COUNTY COMPTROLLER" "PROPERTY ACCOUNTING" "CHANGES CAPTURED DURING INVENTORY" "CLASS #<HCP_HC_OUTLINETREE.HCP_HC_OUTLINETREE.S_DESCRIPTION" "&DATEtMDYY" " " FOOTING "Total Changes Captured: <TOT.BSCNT" WHERE (HCP_HC_OUTLINETREE.HCP_HC_OUTLINETREE.S_TYPE EQ 'CC') AND (HCP_HC_OUTLINETREE.HCP_HC_OUTLINETREE.S_FOLDERCODE EQ '&CLASS') AND (J003.HCP_HC_LOG.D_ACTUALDATE GE '&START_DATE') AND (J003.HCP_HC_LOG.S_TYPE NE 'AU'); ON TABLE NOTOTAL ON TABLE PCHOLD FORMAT PDF ON TABLE SET STYLE * UNITS=IN, PAGESIZE='Letter', LEFTMARGIN=0.250000, RIGHTMARGIN=0.250000, TOPMARGIN=0.250000, BOTTOMMARGIN=0.250000, SQUEEZE=ON, ORIENTATION=PORTRAIT, $ TYPE=REPORT, FONT='ARIAL', SIZE=10, COLOR='BLACK', BACKCOLOR='NONE', STYLE=NORMAL, $ TYPE=DATA, SIZE=8, BACKCOLOR=( RGB(234 234 255) 'WHITE' ), $ TYPE=TITLE, BORDER-TOP=LIGHT, BORDER-BOTTOM=LIGHT, BORDER-LEFT=LIGHT, BORDER-RIGHT=LIGHT, BORDER-TOP-STYLE=RIDGE, BORDER-BOTTOM-STYLE=RIDGE, BORDER-LEFT-STYLE=RIDGE, BORDER-RIGHT-STYLE=RIDGE, BORDER-TOP-COLOR=RGB(51 51 153), BORDER-BOTTOM-COLOR=RGB(51 51 153), BORDER-LEFT-COLOR=RGB(51 51 153), BORDER-RIGHT-COLOR=RGB(51 51 153), SIZE=9, COLOR='WHITE', BACKCOLOR=RGB(147 172 219), STYLE=BOLD, $ TYPE=TABHEADING, SIZE=9, STYLE=BOLD, $ TYPE=TABFOOTING, SIZE=9, STYLE=BOLD, $ TYPE=HEADING, BORDER-TOP=LIGHT, BORDER-BOTTOM=LIGHT, BORDER-LEFT=LIGHT, BORDER-RIGHT=LIGHT, BORDER-TOP-STYLE=RIDGE, BORDER-BOTTOM-STYLE=RIDGE, BORDER-LEFT-STYLE=RIDGE, BORDER-RIGHT-STYLE=RIDGE, BORDER-TOP-COLOR=RGB(51 51 153), BORDER-BOTTOM-COLOR=RGB(51 51 153), BORDER-LEFT-COLOR=RGB(51 51 153), BORDER-RIGHT-COLOR=RGB(51 51 153), SIZE=12, COLOR='WHITE', BACKCOLOR=RGB(147 172 219), STYLE=BOLD, JUSTIFY=CENTER, $ TYPE=HEADING, LINE=1, SIZE=14, $ TYPE=FOOTING, BORDER-TOP=LIGHT, BORDER-BOTTOM=LIGHT, BORDER-LEFT=LIGHT, BORDER-RIGHT=LIGHT, BORDER-TOP-STYLE=RIDGE, BORDER-BOTTOM-STYLE=RIDGE, BORDER-LEFT-STYLE=RIDGE, BORDER-RIGHT-STYLE=RIDGE, BORDER-TOP-COLOR=RGB(51 51 153), BORDER-BOTTOM-COLOR=RGB(51 51 153), BORDER-LEFT-COLOR=RGB(51 51 153), BORDER-RIGHT-COLOR=RGB(51 51 153), COLOR='WHITE', BACKCOLOR=RGB(147 172 219), STYLE=BOLD, $ TYPE=SUBHEAD, SIZE=9, STYLE=BOLD, $ TYPE=SUBFOOT, BORDER-TOP=LIGHT, BORDER-BOTTOM=LIGHT, BORDER-LEFT=LIGHT, BORDER-RIGHT=LIGHT, BORDER-TOP-STYLE=RIDGE, BORDER-BOTTOM-STYLE=RIDGE, BORDER-LEFT-STYLE=RIDGE, BORDER-RIGHT-STYLE=RIDGE, BORDER-TOP-COLOR=RGB(51 51 153), BORDER-BOTTOM-COLOR=RGB(51 51 153), BORDER-LEFT-COLOR=RGB(51 51 153), BORDER-RIGHT-COLOR=RGB(51 51 153), SIZE=9, COLOR='WHITE', BACKCOLOR=RGB(147 172 219), STYLE=BOLD, $ TYPE=SUBTOTAL, SIZE=8, STYLE=BOLD, $ TYPE=ACROSSVALUE, SIZE=8, STYLE=BOLD, $ TYPE=ACROSSTITLE, SIZE=8, STYLE=BOLD, $ TYPE=GRANDTOTAL, SIZE=9, STYLE=BOLD, $ ENDSTYLE END