Current Values

ReportWorX 365 allows you to display data, within Microsoft Excel, that OPC UA tags collect in real time.

 

To Configure a Current Values (Real-time Data) Report:

  1. Open the ReportWorX 365 add-in in Microsoft Excel. (See Installing ReportWorX 365 for more info). Place your cursor within the Microsoft Excel sheet where you wish the report data to appear.

  2. In the ReportWorX 365 add-in, select the Current Values data source type, as shown below.

Current Values Selected

  1. The Current Value task pane appears on the right-hand side of your screen, as shown below.

    Configuring Report Containing Current Values

Users can utilize the file explorer section of ReportWorX 365 to navigate to their desired data source.

 

The following navigation items can be used:

 - Move up one folder level in the file explorer

- Move to the top folder level in the file explorer

- Add the selected item. Note that you can add multiple contiguous items by holding the Shift key or multiple individual items by holding the Ctrl key.

 

-  This button updates with the number of selected items. Clicking the button when one or more items have been selected changes the file explorer view to a file selection view, showing the data source items that have been added via the button. In the file selection view, you can remove any selected data source by clicking on the [X] button to the right of its name.

  1. - This button completes the process by inserting the selected data to the cell(s) selected in the main section of Microsoft Excel.

  2. Once you have clicked the Insert Data button, the report (the combination of column headers and requested data) should appear in the specified location.

Current Values Report Example in Microsoft Excel

 

See Also:

Dimension Data

Energy Data

Fault Data

Historical

Quality Data