SQL Reporting Services 2005 local time zone

Question

We store our date/time information in UTC format on our SQL Server.

When using SQL Reporting Services, we'd like to display this data in the time zone of the client workstation, but it appears that using an expression like;

System.TimeZone.CurrentTimeZone.ToLocalTime(Fields!DateStarted.Value)

... converts into the time zone of the server, not of the client workstation?

Is there any way of performing this conversion locally, or passing the local time zone to the server for conversion?

Thanks in advance Matt

score 1 · Answer 1 · edited May 23 '17 at 12:13

1

If your reports are standalone I can't see other option than add timezone report parameter.

But if you using reports inside web application, you can Determine Timezone from Request Variables with JavaScript and send time zone value back in hidden fields, urlparameter or postback.

You can also add timezone to user registration info (or figure it out from Country and City fields).

Also you may try Target Your Visitors Using GeoIP and .NET.

edited May 23 '17 at 12:13

Community

1
1

answered Mar 09 '09 at 15:56

Maksym Gontar

22,765
10
78
114

Yes, agree. SSRS has no support for timezones but these workaround apply. – gbn Mar 09 '09 at 19:32
The "Determine Your Visitor's Time Zone ..." link appears broken. I couldn't find it on the site. – Anthony K Jan 20 '10 at 01:03

SQL Reporting Services 2005 local time zone

1 Answers1