Reporting Services Tips – Weekend highlights for reporting clarity

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

Leave a Reply

Your email address will not be published.

Pin It on Pinterest