Error 9: "Subscript out of range" appears when exporting a report that contains a reporting tree to Excel

Entry Type: Program Issue

Product: FRx

Application: FRx Desktop

Version Reported: 6.7.8069

Status:

This issue is being researched by Engineering.

Subject:

Error 9: "Subscript out of range" appears when exporting a report that contains a reporting tree to Excel.

Steps to Duplicate:

In FRx for Sage MAS 90 and Sage MAS 200:

1. Open FRx Designer.
2. On the Company menu, click Select Default, and select the default company. Click the OK button.
3. Click the Catalog of Reports button, and select a report that contains a reporting tree.
4. Click the Output tab. On the Output Options tab, select Formatted Excel (.XLS) in the top list.
5. Select the following check boxes:
• Print Headings
• Print format rows
• Print underscore rows
• Export formulas
6. Click the Save button, and then click the Generate button. Error 9: "Subscript out of range" appears.

Expected Behavior:

The report should export without error.

Possible Workaround:

Clear either the Print Headings or the Export Formulas check box. If footers are used, removing the footer prevents the error.