SSRS - VS 2012 - Date/Time format is being reported where server is.. WRONG!!!!!!!!!!!

• Question

• 

  

  0

  Sign in to vote

  Hi all, I created a report in VS 2012, and I want to have a field to show when this report was downloaded. I want to report:
  

  1) Date: dd-MMM-yyyy
  2) Time
  3) Time Zone from which report was downloaded, e.g. EST

  The problem I am having is that when I run the report, the time always shows where servers are so I always get time for CUT. Is there a way to either:

  1) show time where user is based, so time based on specific time zone, OR
  2) just show one specific time for CET(central Europe time) zone for ALL users.. I just don't want the time to be reported in CUT.

  Any feedback much appreciated

  Thanks so much

  Dan

  Thursday, December 11, 2014 2:38 PM