Develop > Operational Reports > Installing Crystal Reports > Time Zones Settings for Reporting

Time Zones Settings for Reporting

Crystal Report uses the ODBC driver to access the Service Manager database. When an operator creates or updates a record, the date information will be stored into the database using the coordinated universal time (UTC) scale. When an operator queries a record in the database, the ODBC driver will convert the UTC date to the operator’s time zone as defined in the login profile. Hence the converted date is displayed in the Service Manager client’s UI.

In case the Service Manager server and the Service Manager client are running in different time zones with varied operator time zone configurations, you can refer to the following table for a record’s date information displayed in client’s UI.

Operator Time Zone 1Note the Operator refers to the operator account which is used to log in to the ODBC driver. The Operator Time Zone refers to the time zone setup in an operator’s login profile.

Server System Time Zone

Database Time Zone

Record Time Displayed

N/A

N/A

UTC

UTC

N/A

Defined

UTC

Server system time zone

Defined

N/A

UTC

Operator time zone

Defined Defined UTC Operator time zone

From the table, it can be concluded that:

  • If neither the operator time zone nor the server system time zone is defined (null value), date information will be stored in the database using the UTC scale. The date will be displayed as the UTC scale in client (including Eclipse RCP Client, Web tier Client and Crystal Reports).
  • If the operator time zone is null and the server system time zone is defined, a record’s date information will be stored into the database using the UTC scale. But the date will be converted and displayed as the system time zone.
  • If the operator time zone is defined and the server system time zone is null, a record’s date information will be stored into the database using the UTC scale. But the date will be converted and displayed as the operator time zone.
  • If both the operator time zone and the server system time zone are defined, a record’s date information will be stored into the database using the UTC scale. But the date will be converted and displayed as the operator time zone.

Make sure the computer on which the Crystal Reports is running has the same time zone setup with the operator time zone, or has the same time zone setup with the sever time zone in case the operator time zone is null.

To configure the system time zone for Service Manager:

  1. Log on to Service Manager with a system administrator account.
  2. From the System Navigator, click System Administraton > Base System Configuration > Miscellaneous > System Information Record.
  3. Click Date Info to open the tab.
  4. In the Time Zone field, select the new time zone for the server system.

  5. Click Save.

To set the time zone for an individual operator:

  1. Log in to the Service Manager system with a system administrator account.
  2. From the System Navigator, click System Administration > Ongoing Maintenance > Operators.
  3. Type the login name of the specified operator in the Login Name field.
  4. Click Search. Detailed profile of the specified operator is displayed in the Operator Record page.
  5. Click Login Profiles to open the tab.
  6. In the Time Zone field, select the new time zone for the operator.

  7. Click Save.

Note To apply the updated operator login profile, you need to log off and then log in to the Service Manager server again by using the operator’s account. There is no need to restart the Service Manager service. However, the Service Manager ODBC driver accesses the Service Manager database via legacy service and you must restart the ServiceCenter service manually.

For more information about how to start the ServiceCenter service, refer to Service Manager Installation.