Viewing Trend log Report data with Excel output

  • You have selected an existing Report Definition in System Browser > Reports or you have created a new Report Definition.
  • The new excel format is supported for Trend log reports. This generates an excel report output which consists of common DateTime column, for each series a single column is generated with header as trended object/custom text with its units, alias and its data as series value.
  1. Click the Home tab.
  1. Do one of the following step to insert a table. Ensure that you are not inserting the table in the header/footer section of the report definition:
  • Click Table and insert Trends table from drop-down list.
  • Right-click the report definition, select the Trends table type from the Insert Table option.
  • Drag the desired Trend View Definition from System Browser on the Report Definition.
    The Name filter of the inserted table is set to the dropped Trend View
  • The table is added to the report definition with its default columns.
  1. Click Run and generate a Report summary.
  1. Click Create and view excel .
  • A dialog box displays asking you to save a copy of the excel report on your machine.
  1. You can also generate report output as follows:
  • Click the Settings tab, from the Report Output group box click Dialog Launcher .
  • The Report Output Definition dialog box displays.
  1. Select File in the Destination types list. Select Excel in the Report format list.
  • Browse the local drive path and save the report.
  • You can also share the report through mail.
  • The Report output in new excel format appears as given in image below