I have written a report to lookup users like this:
APP LIST HOLD
TABLE FILE focappl
PRINT *
END

Is there a similar report to grab a list of ALL reports, and possibly who created them?

Thanks!

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

The sample you gave is not to lookup users, it's a report that show all your application folders

Each of those folders can have fexes (among other file types of course).
Below you'll find an example on how to get a list of files for each application folder. The example returns a list with ALL files in ALL folders; the creator is not on the list (I wonder if that's possible).

... and this example will only give you a list with files for the application-path. All fexes/reports created within MRE are not on the list. That requies another approach.

-Fred-

APP LIST HOLD
TABLE FILE FOCAPPL
  PRINT APPNAME
  ON TABLE HOLD AS HLDAPP FORMAT ALPHA
END
-RUN
-SET &NUM_APP = &LINES;

FILEDEF ALLFILES DISK ALLFILES.FTM (APPEND
-RUN

-REPEAT :GETFILES FOR &I FROM 1 TO &NUM_APP ;
-READ HLDAPP &APPNAME.A64.

APP QUERY &APPNAME HOLD
TABLE FILE FOCAPPQ
  PRINT *
  ON TABLE HOLD AS ALLFILES FORMAT ALPHA
END
-:GETFILES

TABLE FILE ALLFILES
  PRINT *
END