Export a report in Desktop Viewer

  • Article

Management Reporter can export a report to a XPS document or an Excel spreadsheet. If you have export permission, you can export a reporting tree, a current reporting unit, or a current view. When you work with a detailed report, you can also export the entire financial report, including all the supporting details, or you can export specific detail reports. For more information about security and export permissions, see Set up and manage users and groups.

This topic contains the following sections:

  • Export a report to Microsoft Excel

  • Export a report to an XPS document

Prerequisites

The following table shows the prerequisites that must be in place before you complete the tasks in this topic.

Category

Prerequisite

Related configuration tasks

Specify your default import and export file directory.To change the default import and export file directory for the current user, open Desktop Viewer.

  1. On the Tools menu, click Options to open the Options dialog box.

  2. In the Default import and export file directory field, type or browse for a new default file directory.

  3. Click OK.

Report definition output and distribution parameters

For each of your report definitions, select the default options for exporting reports to Excel. For more information, see Output and Distribution tab settings.

Export a report to Microsoft Excel

  1. In Desktop Viewer, click Report Library in the navigation pane, and then double-click a report to open it.

  2. On the File menu, click Export, and then click Microsoft Excel (.xslx).

  3. In the Export to Microsoft Excel dialog box, in the Export data to field, enter a path and file name to export the report to, or click Browse to locate a path and file name. The file name that you specify must end in .xlsx or .xls.

  4. Under Export range, select one of the following options:

    • Current View – Exports the current view of a report.

    • Current Reporting Unit – Exports the current reporting unit of a reporting tree.

    • Selected Reporting Units – Open a dialog box where you can select the reporting units to export.

    • All Reporting Units – Export all reporting units in a reporting tree.

  5. Under Report type, select one or more of the following options:

    • Financial report – Export only the financial report.

    • Account details – Export only the account detail report.

    • Transaction details – Export only the transaction detail report.

    • Exception report – Export only the exception report.

    Note

    Report type options are not available if you select Current View for the Export range option.

  6. To export any comments that are attached to the report, select Include comments.

  7. Under Microsoft Excel options, select one or more of the formatting and file options.

    Note

    If you select Export formulas check box, row formulas that you included in your report are also exported into Excel. Some restrictions apply, see Export a report in Desktop Viewer.

  8. Click OK. If you selected Open workbook after exporting, the report will open in Microsoft Excel. Otherwise, it is saved to the location that you specified in step 3.

Export a report to an XPS document

  1. In Desktop Viewer, click Report Library in the navigation pane, and then double-click a report to open it.

  2. On the File menu, click Export, and then click XPS.

  3. In the Export to XPS dialog box, in the Export data to field, enter a path and file name to export the report to, or click Browse to locate a path and file name. The file name that you specify must end in .xps.

  4. Under Export range, select one of the following options:

    • Current View – Export the current view of a report.

    • Current Reporting Unit – Export the current reporting unit of a reporting tree.

    • Selected Reporting Units – Open a dialog box where you can select the reporting units to export.

    • All Reporting Units – Export all reporting units in a reporting tree.

  5. Under Report type, select one or more of the following options:

    • Financial report – Export only the financial report.

    • Account details – Export only the account detail report.

    • Transaction details – Export only the transaction detail report.

    Note

    Report type options are not available if you select Current View for the Export range option.

  6. To export any comments that are attached to the report, select Include comments.

  7. Select the width of the report columns, or select Autofit to automatically size the columns.

  8. Under XPS options, select one or more of the formatting and file options.

  9. Click OK. If you selected Open XPS after exporting, the report will open in Microsoft Document Viewer. Otherwise, it is saved to the location that you specified in step 3.

Management Reporter formulas in Excel

When you export a report to Excel, some calculations of formulas within the Excel spreadsheet might differ from the Management Reporter report. The following sections provide information to help set your expectations about how rounding, column restrictions, and formulas are handled when you export them to Excel.

Rounding

The report definition settings for rounding and processing order might cause calculation differences between the report in Management Reporter and the exported Excel spreadsheet.

Example: Your report definition settings indicate that No rounding is specified

Management Reporter

Excel

Cash Bank A

925.56

925.56

Cash Bank B

437.66

437.66

TOT

1363.22

1363.22

Example: Your report definition settings indicate that the report values should be rounded to the whole number and the processing order is set to apply rounding first, then perform calculations.

Management Reporter

Excel

Cash Bank A

926

926

Cash Bank B

438

438

TOT

1364

1364

Example: Your report definition settings indicate that the report values should be rounded to the whole number and the processing order is set to perform calculations first and then apply rounding.

Management Reporter

Excel

Cash Bank A

926

926

Cash Bank B

438

438

TOT

1363

1364

TOT row formulas

Row formulas will only be exported to Excel for the Detail Level of Financial.

CALC column formulas

CALC Column formulas are not exported to Excel.

CAL row formulas

CAL row formulas are not exported to Excel.

Side by Side reports

When you export Side by Side Management Reporter reports to Excel, regardless of your Excel Report definition options, formulas are not exported.

Column restrictions

Reports that include rows with column restriction or references to rows with column restrictions, any formulas in that row definition for the entire row are not exported.

Non-printing (NP) rows

Rows that have Print Control set as Non-printing (NP) will be exported to Excel, however they will be 'hidden' in Excel. 

Calculation priority

If the calculation priority on the report definition is set to Perform row calculation first and then column, and if your report includes cells that have a column formula and a TOT row formula, the formula in those cells will not be exported.

See Also

Desktop Viewer