Hello,

I have a seemingly simple issue: I have data that's sorted by date, which is printed (split into its components) as an ACROSS column. I want to highlight the columns that reflect a specific day of the week (in my case all Sundays).
The problem is that not every date has corresponding data, so I end up with a lot of empty, unstylable, cells.

For example, how do I highlight the entire Wednesday column in below?:

DEFINE FILE SALES
	SDat/I4MD = EDIT(DATE);
	LDat/I8YYMD = 20000000 + SDat;

	Year/YY		= LDat;
	Month/Mt	= LDat;
	Day/D		= LDat;
	Weekday/W	= LDat;
	WDay/A1		= DECODE Weekday(1 'M' 2 'T' 3 'W' 4 'T' 5 'F' 6 'S' 7 'S');
END
TABLE FILE SALES
SUM
	UNIT_SOLD
BY STORE_CODE AS 'Store'
ACROSS Year AS 'Date'
ACROSS Month AS ''
ACROSS Day AS ''
ACROSS WDay AS ''
END

Mind that with more data, as weeks repeat, there will be multiple Wednesdays on each row, which all need to be styled with a BACKCOLOR.

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

This ugly code ensures there is a store sales value for every date in the request - either zero or the database value if it exists. I can't seem to style the weekday across value though... (My example styles Thursday as there is more than one across value).

-* File fpwep1.fex

-SET &ECHO=ALL;

SET PAGE=NOLEAD
SET HOLDLIST=PRINTONLY
-RUN

TABLE FILE SALES
SUM
DATE NOPRINT
COMPUTE DUMMY1/A1 = '';
BY DATE
ON TABLE HOLD AS H001 FORMAT FOCUS INDEX DUMMY1
END
-RUN

JOIN DUMMY1 WITH UNIT_SOLD IN SALES TO ALL DUMMY1 IN H001 AS J1
-RUN

DEFINE FILE * CLEAR
-RUN

DEFINE FILE SALES
SDat/I4MD   = EDIT(H001.DATE);
LDat/I8YYMD = 20000000 + SDat;
Year/YY     = LDat;
Month/Mt    = LDat;
Day/D       = LDat;
Weekday/W   = LDat;
WDay/A1     = DECODE Weekday(1 'M' 2 'T' 3 'W' 4 'T' 5 'F' 6 'S' 7 'S');
DUMMY1/A1   = '';
END
-RUN

TABLE FILE SALES
SUM
WDay NOPRINT
COMPUTE UNIT_SOLD/D7 = IF SALES.DATE EQ H001.DATE THEN UNIT_SOLD ELSE 0; AS ''

BY STORE_CODE AS 'Store'
BY DATE NOPRINT

ACROSS Year AS ''
ACROSS Month AS ''
ACROSS Day AS ''
ACROSS WDay AS ''

ON TABLE SET STYLE *
TYPE=DATA, ACROSSCOLUMN=UNIT_SOLD, WHEN=WDay EQ 'T', BACKCOLOR=YELLOW, $
-*TYPE=ACROSSVALUE, ACROSS=N4, BACKCOLOR=YELLOW, WHEN=N4 EQ 'T', $
END
-RUN