Versions Compared

Old Version 7

changes.mady.by.user trichar2

Saved on

compared with

New Version 8

changes.mady.by.user trichar2

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: update to new version

AnchorTopTopData and Analytics report data may be exported to other popular applications popular formats such as Excel and Adobe AcrobatPDF.
You may export one or multiple report views. This is dependent upon the number of tabs for the report.

The following topics are covered:

Table of Contents

Export to Excel

To export to Excel:

  1. Run a report. 
  2. Click on Image Added Export icon. See Figure 1. 
    Image RemovedImage Added
    Figure 1: Mapping for "How to Save." Click image to enlarge.  
     

  3. Select Export Document

    As. This will export

    As or Export Current Report As.

    Info

    Export Document As - this option includes all tabs of the current document as separate worksheets.

    Export Current Report As - this option only includes the active report / tab. 

  4. Select the appropriate Excel format (.xls or .xlsx).  
  5. A File Download dialog box will display. You may either Open or Save the Excel file. See Figure 2.

Image Modified

 Figure 2: File Download Dialog Box. Click image to enlarge.     

Note

If you choose Open, Excel will launch and the report data will be displayed with tabs appearing as different worksheets within Excel.


If you choose Save, you will be prompted to name and save the file.

 

...

When exporting to Excel, formulas are not transferred so each cell only contains the displayed value from the document.

Export as a PDF

To export as a PDF file:

  1. Run a report.
  2. Click on Image Added Export icon (See Figure 1).

  3. Select Export Document

    As. This will export

    As or Export Current Report As.

    Info

    Export Document As - this option includes all tabs of the current document with each tab starting on a new page.

    Export Current Report As - this option only includes the active report / tab. 

     

  4. Select PDF.
    A File Download dialog box will display similar to Figure 2 above. 
  5. You may either 
    • Open
    • Save

Back to top

Modify Report Layout

There may be times when the layout of a report does not suit your needs. D&A provides the flexibility to modify the way your report data is displayed. You can even graph report data by creating charts.
To modify a report layout:

...

Right-click and select Turn table to… . See Figure 3. 

Note

Right-click options will vary depending on the report and HART license.

Image Removed

...

Back to top

Chart and Table Types

The available table formats are; Horizontal, Vertical, Cross-tab, and Form. The available charts include; Bar, Line, Area, Pie, and Radar. See Figure 4.

Image Removed
Figure 4: Available Chart and Table Types. Click image to enlarge.

...