12.1.2 Settings
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. |