I have a report that lists volumes and percentages by week. I would like to highlight/place in backcolor only specific rows. The data is presented across weeks and I have used OVER to align the fields vertically. The 1st column (OVER) and 1st week (ACROSS) are highlighted fine, but if there is more than one week, it is not highlighed the entire row across. I've tried changing the type from report to data and vice versa while playing around with different things and cannot get it to work. I would think it would be very simple, but know I am not using the right lingo. Can someone help? My code is below...

TABLE FILE SAMPLE
SUM TOTALS
OVER TOT_SIGNED
OVER COMPL
OVER COMPUTE PCTCOMPL/D15.1% = ( COMPL / TOTALS ) * 100;
OVER 48ANDUP
OVER COMPUTE PCT48ANDUP/D15.1% = ( 48ANDUP / TOTALS ) * 100;
OVER NEVER
OVER COMPUTE PCTNEVER/D15.1% = ( NEVER / TOTALS ) * 100;
OVER UNSIGNED_DEF
OVER COMPUTE UNSDF/D15.1% = ( UNSIGNED_DEF / NEVER ) * 100;
OVER UNSIGNED_NON_DEF
OVER COMPUTE UNSNOTDF/D15.1% = ( UNSIGNED_NON_DEF / NEVER ) * 100;
OVER COMPUTE TOTAL_PCT/D15.1% = (PCTCOMPL + PCT48ANDUP + PCTNEVER);
ACROSS WEEKDEFINEBEG AS 'WEEK'
ON GRAPH SET STYLE *
PAGESIZE='Letter',
LEFTMARGIN=0.250000,
RIGHTMARGIN=0.250000,
TOPMARGIN=0.250000,
BOTTOMMARGIN=0.250000,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=ACROSS, COLUMN=N4, BACKCOLOR='LIGHT GREY', STYLE=BOLD, $
TYPE=REPORT, COLUMN=N6, BACKCOLOR='LIGHT GREY', STYLE=BOLD, $
TYPE=REPORT, COLUMN=N8, BACKCOLOR='LIGHT GREY', STYLE=BOLD, $
TYPE=REPORT, COLUMN=N10, BACKCOLOR='LIGHT BLUE', STYLE=BOLD, $
TYPE=REPORT, COLUMN=N12, BACKCOLOR='LIGHT BLUE', STYLE=BOLD, $
TYPE=REPORT, COLUMN=N13, BACKCOLOR='LIGHT GREY', STYLE=BOLD, $
$
END

Condensed result would look like this with the PCTCOMPL and NEVER rows highlighted in grey across to 2/19, but not to 2/26:

WEEK
02/19/2012 02/26/2012
TOTALS 832 815
TOT_SIGNED 831 808
COMPL 712 712
PCTCOMPL 85.6% 87.4%
48ANDUP 119 96
NEVER 14.3% 11.8%

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

Would this be what you want?

  
TABLE FILE CAR
SUM 
     RETAIL_COST OVER 
     DEALER_COST OVER 
     SALES
ACROSS SEATS
ON TABLE SET HTMLCSS ON
ON TABLE NOTOTAL
ON TABLE SET STYLE *
     INCLUDE = endeflt,
$
TYPE=DATA,
     ACROSSCOLUMN=N1,
     BACKCOLOR=RGB(255 153 204),
$
TYPE=DATA,
     ACROSSCOLUMN=N3,
     BACKCOLOR=RGB(255 204 0),
$
ENDSTYLE
END

Hi Danny,

Great! Thank you...that worked. My first column is no longer highlighted now, but I can play around with that (or I may leave it as is since my data highlighted across is more so what I needed...)