When looking at a monthly report showing all the days of the month it can help to split up the days by highlighting the weekends.
We do this by applying a change in background colour (in each column) with the method below;
=IIF(LEFT(WeekdayName(Weekday(DATEADD(DateInterval.Day,5,Parameters!StartDate.Value),2)),1)=“S”,“Whitesmoke”,“White”)
Replace the number 5 with the day of the month for each cell or use a formula.
The results are:
Reporting Services Tips – Weekend highlights for reporting clarity