I have created an HTML report using OVER. I am needing to have the alternating background color appear also on the second line where the BY fields are. See example below......I would like to see the green or yellow color on BOTH lines of Region and State instead of the white color. Any ideas on how to do this?

 -* File backgroundcolor.fex
TABLE FILE GGSALES
PRINT 
     'GGSALES.SALES01.CITY' AS '' OVER 
     'GGSALES.SALES01.CATEGORY' AS ''
     'GGSALES.SALES01.PRODUCT' AS ''
BY 'GGSALES.SALES01.REGION'
BY 'GGSALES.SALES01.ST'
HEADING
""
FOOTING
""
ON TABLE SET PAGE-NUM OFF 
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = GREENBAR,
$
     UNITS=IN,
     PAGESIZE='Letter',
     LEFTMARGIN=0.500000,
     RIGHTMARGIN=0.500000,
     TOPMARGIN=0.500000,
     BOTTOMMARGIN=0.500000,
     SQUEEZE=ON,
     ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
     GRID=OFF,
     FONT='TIMES NEW ROMAN',
     SIZE=10,
     RIGHTGAP=0.125000,
     TOPGAP=0.013889,
     BOTTOMGAP=0.027778,
$
ENDSTYLE
END
 

This message has been edited. Last edited by: Kerry,

Could you post the contents of greenbar.fex so we can have a complete running code?

Greenbar is the style sheet.....I just picked one.....use any style sheet you want that has alternating backgroud colors for the detail lines.

I think posting greenbar would be very helpful, as we do not know what is in it.

Here is my gestimate.

TABLE FILE GGSALES
PRINT 
     'GGSALES.SALES01.CITY' AS '' OVER 
     'GGSALES.SALES01.CATEGORY' AS ''
     'GGSALES.SALES01.PRODUCT' AS ''
BY 'GGSALES.SALES01.REGION'
BY 'GGSALES.SALES01.ST'
HEADING
""
FOOTING
""
ON TABLE SET PAGE-NUM OFF 
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     UNITS=IN,
     PAGESIZE='Letter',
     LEFTMARGIN=0.500000,
     RIGHTMARGIN=0.500000,
     TOPMARGIN=0.500000,
     BOTTOMMARGIN=0.500000,
     SQUEEZE=ON,
     ORIENTATION=PORTRAIT,$
TYPE=REPORT,
     GRID=OFF,
     FONT='TIMES NEW ROMAN',
     SIZE=10,
     RIGHTGAP=0.125000,
     TOPGAP=0.013889,
     BOTTOMGAP=0.027778,$
TYPE=DATA, COLUMN=P1, BACKCOLOR=(yellow silver), $
TYPE=DATA, COLUMN=P2, BACKCOLOR=(yellow silver), $

ENDSTYLE
END

Is this doing what you want or is it what you are currently getting ?

It's not actually possible to do the styling required by Mark.

The output genertated when using OVER uses empty TD tags to space the columns and as such
cannot be styled. (if using DHTML then it uses absolute positioning with the tags for cells completely missing)

<TD class='x2_0'>
Midwest</TD>
<TD class='x3_0'>
IL</TD>
<TD>
Chicago</TD>
</TR>
<TR>
<TD></TD>
<TD></TD>
<TD>
Coffee</TD>
<TD>
Espresso</TD>
</TR>  

or for DHTML

 <div style="position:absolute;top:102pt;left:45pt;width:47pt; text-align:left;" class='x2_1'>Midwest</div>
<div style="position:absolute;top:102pt;left:101pt;width:29pt; text-align:left;" class='x3_1'>IL</div>
<div style="position:absolute;top:102pt;left:139pt;width:138pt; text-align:left;">Chicago</div>
<div style="position:absolute;top:115pt;left:139pt;width:48pt; text-align:left;">Coffee</div>
<div style="position:absolute;top:115pt;left:205pt;width:81pt; text-align:left;">Espresso</div> 

Thanks for your insight and help.