logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
Ott  
#1 Posted : Tuesday, January 09, 2018 9:56:45 PM(UTC)
Ott

Rank: Member

Groups: Registered
Joined: 6/9/2017(UTC)
Posts: 14
Canada

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
epf  
#2 Posted : Wednesday, January 10, 2018 10:59:03 AM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 476
Switzerland

Thanks: 7 times
Was thanked: 68 time(s) in 66 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

Ott  
#3 Posted : Friday, January 12, 2018 3:09:28 PM(UTC)
Ott

Rank: Member

Groups: Registered
Joined: 6/9/2017(UTC)
Posts: 14
Canada

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.
epf  
#4 Posted : Monday, January 15, 2018 8:07:32 AM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 476
Switzerland

Thanks: 7 times
Was thanked: 68 time(s) in 66 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: http://forum.sealreport....posts&t=469#post1091 that shows where to fin the scripts (Server Manager -> Configuration -> Configure Server)
Users browsing this topic
Guest (2)
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.

Powered by YAF 2.0.0 | YAF © 2003-2018, Yet Another Forum.NET
This page was generated in 0.067 seconds.