Transaction detail is missing when generating a report to a formatted Excel file in FRx

Entry Type: Program Issue

Product: FRx

Application: FRx Desktop

Version Reported: 6.710343 (SP 10)

Status:

Resolved on FRx version 6.7.11027 (SP 11)

SMR #194596

Subject:

Transaction detail is missing for all units except the last unit of the tree when generating a report to a formatted Excel file.

Steps to Duplicate:

  1. On the FRx File menu, point to New, and then click Row.
  2. On the Edit menu, click Add Rows from Chart of Accounts.
  3. Click OK.
  4. Click Save, and then enter a name and description.
  5. On the File menu, point to New, and click Column.
  6. Add the following information:
  7. Click Save, and enter a name and description.
  8. On the File menu, point to New, and click Reporting Tree. 
  9. On the Edit menu, click Add Reporting Units from Chart of Accounts.
  10. Click OK.
  11. Click Save, and enter a name and description.
  12. On the File menu, point to New, and click Catalog.
  13. From the Detail Level list, select Financial & Transaction.
  14. Click the Building Blocks tab, and select the column, row, and reporting tree created above.
  15. Click the Output Tab and select Formatted Excel from the drop-down list.
  16. Click Save and enter a name and description
  17. Click the Generate Report button.
  18. Click Mark All and OK.
  19. Browse to and open the exported file.
  20. Note that the only worksheet of the workbook that includes all transaction detail columns is the last reporting unit selected when the report was exported.

Expected Behavior:

The report should have all of the column information requested for every detail worksheet of the workbook. 

Possible Workarounds:

Perform any of the following: