Monday, January 21, 2013 11:15 AM
I am using ssrs reports and displaying some dates and time information.
when i run a report in server machine where reporting services are running, i get the date and time getting displyed in the Time zone of that server machine.
But, when i run a report in a machine other than the server where the reporting services are running (a client machine) and check for the time related information it is displayed in the Time zone of the server machine only, whereas the date and time information should be displaying in the client machine time zone only.
I am using the below expression to convert to local Time zone.
I tried to understand the issue with this and found that the SSRS expressions are executed in the server where the reporting services are running and hence the above expression is taking the time zone of the server machine.
Can you help me and suggest a way to display the date and time related information getting displayed based on the time zone of the client machine or the machine where i am generating the report.
Monday, January 21, 2013 11:57 AMhttp://msdn.microsoft.com/en-us/library/bb677244.aspx
Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/
MS SQL optimization: MS SQL Development and Optimization
MS SQL Blog: Large scale of database and data cleansing
Remote DBA Services: Improves MS SQL Database Performance
Monday, January 21, 2013 12:49 PMYou can specify the format to the date columns to which your client follows.
Monday, January 21, 2013 1:19 PM
Please mark as answered or vote helpful if this post help resolved your issue. Thanks!
k r o o t z