I have tried hard, but unable to get the alternate coloring for the 2nd column of my report that is the Column Title, using OVER command.
Can any anyone point, what I am missing.Below is the car fex for the issue repro.

I am using OVER in my fex, so second column, that looks like rows data is actually a Column title, and I want it to be alternate shading.Alternate coloring does not get applied, using the below code.The same gets applied in the first column though.

Fex Code:
==========
TABLE FILE CAR
SUM
COMPUTE CNTR/I11 = CNTR + 1; NOPRINT
COMPUTE NEWMOD/I3L = IMOD(CNTR, 2, NEWMOD); NOPRINT
BY CAR AS ''


SUM
DC OVER AS 'set1'
DC OVER AS 'set2'
DC OVER AS 'set3''
DC OVER AS 'set4'
DC OVER AS 'set5'
DC OVER AS 'set6'
DC OVER AS 'set7'
BY CAR AS ''
ACROSS COUNTRY NOPRINT
ACROSS COUNTRY AS ''
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SUBHEAD
"Run Date: 23/01/2015"
"Report ID: Testing team"
"Daily Test Run Details"
-*""

FOOTING
" "
"Report Run By: EDA Tester"
"This is the Testing details Report"
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TYPE=REPORT, TITLETEXT='RPT NAME', $
-*TYPE=REPORT, FONT = 'ARIAL', SIZE=8, BORDER=1, $
TYPE=REPORT, FONT = 'ARIAL', SIZE=8, $

-*Styling for CAR first BY Field
TYPE=DATA,COLUMN=N1, BACKCOLOR=RGB(193 213 243), WHEN=NEWMOD EQ 0,$
TYPE=DATA,COLUMN=N1, BACKCOLOR=RGB(222 235 246), WHEN=NEWMOD EQ 1,$


-*Conditional Styling on OVER Fields
TYPE=TITLE, ACROSSCOLUMN=N1, BACKCOLOR=RGB(193 213 243), WHEN = NEWMOD EQ 1, $
TYPE=TITLE, ACROSSCOLUMN=N2, BACKCOLOR=RGB(193 213 243), WHEN = NEWMOD EQ 1, $
TYPE=TITLE, ACROSSCOLUMN=N3, BACKCOLOR=RGB(193 213 243), WHEN = NEWMOD EQ 1, $
TYPE=TITLE, ACROSSCOLUMN=N4, BACKCOLOR=RGB(193 213 243), WHEN = NEWMOD EQ 1, $
TYPE=TITLE, ACROSSCOLUMN=N5, BACKCOLOR=RGB(193 213 243), WHEN = NEWMOD EQ 1, $
TYPE=TITLE, ACROSSCOLUMN=N6, BACKCOLOR=RGB(193 213 243), WHEN = NEWMOD EQ 1, $
TYPE=TITLE, ACROSSCOLUMN=N7, BACKCOLOR=RGB(193 213 243), WHEN = NEWMOD EQ 1, $
TYPE=TITLE, ACROSSCOLUMN=N8, BACKCOLOR=RGB(193 213 243), WHEN = NEWMOD EQ 1, $

TYPE=TITLE, ACROSSCOLUMN=N1, BACKCOLOR=RGB(222 235 246), WHEN = NEWMOD EQ 0, $
TYPE=TITLE, ACROSSCOLUMN=N2, BACKCOLOR=RGB(222 235 246), WHEN = NEWMOD EQ 0, $
TYPE=TITLE, ACROSSCOLUMN=N3, BACKCOLOR=RGB(222 235 246), WHEN = NEWMOD EQ 0, $
TYPE=TITLE, ACROSSCOLUMN=N4, BACKCOLOR=RGB(222 235 246), WHEN = NEWMOD EQ 0, $
TYPE=TITLE, ACROSSCOLUMN=N5, BACKCOLOR=RGB(222 235 246), WHEN = NEWMOD EQ 0, $
TYPE=TITLE, ACROSSCOLUMN=N6, BACKCOLOR=RGB(222 235 246), WHEN = NEWMOD EQ 0, $
TYPE=TITLE, ACROSSCOLUMN=N7, BACKCOLOR=RGB(222 235 246), WHEN = NEWMOD EQ 0, $

TYPE=DATA, BORDER =0.5, $

TYPE=REPORT,COLUMN=P1,SIZE=8,BACKCOLOR=RGB(193 213 243),STYLE=BOLD,WRAP=1.2,$
TYPE=ACROSSVALUE,SIZE=8,WIDTH=.1,BACKCOLOR=RGB(193 213 243),JUSTIFY=CENTER,STYLE=BOLD,WRAP=0.9,BORDER =0.5,$

TYPE=TITLE,COLUMN=CAR,JUSTIFY=LEFT,WRAP=1.5,$

TYPE=SUBTOTAL,SIZE=8,HEADALIGN=BODY,BACKCOLOR=RGB(255 153 0),STYLE=BOLD,$
TYPE=GRANDTOTAL,SIZE=8,BACKCOLOR=RGB(255 153 0),STYLE=BOLD,$
TYPE=SUBHEAD,SIZE=8,STYLE=BOLD,BORDER=OFF,$
TYPE=FOOTING,LINE=1,FONT = 'ARIAL',SIZE=8,JUSTIFY=LEFT, $
TYPE=FOOTING,LINE=2,SIZE=8,FONT = 'ARIAL',JUSTIFY=LEFT, $
TYPE=FOOTING,LINE=3,SIZE=7,FONT = 'ARIAL',JUSTIFY=LEFT, $
TYPE=FOOTING,LINE=4,SIZE=7,FONT = 'ARIAL',JUSTIFY=LEFT, $
TYPE=FOOTING,BORDER=OFF,$
TYPE=TABHEADING, LINE=1,JUSTIFY=RIGHT,BORDER=OFF,SIZE=7, $
TYPE=TABHEADING, LINE=2,JUSTIFY=RIGHT,BORDER=OFF,SIZE=7, $
TYPE=TABHEADING, LINE=3,JUSTIFY=LEFT,BORDER=OFF,SIZE=12,STYLE=BOLD,$
========

The same styling should be defined for the data-rows.
Add the following line to your stylesheet:

TYPE=DATA ,BACKCOLOR=(RGB(222 235 246) RGB(193 213 243)) ,$

Gurpreet Singh,

You can do formatting by using TYPE=TITLE. Looks like conditional formatting is not supported for title string generated using OVER command.

Thanks,
Ram

quote:

Originally posted by FreSte:
The same styling should be defined for the data-rows.
Add the following line to your stylesheet:

TYPE=DATA ,BACKCOLOR=(RGB(222 235 246) RGB(193 213 243)) ,$

Column titles are regarded as part of the Report, but not part of its Data.

Because of the way titles are normally positioned (above the column of data cells), they have no tie to data values in individual rows; and BACKCOLOR=(color1, color2) is thus inapplicable.

Since in a report with OVER and ACROSS the title can appear to the left of each row (positioned as if it were a data columns), IBI should revise their treatment of Titles to allow alternating and conditional styling in such reports, and to address other problems as well.