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,

How about updating your profile to let us know what version and platform you work on? Self service applications or MRE?

WedFOCUS 7.6 Dev Studio windows xp

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.

Now is there something that will tell me where those reports are located?

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

No my boss would like a list of reports and where they are located.

Thanks this has helped.

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.

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