JD Edwards FASTR Report Conversion

For JD Edwards World (iSeries) customers, Spreadsheet Server offers a utility to convert FASTR report definitions to Excel workbook formats. Using the template provided, users can select the FASTR program number and revision through the Get Report lookup feature, and convert the report to Excel format.

1. In Windows Explorer, navigate to C:\Documents and Settings\Users\Public\Public Documents\Global Software Inc\Spreadsheet Server\Components. Open the JD Edwards Fastr Template Excel spreadsheet, and enable the macros. The spreadsheet loads and a new FASTR menu is added to Excel.

2. In Excel, from the FASTR menu, select Get Reports. The Host Signon for Reports dialog box appears.

3. In the Host Signon for Reports dialog box, type the host name, user ID, and password, then click Sign On. The FASTR Reports panel appears.
4. In the FASTR Reports panel, specify the name of the library containing the FASTR reports, and click Show Reports. A list of reports appears.

5. Double-click the desired report to be converted. The conversion process creates an Excel workbook using the Program ID and Version ID as the name, and stores it in the location identified at the bottom panel.