12.1.2 Settings
- CIMON (Unlicensed)
To bring up the [Report] window, double-click the [Report] on the Project Workspace or select [Tools] – [Report].
(1) Model Settings
Item | Description | |
Model Name | Enter the name of the report model. The name cannot be duplicated. | |
Report Type | Daily | Outputs the report daily. You can configure the output time. (Hour, Minute) |
Weekly | Outputs the report weekly. You can configure the output time. (Day of the week, Hour, Minute) | |
Monthly | Outputs the report monthly. You can configure the output time. (Date, Hour, Minute) | |
Yearly | Outputs the report yearly. You can configure the output time. (Month, Date, Hour, Minute) | |
Others | Outputs the report when the condition is true. | |
Output Time | Assign the output time according to the report type. | |
Output | This field is activated when the report type is ‘Others’. The condition example is as shown below. E.g.) When the condition is ‘PRINT_REPORT == 1’, the report is printed when the tag value of ‘PRINT_REPORT’ becomes 1. | |
Report Form By | Select the file format of the report form. | |
Excel Worksheet | Select this option if the report form is in Excel file. Microsoft Excel must be installed in the user’s PC. | |
Word Document | Select this option if the report form is in Word file. Microsoft Word must be installed in the user’s PC. | |
Virtual Excel Worksheet | Select this option if there is an Excel form file but no Microsoft Excel in the user’s PC. | |
Register Tag | Assign 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. | |
Output | Determines the output type of the report. | |
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) | |
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. | |
(2) Register Report Data
Select [Register Tag] button in [Event Report] window to bring up the [Register Report Data] window. You can specify 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 with the printer connected to your PC. |
Save As Text File | This option appears only when the form file is in Excel format. You can save the report file as “ModelName_SheetName”.txt format in the project folder. |
Add Sheet | This button is activated only when the form file is in Excel format. 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 be duplicated. Be aware that certain strings cannot be used as the sheet name.
|
Delete Sheet | Deletes the selected sheet from the report data. |
Change Name | Changes the name of the selected sheet. The name cannot be duplicated. |
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. |
When you add cells to the ‘Register Report Data’, you can utilize increment/decrement functionality of the Excel.
In ‘Register Report Data’ window, select the data and copy to the clipboard (Ctrl + C).
Paste (Ctrl + V) to the new sheet of the Excel file.
You can drag the lower-right corner of the cell to increase/decrease the time based data.
Copy (Ctrl + C) the edited area of the Excel to the clipboard.
Paste (Ctrl + V) to the data list of the ‘Register Report Data’ window.
The list of invalid strings for the sheet names are as shown below.
Alphabet | Invalid Strings |
A | ADD, ALL, Alphanumeric, ALTER, AND, ANY, Application, AS, ASC, Assistant, AUTOINCREMENT, Avg |
B | -B, BETWEEN, BINARY, BIT, BOOLEAN, BY, BYTE |
C | -C, CHAR, CHARACTER, COLUMN, CompactDatabase, CONTRAINT, Container, Count, COUNTER, CREATE, CreateDatabase, CreateField, CreateGroup, CreateIndex, CreateObject, CreateProperty, CreateRelation, CreateTableDef, CreateUser, CreateWorkspace, CURRENCY, CurrentUser |
D | -D, DATABASE, DATE, DATETIME, DELETE, DESC, Description, DISALLOW, DISTINCT, DISTINCTROW, Document, DOUBLE, DROP |
E | -E, Echo, Else, End, Eqv, Error, EXISTS, Exit, |
F | -F, FALSE, Field, Fields, FillCache, FLOAT, FLOAT4, FLOAT8, FOREIGN, Form, Forms, FROM, Full, FUNCTION |
G | -G, GENERAL, GetObject, GetOption, GotoPage, GROUP, GROUP BY, GUID |
H | -H, HAVING, |
I | -I, Idle, IEEEDOUBLE, IEEESINGLE, If, IGNORE, Imp, IN, INDEX, Index, Indexes, INNER, INSERT, InsertText, INT, INTEGER, INTEGER1, INTEGER2, INTEGER4, INTO, IS |
J | -J, JOIN, |
K | -K, KEY |
L | -L, LastModified, LEFT, Level, Like, LOGICAL, LOGICAL1, LONG, LONGBINARY, LONGTEXT |
M | -M, Macro, Match, Max, Min, Mod, MEMO, Module, MONEY, Move |
N | -N, NAME, NewPassword, NO, Not, Note, NULL, NUMBER, NUMERIC |
O | -O, Object, OLEOBJECT, OFF, ON, OpenRecordset, OPTION, OR, ORDER, Orientation, Outer, OWNERACCESS |
P | -P, Parameter, PARAMETERS, Partial, PERCENT, PIVOT, PRIMARY, PROCEDURE, Property |
Q | -Q, Queries, Query, Quit |
R | -R, REAL, Recalc, Recordset, REFERENCES, Refresh, RefreshLink, RegisterDatabase, Relation, Repaint, RepairDatabase, Report, Reports, Requery, RIGHT |
S | -S, SCREEN, SECTION, SELECT, SET, SetFocus, SetOption, SHORT, SINGLE, SMALLINT, SOME, SQL, StDev, StDevP, STRING, SUM |
T | -T, TABLE, TableDef, TableDefs, TableID, TEXT, TIME, TIMESTAMP, TOP, TRANSFORM, TRUE, Type |
U | -U, UNION, UNIQUE, UPDATE, USER |
V | -V, VALUE, VALUES, Var, VarP, VARBINARY, VARCHAR |
W | -W, WHERE, WITH, Workspace |
X | -X, Xor |
Y | -Y, Year, YES, YESNO |
(3) Edit Cells
Item | Description |
Cell | Specify 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 |
Key | Finds the assigned keyword in the Word document and replace the data with the selected item in the [Tag Name/Operation Expression]. E.g.) When the keyword in the Word document is ‘Value1’, and the assigned tag name is ‘Tag1’, the value of ‘Tag1’ will be printed at the location of the ‘Value1’. |
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. |
Read Data | Reads the value of selected cell and saves to the tag assigned to [Tag Name/Operation Expression]. |
Write Data | Writes the assigned tag value to the specified cell. |
Repeat Input | Used for the batch process of the repetitive input to the cell. |
No. Of Repeats | This option is activated when the ‘Repeat Input’ option is selected. Assign the number of repeats. the cell number and the tag value of the tag name will increase by 1. You cannot assign the value greater than 1000. |
OK | Saves the configuration and returns to the [Register Report Data] window. |
Cancel | Cancels the configuration and returns to the [Register Report Data] window. |