|
|
The features on this page require a GENESIS64 Advanced license and are not available with GENESIS64 Basic SCADA . |
|
|
The features on this page require a GENESIS64 Advanced license and are not available with GENESIS64 Basic SCADA . |
Selecting Fault Data as a data source in ReportWorX 365 allows you to pick from either Causes Data or Incidents Data. These sources provide access to fault causes and incidents for use within Microsoft Excel.
Fault Data Selected in ReportWorX 365
The Causes Data data source provides access to fault causes for use within Microsoft Excel.
To Configure a Causes Data Report:
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.
In the ReportWorX 365 add-in, select the Fault Data data source type, and then the Causes Data data source type, as shown below.
Causes Data Selected
The Fault Data (Causes) task pane appears on the right-hand side of your screen, as shown below.
Configuring Causes Data Report
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.
Specific Date Time - Click this checkbox to activate the Start Date and End Date entries to configure a specific time range for specific incident causes.
Start Date - Enter a start date for the requested data in the text entry field. Or, click on the 
to open the date selector tool and select a date and/or click on the 
to open the time selector tool and select a time.
End Date - Enter an end date for the requested data in the text entry field. Or, click on the to open the date selector tool and select a date and/or click on the to open the time selector tool and select a time.
Retrieve Children - Click this checkbox to retrieve the children of any selected assets/data sources.
Page Size - Enter a page size for the retrieved data to be displayed within the current Microsoft Excel workbook. The default is 1000.
- This button completes the process by inserting the selected data to the cell(s) selected in the main section of Microsoft Excel.
Once you have clicked the Insert Data button, the report (the combination of column headers and requested data) should appear in the specified location.
Causes Data Report Example in Microsoft Excel
The Incidents Data data source provides access to fault causes for use within Microsoft Excel.
To Configure a Causes Data Report:
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.
In the ReportWorX 365 add-in, select the Fault Data data source type, and then the Incidents Data data source type, as shown below.
Incidents Data Selected
The Fault Data (Incidents) task pane appears on the right-hand side of your screen, as shown below.
Configuring Incidents Data Report
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.
Start Date - Enter a start date for the requested data in the text entry field. Or, click on the to open the date selector tool and select a date and/or click on the to open the time selector tool and select a time.
End Date - Enter an end date for the requested data in the text entry field. Or, click on the to open the date selector tool and select a date and/or click on the to open the time selector tool and select a time.
Retrieve Children - Click this checkbox to retrieve the children of any selected assets/data sources.
Page Size - Enter a page size for the retrieved data to be displayed within the current Microsoft Excel workbook. The default is 1000.
- This button completes the process by inserting the selected data to the cell(s) selected in the main section of Microsoft Excel.
Once you have clicked the Insert Data button, the report (the combination of column headers and requested data) should appear in the specified location.
Incidents Data Report Example in Microsoft Excel
See Also:
