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     [CASE-OPENED] Naming of Versions in Report Library

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CASE-OPENED] Naming of Versions in Report Library
 Login/Join
 
Silver Member
posted
I have a number of reports that are being sent to the report library. I am using a HTML composer page where using a listbox the user can select the version of the report to run. What I am looking to do is to have instead of "Version 1" and so forth listed there that they would be a date and time the report ran so then the user can select the version of the report they want to see and run it. I've checked in the documentation and here and haven't seen anyway to do that. Does anyone have a way?

This message has been edited. Last edited by: <Kathryn Henning>,


8.1.0.4
Windows 7
Excel, AHTML, HTML,PDF
 
Posts: 41 | Location: North Carolina | Registered: September 14, 2012Report This Post
Expert
posted Hide Post
How are you creating your listbox? I'd like to see the code.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Expert
posted Hide Post
Unfortunately, we cannot name the reports stored in Report Library. The only thing I can think of doing is providing the date/time the report version was created, but that doesn't help much.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Silver Member
posted Hide Post
So based on documentation I have used what I found at this link

Integrating Report Library

Even If I was able to do that I think that would be sufficient for what I'm trying to do.


8.1.0.4
Windows 7
Excel, AHTML, HTML,PDF
 
Posts: 41 | Location: North Carolina | Registered: September 14, 2012Report This Post
Silver Member
posted Hide Post
I think it may be nice to possibly submit a NFR to have this done in the advanced schedule tool. Do you agree?


8.1.0.4
Windows 7
Excel, AHTML, HTML,PDF
 
Posts: 41 | Location: North Carolina | Registered: September 14, 2012Report This Post
Expert
posted Hide Post
Absolutely - we need an NFR to be able to properly name the reports. They could have an additional column with the report name as set inside the fex, using the stylesheet syntax TYPE=REPORT, TITLETEXT=...

Meanwhile, this is a hand-coded fex that lists all the versions for a report (you will have to change the WHERE statement for your report). I have included all the columns of three tables that are involved in the Report Library entries. The fex could be modified to output the data for a dropdown list instead of a report. One issue is that the EXECUTION_TIME and EXECUTION_DATE are stored in some kind of "epoch" date/time, but the numbers themselves seem to be too high for the current epoch conversion routines, so it might be something else.

JOIN WF_NLSOBJ.OBJ_HANDLE IN wfrsmgmt/WF_NLSOBJ TO WF_REPOSOBJ.HANDLE IN wfrsmgmt/WF_REPOSOBJ AS J1
JOIN WF_REPOSOBJ.EXT_ID IN wfrsmgmt/WF_NLSOBJ TO ALL BOTLIB.REPORTGID IN wfrsmgmt/BOTLIB AS J2
-RUN

-SET &GMT_OFFSET_HOURS = -4;

TABLE FILE wfrsmgmt/WF_NLSOBJ
PRINT
SEG.WF_NLSOBJ.OBJ_HANDLE
SEG.WF_REPOSOBJ.HANDLE
SEG.BOTLIB.REPORTGID

COMPUTE ICASTERBASE/I8YYMD = 19700101; NOPRINT
COMPUTE CASTERBASE/YYMD = ICASTERBASE; NOPRINT

COMPUTE EXECUTION_TIME_X/A13 =  SUBSTR(32, EXECUTION_TIME, 20, 32, 13, EXECUTION_TIME_X); NOPRINT
COMPUTE EXECUTION_TIME_NUM/D13 =  EDIT(EXECUTION_TIME_X); NOPRINT

COMPUTE CASTERBASEDTM/HYYMDS = DT(19700101 00:00:00Z); NOPRINT

COMPUTE EXECUTION_DTTM_TEMP/HYYMDS = HADD(CASTERBASEDTM, 'MILLISECONDS', EXECUTION_TIME_NUM, 8, 'HYYMDS'); NOPRINT
COMPUTE EXECUTION_DTTM/HYYMDS = HADD(EXECUTION_DTTM_TEMP, 'HOUR', &GMT_OFFSET_HOURS, 8, 'HYYMDS');

BY OBJDESC NOPRINT
BY VERSION NOPRINT
WHERE
WF_NLSOBJ.PRT_PATH LIKE '%Library_Content/Cash%'
END
-RUN

-*http://dviappvmwebf03/ibi_apps/lib-report.rc?&id=7f219632I6c69I45e2Ia1bdI64c9ff3630f3&BIDrand=687
-*http://dviappvmwebf03/ibi_apps/lib-report.rc?&id=7f219632I6c69I45e2Ia1bdI64c9ff3630f3&version=50&IBIWF_SES_AUTH_TOKEN=498dde196f305d5483ab162affd37efb
* Updated to include code to convert EXECUTION_TIME to human-readable date/time, as per Susannah's tip, Zulu Time – How to Read the ReportCaster Schedule File. I don't have a clue if Daylight Savings Time is applied...

Note that you will have to generate metadata for these Repository and Report Caster tables.

This message has been edited. Last edited by: Francis Mariani,


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Silver Member
posted Hide Post
thanks I'm going to try this. When you do this, do you include in each fex or do you have this be it's own fex and then do an include in each fex so you can pull in the paramaters.

I'm just trying to determine how this would work in how I have this formatted within the HTML page in the listbox. It could be when they click on the Version it shows a table below with this information and then run the report.


8.1.0.4
Windows 7
Excel, AHTML, HTML,PDF
 
Posts: 41 | Location: North Carolina | Registered: September 14, 2012Report 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     [CASE-OPENED] Naming of Versions in Report Library

Copyright © 1996-2020 Information Builders