12.2.1 Settings

You may register a report model to the project and output the report under the configured condition. To bring up the [Event Report] window, select [Tools] – [Event Report].

(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 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.

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.

(2) Register Report Data

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.

The sheet name assigned in the UltimateAccess Web must be identical to that of the form file. Also, the sheets configured in the 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.