The client has a requirement for a coordianated compound report, with graphs, to be displayed with some fairly sophisticated styling in one of the table components. Specifically, alternating backgrround colors in a SUBFOOT, by COLUMN rather than row. No big problem in native HTML, as the folloWING SHOWS:
TABLE FILE CAR
PRINT
CAR.COMP.CAR
CAR.CARREC.MODEL
CAR.BODY.BODYTYPE
BY CAR.ORIGIN.COUNTRY
ON CAR.ORIGIN.COUNTRY SUBFOOT
"<COUNTRY<ST.CAR.BODY.DEALER_COST<ST.CAR.BODY.RETAIL_COST<ST.CAR.BODY.SALES"
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = endeflt,
$
TYPE=SUBFOOT,
BORDER-TOP=OFF,
BORDER-BOTTOM=OFF,
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),
TOPGAP=0.055556,
HEADALIGN=BODY,
$
TYPE=SUBFOOT,
LINE=1,
OBJECT=FIELD,
ITEM=1,
BACKCOLOR=RGB(202 205 179),
$
TYPE=SUBFOOT,
BY=1,
LINE=1,
OBJECT=FIELD,
ITEM=1,
COLSPAN=1,
WRAP=ON,
JUSTIFY=LEFT,
$
TYPE=SUBFOOT,
LINE=1,
OBJECT=FIELD,
ITEM=2,
BACKCOLOR=RGB(193 197 167),
$
TYPE=SUBFOOT,
BY=1,
LINE=1,
OBJECT=FIELD,
ITEM=2,
COLSPAN=1,
WRAP=ON,
JUSTIFY=RIGHT,
$
TYPE=SUBFOOT,
LINE=1,
OBJECT=FIELD,
ITEM=3,
BACKCOLOR=RGB(202 205 179),
$
TYPE=SUBFOOT,
BY=1,
LINE=1,
OBJECT=FIELD,
ITEM=3,
COLSPAN=1,
WRAP=ON,
JUSTIFY=RIGHT,
$
TYPE=SUBFOOT,
LINE=1,
OBJECT=FIELD,
ITEM=4,
BACKCOLOR=RGB(193 197 167),
$
TYPE=SUBFOOT,
BY=1,
LINE=1,
OBJECT=FIELD,
ITEM=4,
COLSPAN=1,
WRAP=ON,
JUSTIFY=RIGHT,
$
TYPE=SUBFOOT,
LINE=1,
OBJECT=FIELD,
ITEM=5,
BACKCOLOR=RGB(202 205 179),
$
ENDSTYLE
END
Unfortunately, when this report is referenced into a composer 'window', only the first BACKCOLOR command is being applied to the entire SUBFOOT row:
SET HTMLARCHIVE=ON
COMPOUND LAYOUT PCHOLD FORMAT PDF
UNITS=IN, $
SECTION=section1, LAYOUT=ON, METADATA='0.5^0.5^0.5^0.5^4', MERGE=OFF, ORIENTATION=PORTRAIT, PAGESIZE=Letter, SHOW_GLOBALFILTER=OFF, $
PAGELAYOUT=1, NAME='Page layout 1', text='Page layout 1', TOC-LEVEL=1, BOTTOMMARGIN=0.5, TOPMARGIN=0.5, METADATA='BOTTOMMARGIN=0.5,TOPMARGIN=0.5,LEFTMARGIN=0,RIGHTMARGIN=0,', $
COMPONENT='report1', TEXT='report1', TOC-LEVEL=2, POSITION=(0.833 0.833), DIMENSION=(6.667 4.063), METADATA='Z-INDEX: 100; LEFT: 0.833in; WIDTH: 6.667in; POSITION: absolute; TOP: 0.833in; HEIGHT: 4.063in', $
END
SET COMPONENT='report1'
-*component_type report
-INCLUDE newfex1.fex
COMPOUND END
Does anyone have any ideas?This message has been edited. Last edited by: Kerry,
Robert F. Bowley Jr. Owner TaRa Solutions, LLC
In WebFOCUS since 2001
April 06, 2011, 03:14 PM
Kerry
Hi Robert,
I passed this one to our internals, who did some testing in 7.7.02 and had no problem, which version are you using? You may want to open a case with Customer Support Services for further research. To open a case, please either call at 1-800-736-6130, or access online at InfoResponse.
Cheers,
Kerry
Kerry Zhan Focal Point Moderator Information Builders, Inc.
April 07, 2011, 10:00 AM
rfbowley
I have suggested that this client open a case on this. Since my work here is done, I will let them follow up on it.