I am Using Crystal Enterprise 10 and Crystal Reports 10. The problem I'm having is with reports which connect to the Remedy database. The Enterprise server is located in Washington DC and the Database is located in Oklahoma City. I am connecting to the middle tier of the Database through the Remedy ODBC. I have a login set up on the database side which is set to the Central Time Zone.
The only issue at this point is, when the reports run, all times in the reports are updated to Eastern Standard Time. When I open the database application with the same login I'm using for the ODBC to Crystal (which is set up for Central time) the database shows all the times in Central time. In order words, all the times in the reports are an hour off.
The only issue at this point is, when the reports run, all times in the reports are updated to Eastern Standard Time. When I open the database application with the same login I'm using for the ODBC to Crystal (which is set up for Central time) the database shows all the times in Central time. In order words, all the times in the reports are an hour off.