Rank: Member
Groups: Registered
Joined: 6/9/2017(UTC) Posts: 29  Thanks: 1 times
|
Hello,
Our application stores all times as GMT times in a central database, with no offset for the local time. We have users in multiple time zones running reports against the central database.
I would like to know if there is a setting in the Seal Report Designer (desktop and Web versions) that can be set to automatically adjust the time to the local time where the report is being run? This question applies to both times entered as parameters and reported on the report output.
Thanks
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209  Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
|
Good question, actually there is nothing in SR to handle this... I wonder how to do it (probably in the engine when date time are converted...), could be a feature request. Sponsors or contributors are welcomed. Edited by user Monday, January 15, 2018 8:01:51 AM(UTC)
| Reason: Not specified
|
|
|
|
|
|
Rank: Member
Groups: Registered
Joined: 6/9/2017(UTC) Posts: 29 Thanks: 1 times
|
A new parameter could be added to the Data Source definition to indicate that time conversion would need to be performed based on the data source's native time zone. The parameter would contain the data source's time zone. When defined, this parameter could then be used by the report generator to convert the times to the time zone where the report generator is installed. The time conversion would apply to both times entered as report parameters and times displayed in the report output.
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209 Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
|
As the time will depend on the user login, you could use some scripts to adapt dynamically your data sources depending on the login (e.g. change the SQL of your date time column to include the time offset). With this, you do not have to change the report engine. Check the post: https://sealreport.org/f...posts&t=469#post1091 that shows where to fin the scripts (Server Manager -> Configuration -> Configure Server)
|
|
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
