Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

(1)   Configuration of the Model

Item

Description

Model Name

Enter the name of the Report model. The name cannot duplicate.

Begin Time

Set the time value to begin the report data acquisition. You can set hour and minute.

Begin Condition

Set the condition to begin the report data acquisition. You can use the conditions such as ‘A tag value is greater than an assigned value’ or ‘When an alarm occurs’.
E.g.) If you entered START_EVENT_REPORT == 1, the report data acquisition starts when the value of ‘START_EVENT_REPORT’ tag becomes 1.

Output Time

Set the time value to output the report. You can set hour and minute.

Output Condition

Set the condition to output the report. You can use the conditions such as ‘A tag value is greater than an assigned value’ or ‘When an alarm occurs’.
E.g.) If you entered START_EVENT_REPORT == 1, the report data output starts when the value of ‘START_EVENT_REPORT’ tag becomes 1

Period Time

Set the time value of the data acquisition interval. You can set hour, minute and second.

Period

Set the condition of the data acquisition interval. You can use the conditions such as ‘A tag value is greater than an assigned value’ or ‘When an alarm occurs’.
E.g.) If you entered COLLECT_DATA == 1, the report data is acquired each time the value of ‘COLLECT_DATA’ tag becomes 1.

Format

Select the report format. You can only select the Excel format.

Register Tag

Assigns the content and position of data which will be output in the report.

Custom Form

Assign the absolute path of the predefined report form as Excel file.

Delete Remain Data

The event report deletes the acquired data after report output. When you do not output the report and terminate the

CIMON-SCADA

UltimateAccess Web, the acquired data are saved as ‘EventReport.mdb’ in the project folder.

When you select this option, the remained data are deleted at the beginning of the new report data acquisition.

Output

Determines the output type of the report. When you select the option and deselect the [Print Out] option in [Register Tag], the report is saved only as a file.

To Save

Overwrite

Saves the report as an assigned file name. If a file with identical name exists, the file is overwritten.

Change Name

Saves the report as a file named YYYYMMDDHHMM.xls. (YYYY: Year, MM: Month, DD: Day, HH: Hour, MM: Minute, xls: Excel file extension)

Attach

This function is currently not supported.

Save In

Saves the report file in the assigned path according to the option selected at ‘To Save’.

Overwrite

Assign the file name including the path. If the path is omitted, the report file is saved in the project folder.

Change Name

Assign the path where the report file will be saved. You can use [...] button to browse the folder. The path must be different from any other report model.

Add

Adds a new report model.

OK

Saves the change in the report model.

Delete

Deletes the selected report model.

Panel
panelIconIdatlassian-warning
panelIcon:warning:
bgColor#4C9AFF
  • If you have not reset the ‘Begin Condition’, the event report model outputs the report only once and does not begin the data acquisition again. Therefore, to output the report continuously, you must reset the ‘Begin Condition’ after a report output.

...

Select [Register Tag] button in [Event Report] window to bring up the [Register Report Data] window. You can assign the contents and the position of the data to be saved in the report.

...

Item

Description

Print Out

You can print the contents of selected sheet under the assigned condition, with the printer connected to your PC.

Add Sheet

Enter the name of new sheet and press [OK]. The sheet name has to be identical to that of the form file. The name cannot duplicate.

Delete Sheet

Deletes the selected sheet from the report data.

Change Name

Changes the name of the selected sheet. The name cannot duplicate.

Add Cell

Adds a new cell. You can enter the data to output at the report.

Edit Cell

Edits a selected cell.

Delete Cell

Deletes a selected cell from the sheet.

OK

Saves the contents to the event report model and returns to the [Event Report] window.

Cancel

Cancels the changes made in the window and returns to the [Event Report] window.

Panel
panelIconIdatlassian-warning
panelIcon:warning:
bgColor#4C9AFF
  • The sheet name assigned in the CIMON-SCADA UltimateAccess Web must be identical to that of the form file. Also, the sheets configured in the CIMON-SCADA UltimateAccess Web must exist in the form file either.

(3)    Edit Cells

...

Item

Description

Cell

Assign a cell number where the data will be saved.

E.g.) To write the value of ‘Tag1’ to the cell ‘C1’, you have to enter C1 in the ‘Cell’ field and ‘Tag1’ in the ‘Tag Name/Operation Expression’ field.

When you assign the cell, you cannot use the cells in a same row, such as A1, A2, A3. The cells must be aligned in a column like A1, B1, C1.

Also, even if the ‘Period Time’ is set as 1 second, you cannot acquire 86400 a day since the excel supports the maximum 65535 rows.

Browse

Browse the tag from the Database.

Tag Name / Operation Expression

When you enter the tag name, the report outputs the corresponding tag value. You can also enter the operation expression.

Write Data

Writes the assigned tag value to the specified cell.

OK

Saves the configuration and returns to the [Register Report Data] window.

Cancel

Cancels the configuration and returns to the [Register Report Data] window.