Exporting Financial Reporting Reports and Snapshots to Microsoft Office

HTML and PDF reports with or with a page dimension, when exported as an image to Microsoft Word or PowerPoint, exports only the first physical page.

A report with a page dimension behaves as follows:

  • Export to Microsoft Excel—All pages are exported.

  • Export to Microsoft PowerPoint—All pages are exported.

Note:

When exporting multiple pages to PowerPoint, all pages are placed in a single slide. To have them automatically placed in separate slides, use Oracle Smart View for Office in PowerPoint to import the reports.

  To export a report or snapshot to Microsoft Excel, Word, or PowerPoint:

  1. Open the report.

  2. Select Export in Query-Ready Mode to export a grid on the report as query ready.

    This option is located at the bottom of the report. You cannot use this option to export snapshots.

  3. Select File, and then Export to use other export options,

  4. Select a submenu command:

    • To export the current financial report as formatted HTML, select Excel.

    • To export the current page of the current financial report to Microsoft Word as a static image, select Word.

    • To export the current page of the current financial report to Microsoft PowerPoint as a static image, select PowerPoint.

      Snapshots are always exported as static images.

      The File Download dialog box displays profile information about exported content.

      Because of limited object positioning in HTML, exported objects may overlap and may need to be repositioned in Microsoft Excel.

  5. The file is opened in the selected mode. To save the file to your machine, select File, and then Save As.

Note:

When exporting Financial Reporting grid objects to Excel, the values are exported as displayed in the report. The desired number of decimal places for precision should be set in the report before you export.