sql server reporting services: Reporting in Local time -- sql server reporting services

Reporting in Local time

KarenM
10/2/2006 11:34:46 PM

sql server reporting services:

Our company head office is in LA. But we have global operations. Users
create sales orders and purchase orders across the globe and all data
in stored on the SQL server in LA. But our users wants reporting in
their local time meaning a user raising a sales order on 1st Oct 2006
in Japan at 8 AM local time is still 30th Sept 2006. Users in Japan
want a report to show orders raised on 1st Oct 2006 but the date on the
sales order is 30th Sept 2006 and it will not show the right orders.

How can we provide reporting to accomodate the local time based
reporting to our users.

Thanks
Karen

Re: Reporting in Local time

Kaisa M. Lindahl Lervik
10/3/2006 12:00:00 AM

MS CRM 3.0 has solved this problem by making all the users save their
regional time in the database, and there are functions in their db that does
the conversion between the user's local time and the server time.
You could probably store the location of all the users centrally in your
database, and then do some conversions based on this information. I'm not
sure if you can use RS to get the local system time on the user's computer,
which is why you need to store it "somewhere" in the database.

Kaisa M. Lindahl Lervik

[quoted text, click to view]