Focal Point
[CASE-OPENED] Composer Behavior

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/7787073106

April 01, 2011, 12:03 PM
rfbowley
[CASE-OPENED] Composer Behavior
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.


Robert F. Bowley Jr.
Owner
TaRa Solutions, LLC

In WebFOCUS since 2001