SQL Reporting Services 2005 Local Time Zone

Question

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

When using SQL Reporting Services, we want to display this data in the time zone of the client workstation, but it seems like using an expression like:

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

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

Is there a way to perform this conversion locally or pass the local time zone to the server for conversion?

Thanks in advance Matt

Answer 1

If your reports are autonomous, I see no other option than the time zone report option.

-, JavaScript , urlparameter postback.

( ).

GeoIP .NET.