Ask our Experts
Didn't find what you are looking for? Ask our experts!
Schneider Electric support forum about installation, configuration, integration and troubleshooting of EcoStruxure Geo SCADA Expert (ClearSCADA, ViewX, WebX).
Search in
Link copied. Please paste this link to share this article on your social media post.
Posted: 2022-11-04 05:03 AM . Last Modified: 2023-05-02 11:51 PM
Hello,
I'm using Crystal Report for reporting in Geo SCADA. When i generate any report, it's created a report in the time i want and have a problem in this situation: I also using SQL Query for report and these datas get correctly. (My local time is GMT +3). But in Crystal Report the same datas have different time, it arrives 3 hours ahead of my local time. I tried the "ShiftDateTime" command but nothing happened. Is the solution of this problem command or anything else? I'm sharing two screenshot about the same day.
This screenshot is Crystal Report format. The first data is 225.34 on 1st August at 12 A.M. Later 214.62, 210.39, 195.02...
This screenshot is the format by using SQL Query. The first data is 225.34 on 31th July at 9 P.M. Later 214.62, 210.39, 195.02...
I need to your help.
Link copied. Please paste this link to share this article on your social media post.
Link copied. Please paste this link to share this article on your social media post.
Posted: 2022-11-04 05:52 AM
Have you checked the "Local time" option in the ODBC data source that you are using for the Crystal Reports? If you haven't the server will return times in UTC.
See Configure the ODBC DSN Settings for details.
Link copied. Please paste this link to share this article on your social media post.
You’ve reached the end of your document
Create your free account or log in to subscribe to the board - and gain access to more than 10,000+ support articles along with insights from experts and peers.