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     [CLOSED] WebFOCUS Inventory

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] WebFOCUS Inventory
 Login/Join
 
<d3nis370>
posted
I was wondering if there is a way that I can print a list of all the reports I have made in WebFOCUS?

This message has been edited. Last edited by: Kerry,
 
Report This Post
Expert
posted Hide Post
How about updating your profile to let us know what version and platform you work on? Self service applications or MRE?


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
<d3nis370>
posted
WedFOCUS 7.6 Dev Studio windows xp
 
Report This Post
Expert
posted Hide Post
I suggest looking at the APP QUERY command.

APP QUERY TEST

 03/11/2008 12.56.25      888 1coltest.fex
 05/08/2004 10.48.40     2015 20040805_10.48.38_HOLDCAR.TXT
 19/04/2005 19.30.16     2015 20050419_19.30.14_HOLDCAR.TXT
 10/08/2007 14.09.56     1293 2coltest.fex
 02/04/2009 10.35.39      816 ACHRFD001.fex
 02/04/2009 10.22.18     2148 ACHRFD001.mas
 29/04/2004 17.08.28      135 BADTEST.fex
 03/08/2007 09.25.32      464 BASEL_NCR_PD_PCT.MAS
 ...

Developing Reporting Applications > Creating and Working With Applications > Reports and Help

This command creates a list of files within one or more Application Folders. Unfortunately it does not differentiate between file types - all files are listed. The data can be sent to a HOLD file for further processing.

In Windows, you cannot determine which user created a file, so you really cannot "print a list of all the reports I have made".

For MRE, one quick method is to read the HTML file that contains the MRE repository structure, usually located at C:\ibi\WebFOCUS76\basedir\mrrepos.htm. There are entries for programs within virtual folders within domains.


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
<d3nis370>
posted
Now is there something that will tell me where those reports are located?
 
Report This Post
Expert
posted Hide Post
You have created reports that you don't know the location of?

One way to determine where a fex is (if it is in an Application folder) is by running the WHENCE command:

WHENCE TEST1 FOCEXEC

Result:
C:\ibi\apps\fmarian\test1.fex


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
<d3nis370>
posted
No my boss would like a list of reports and where they are located.

Thanks this has helped.
 
Report This Post
Expert
posted Hide Post
What you can do is a dos dir command against ibi\apps and direct the output to a file. Create a generic master, i.e. LINE100 with one field of A100, and point it to your directory listing. Using POSIT, SUBSTR, etc., you can pull out pieces of each line and create a nice WebFOCUS report from it. This would make a great active report if you are licensed for that.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
Expert
posted Hide Post
Another way to show the FEXes that you have is with SYSFILES.

It does rely on what your path is set to though.

SQL FMI SET SYSFILES FOCEXEC
TABLE FILE SYSFILES
PRINT *
END


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report 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     [CLOSED] WebFOCUS Inventory

Copyright © 1996-2020 Information Builders