Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [Solved] Displaying Local time in report

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[Solved] Displaying Local time in report
 Login/Join
 
Penubarthi
Member
posted
Hi,

I have a scenario where i need to display the current local date and time for an active html report.

User enters a region and some other criteria's to generate the report. We also need to display the exact date and time at which it was run. I tried to get the time based on the market region which he selects(finding the time difference b/w market selected and EST time from webfocus).

But the issue is that, we need to generate the local time irrespective of market selected. Is there any way to capture time from his/her machine instead.

Eg : If a user runs a report for Germany region but he is in Italy he needs Italy's time instead of Germany.

User will be able to select only one region at runtime. Any ideas?


Thanks
Krishna

This message has been edited. Last edited by: Penubarthi,


Webfocus 7.7,
DB : Oracle, Teradata
O/P : PDF, Excel, EXL2K, Pivot
 
Posts: 10 | Registered: July 10, 2014Report This Post
jvb
Gold member
posted Hide Post
quote:
User will be able to select only one region at runtime. Any ideas?

Its little confusing, do you want to publish time based upon the region for which report is generated or based upon the location from where user is generating the report.
In later case, we need to know the location from where user is generating the report.This information can be stored in some table, and further based upon the time zone difference the date/time can be manipulated to be displayed in the report.


WF 8.1.04,Infoassist,Oracle, Excel, PDF,HTML.
 
Posts: 82 | Registered: January 06, 2014Report This Post
Penubarthi
Member
posted Hide Post
I need to display the time based on the location from where user is generating the report.
 
Posts: 10 | Registered: July 10, 2014Report This Post
Rifaz
Guru
posted Hide Post
Do we have any environmental settings/variables to capture the local machine time?


-Rifaz

WebFOCUS 7.7.x and 8.x
 
Posts: 406 | Location: India | Registered: June 13, 2013Report This Post
<FreSte>
posted
Would this be OK?. Using the user's system to determine the time ??


-SET &RETCODE = SYSTEM(20,'TIME/T > TMPTIME.TXT','D4');
FILEDEF TMPTIME DISK TMPTIME.TXT
-RUN
-READ TMPTIME,&TMPTIME
-RUN
-? &T
 
Report This Post
GavinL
Master
posted Hide Post
Also, since it's HTML, you can edit the code and add some JavaScript..

http://www.w3schools.com/js/tr...e=tryjs_timing_clock



- FOCUS Man, just FOCUS!
-----------------------------
Product: WebFOCUS
Version: 8.1.04
Server: Windows 2008 Server
 
Posts: 578 | Registered: October 01, 2014Report This Post
jvb
Gold member
posted Hide Post
Following topic may help you:
http://forums.informationbuild...1057331/m/6371036992


WF 8.1.04,Infoassist,Oracle, Excel, PDF,HTML.
 
Posts: 82 | Registered: January 06, 2014Report This Post
Rifaz
Guru
posted Hide Post
Thanks FreSte and Vivek Eeker


-Rifaz

WebFOCUS 7.7.x and 8.x
 
Posts: 406 | Location: India | Registered: June 13, 2013Report This Post
Penubarthi
Member
posted Hide Post
Hi,

Thanks for all the replies.
Here is the solution that worked out finally.

I created a hidden text box and passed the local time of machine using javascript NewDate() function and stored it in webfocus as a param variable.

It worked!!

Thanks
Krishna
 
Posts: 10 | Registered: July 10, 2014Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [Solved] Displaying Local time in report

Copyright © 1996-2020 Information Builders