1
votes

I would like to change the first day of week in Microsoft SQL Server Reporting Service 2008 R2 Date calendar.

This issue was found in SSRS 2005 and it should not be in SSRS 2008 R2.

Right Now the WeekDays are starting from Sunday - Saturday. I would like to Change it from Saturday-Friday.

Please check the Calendar for the month: June 2012.

Right Now Date Calendar is in below manner: Sunday - Saturday

S | M | T | W | T | F | S

I want in Below Manner: Saturday - Friday

S | S | M | T | W | T | F

I checked Microsoft Website for solution and this was issue in Micorosf SQL Server Reporting 2005.

Please help me over this.

Many Thansk & Regards

Sikander

1

1 Answers

0
votes

Check this link for changing the first day. It might not answer your question, but could be helpful @@DATEFIRST.

The SET DATEFIRST 5 will only change it for that session. Also, you will probably loose the change if the server/service is restarted. You could work around this by using the SET DATEFIRST inside your reports.