How to create Report Listings

You have two possibilities to create a new Report Listing:

To create a Report Listing, you have two choices:

If you now open the Create menu, you see the item Report Listing... enabled. Clicking on this item opens the Create Report Listing dialog. With this dialog you can generate a Postprocessor job and start it on the remote system. The created Report Listing contains the reports selected in the Options dialog (see How to specify Postprocessor report types) and covers the time range specified in the Intervals dialog (see Figure 1).

In the RMF™ Postprocessor Data Sets group box from the Create Report Listing dialog, you specify whether to download the generated Report Listing:

Figure 1. Create Report Listing
Create Report Listing dialog. This dialog is accessible from the Spreadsheet Reporter product which provides accessible help information.

In the example from Figure 1, with multiple SMF input data sets selected and an optional local file name specified, the Run button starts the following processing:

  1. The data set with the name IBMUSER.D254.T162349.LISTING shown in the Remote entry field is allocated on the host system. This suggested name indicates the current date and time (see also Report Listings for naming conventions). You may accept or overtype this name.
  2. A job that uses the specified SMF data sets as input is created and sent to the host. For the job creation, the Spreadsheet Reporter uses a job skeleton that is stored in the installation directory in subdirectory \Connect\rmfpp1.jcl. If you need additional parameters or records (for example, a //STEPLIB record), you can modify the skeleton according to your requirements.
    Note: The Spreadsheet Reporter uses the rmfpp1.jcl job skeleton also for the creation of Overview Records, Working Sets, and XML reports.

    The generated reports are stored as a Report Listing in the allocated remote data set from step 1.

  3. This remote data set is transferred to your workstation with the file name suggested in the Local entry field (which you may overtype). Thus, you create a new Report Listing both as remote and local resource. You can use the local resource to create a Working Set later.

Use File ---> Transfer ... to create a local Report Listing from a remote Report Listing (that is, downloading an RMF Postprocessor data set containing a Report Listing).

If you receive a Report Listing, for example by mail attachment, you may want to import this listing locally to the RMF Spreadsheet Reporter for further processing. You must store this data set with file extension .lis or .xml in subdirectory '…\RmfListings' of that directory that you specified during installation as the resource directory. The default is:
C:\Documents and Settings\Administrator\Application Data\RMF\
   RMF Spreadsheet Reporter\RmfListings
Then you can convert this Report Listing to a Working Set to use it in a spreadsheet macro, or if it is an XML type listing, view it in a web browser for further analysis.