PROGRAM ISSUE ** THIS INFORMATION HAS NOT BEEN VERIFIED **
"Run-time error '9': Subscript out of range" when exporting detailed report with current selection or current reporting unit to Excel
Entry Type: Program Issue
Product: Sage MAS 500 ERP
Application: FRx
Version Reported: 6.7.9111, 6.7.10343
Status:
This issue is being researched by Engineering.
Subject:
"Run-time error '9': Subscript out of range" when exporting detailed report with current selection or current reporting unit to Excel
Steps to Duplicate:
- Open FRx Designer
- On the Company menu, click Select Default and select the default company. Click on the OK button.
- Click the Catalog of Reports button and select a report that contains a reporting tree
- Click Generate Report button and select Mark All button and click OK to generate report on screen
- Select a unit and click File / Export / Worksheet File / Excel (XLS,XLSX)
- Click Save button and in Export Selection select the following options
Detail (supporting) report
Export Range = Current selection or Current reporting unit - Click 'OK' button and notice error comes up
Expected Behavior:
Should export report to Excel with out errors
Possible Workaround:
Export to Formatted Excel works and change export selection: Selecting Export Range = Entire tree does not give error.