Exporting Drilldown Viewer to Excel sorts incorrectly

Entry Type: Informational

Product: FRx

Application: FRx Desktop

Version Reported: 6.7.9111

Subject:

Accounts are not sorting properly when exporting the Drilldown Viewer to Account Level to Excel.

Possible Resolution:

Select Full Account Code and the Sort GL accounts by check box:

1. In FRx Designer, open a Catalog of Reports.
2. Click Report Options. Click Acct/Tran Detail.
3. Select the Sort GL accounts by check box.
4. Click Full Account Code.
5. Generate the report.
6. In Drilldown Viewer, click File, Export, Worksheet File, and Formatted Excel or Excel.
7. Save the file to Excel format. Open the file using Microsoft Excel.