I'm writing a report in Crystal Reports where it basically shows an annual calendar of all the different types of absences employees might have had during the year, though my client said he wants to see the weekends marked differently.
I have tried using a formula on the borders this way:
IF DayOfWeek (CurrentDate) = 7 or DayOfWeek (CurrentDate) = 1 then crRed
else crNoColor
No error is given, but nothing is presented in red on the report once I generate it when its Saturday or Sunday.
Am I going the right way?