Generating a report to use in a spreadsheet

After you generate a report using the appropriate spreadsheet option, you can transfer the data to a spreadsheet. Do this if you want more options for manipulating and formatting the data. This procedure describes the process for generating a report to use in a spreadsheet.

  1. Access Report Generation (RW100). Follow the steps outlined in the procedure for defining a report.

    See Defining a report.

  2. In the Options field, select Report/Spreadsheet (3), Report/Spreadsheet/Drill Around (5), or Report/XML File/Spreadsheet (A).
  3. After the report is generated, access the Print Files in the Job Scheduler.
  4. In Print Files, view the report that you want to export. The path name is at the top of the form.
    Note: Make note of the path name for the report. You need this path name to transfer the file from the Lawson server to a PC.
  5. At the operating system, move to the directory where the file is stored by following the path name:

    LAWDIR/print/user-id/jobname/step#/job#

  6. The file name created by the application is the report name that you used on Report Writer (RW00.1) and preceded by SS (for example, SSBALSHEET02).
  7. Use a transfer utility program (such as ftp) to transfer the Report Writer file to your PC.
  8. Launch your spreadsheet software and open the file that you transferred to your PC.