This procedure is used to export data from a dataset to a file. The data can then be processed and displayed in Microsoft Excel.
Select program 'Sales Stats/Budget. Print' (OSS417).
Specify the report ID, year, period number, and report level. Note that relative periods used for the report column are calculated from this period number and year. A transfer file is created and placed in library QRPLOBJ. If the file was already created from previous runs, the contents will be changed. This file is created for direct transfer to PC or server, and is therefore deleted during the next initial program load (IPL) by the AS/400.
Transfer the file to PC or server using a file transfer tool.
Retrieve the file in the desired tool for further processing or display.