I'm using Report Builder 2.0 to construct a report that contains datetime data stored in the database as UTC time. Is there a way to convert the UTC time to local time of the computer viewing the report?
Thanks.
A:
use this: TimeZone..::.ToLocalTime Method
look here too: http://www.windows-tech.info/15/9115c76955a6a6e1.php
KM
2010-03-17 19:10:17
Wait.. It seems that this solution uses the time zone of the Report Server.. Not the time zone of the client viewing the report. :(
James Jones
2010-03-17 19:50:40
@James Jones, that is what the second link explains., that link also says that the only solution is to have the client pass in the desired time zone, so the report can generate based on that. There is no other way (than client passing a parameter) for a report to be generated on a server, yet know the client's time zone.
KM
2010-03-18 11:25:11
Ah, I see. Thanks for the explanation.
James Jones
2010-03-18 12:34:56
A:
I seem to have stumbled upon the answer to my question. The Data Source View lets you specify whether a column holds local time or UTC time under the "DateTimeMode" property.
James Jones
2010-03-25 20:09:37