Export Options

The export options are available on the top right side of the SA report header for easy access.

 

 

Directly linking a report to an Excel Report

In addition to exporting an entire report to an excel file, individual item tables can be directly linked to Excel (*.xls). This provides the ability to specify the workbook address for report items, using either absolute sheet/col/row or named cell references.

To use this directed export capability an Excel file must first be selected using the Connect to Excel button.

Once a connection to an Excel file has been established a Synchronize button will be come visible. This global “Synchronize” operation will output all report items to the connected spreadsheet for which a valid workbook address has been established.

The connected Excel file remains open as a background process while a report is connected to it. The changes made will therefore, not up- date the associated Excel file until the connection has been terminated using the Disconnect from Excel button and the “Save” option performed.