I would like to point at issue of changing background of column in crosstab.
Mentioned crosstab is generated from table attendance.
EmpID - Number
ReasonOfAbsent - Text
DateOfAbsent - Text
RowLines - EmpID
Columns - DateOfAbsent
CrossCell(data) - ReasonOfAbsent
Everything goes fine, but there is problem to highlight columns, which corespond with Weekend so Saturday and Sunday with other color.
I have written a formula to detect weekdays but in preview mode it is without effect.
Formula to change background color of cell (whole column):
Cond(Dow(tb.DateOfAbsent) = 6 OR Dow(tb.DateOfAbsent) = 7,LL.Color.Green, LL.Color.White)
Do you have any suggestions?
Note: Could it be a bug? The is no problem to highlite concrete cell or line (or odd line) but whole column there is. I do not understand.