Target Screen |
---|
Template Report Information This practice screen is based on a predefined Template.
|
Step 1. Connect Data
1.1 Creating Query Condition Controls
Create Controls for data retrieval.
1. Joining Period
To create a title for Joining Period(i.e., employment start period), select [UI Bot] > [Label].
- Modify the property of the Control.
Text : Period
3. To create a calendar Control for query condition, go to [UI Bot] > [Calendar] > [D From To].
4. Modify the properties of the Control.
Name : VS_FROM_DATE
Name2 : VS_TO_DATE
InitDate : DATE(-10,F,F);NOW()
2. Division
To create a title for Division Control, select [UI Bot] > [Label].
- Modify the property of the Control.
Text : Division
3. Create a ComboBox Control for query condition by selecting [UI Bot] > [ComboBox] > [MultiCombo].
4. Modify the properties of the Control.
Name : VS_DIVISION
DataSource : DIVISION(Using the common data source)
CaptionField : DIVISION
ValueField : DIVISION
UseSelectText : Activate
AutoRefresh : Activate
1.2 Connecting List-Grid Datasource
1. Connect the "GRID" Datasource to the grid Control and execute the report to ensure it runs correctly.
Step 2. Configure List-Grid Properties
1. To edit the design of the [List-Grid] Control, right-click the Control and select [Design] to open the Design window.
2. Select all unused fields in the report and disable [Show] property.
C_USER, C_DATE, U_USER, U_DATE : Disable [Show] Property
3. Change the data alignment of the fields.
[Alignment] - [Data Alignment] : Center
4. Change the field type to allow easier value modification.
No. | Field | Field Type | Option |
---|---|---|---|
1 | IMG | Image | |
2 | DIVISION | ComboBox | Datasource : DIVISION |
3 | EMP_RANK | ComboBox | Datasource : EMP_RANK |
4 | GENDER | ComboBox | Defined items : female;F|male;M |
5 | BIRTH_DATE | DateTime | Format > {0:dd-MM-yyyy} |
6 | ENTER_DATE | DateTime | Format > {0:dd-MM-yyyy} |
7 | PHONE_NO | MaskEdit | Format > 000-0000-0000 |
8 | LEAVE_YN | CheckBox | CheckedValue : Y, UnCheckedValue : N |
5. Disable the [Editable] property for [IMG] and [EMP_NM].
6. Move the IMG and DIVISION fields to the top.
7. Configure settings to merge cells based on the DIVISION field.
IMG~ETC : Disable Filterable, Mergeable
Merge Type : Vertical
8. Configure settings to change the style of the columns.
9. Execute the report to check if the configured designs are applied successfully.
Step 3. Utilizing the Formula Editor
Use the Formula Editor to calculate YOS(Years of Service) and Employees count(The Number of Employees).
3.1 Adding Calculated Fields
Click [Design] on the ListGrid to open the Design window and add calculataed fields.
- Add a new field by clicking
- Move the new field between BIRTH_DATE and ENTER_DATE fields, and modify its Common properties.
Caption : YOS
Editable : Disable
Mergeable : Disable
4. Click the
button under Data - Formula to open the Formula Editor.
5. From the list on the left, select the YEAR function and [ENTER_DATE] field to create the formula, then click Apply button to complete the formula setup.
6. Click the
button next to Format section to open the Format Editor window, then enter "{0:N0} Year" as the number format.
7. Set Data Alignment.
Alignment - Data Alignment : Center
8. Execute the report to check if the YOS field is successfully added.
3.2 Utilizing Label Formula
Display the number of employees using the Formula in Label .
Select the [Label2] Control at the top-right of the ListGrid and click the button under the Formula to open the Formula Editor.
Display Total, Female, Male Count as text by connecting text and COUNTIF function with + operator.
- Click the [Apply] button to check if the employee count is calculated based on the formula.
Step 4. Configure CRUD Settings
Use the Create Input Form and DB Upload features to configure Data create, read, update, and delete operations.
4.1 Create Input Form
Connect input Control and the List-Grid using the Create Input Form.
Right-Click the List Grid Control in [Edit Mode], and select [Create Input Form] section.
2. When the [Input Form Settings] window appears, enter the number of rows or columns to generate and click [OK]. Labels and input Controls will be created based on the field types in the List Grid.
3. Arrange the Controls as shown in the target screen.
4.2 Execution Plan Design
Select [DB Bot] > [DB Upload] to open Execution Plan Design window.
Verify that columns are automatically mapped when connecting the Data Control.
[Data Control] : DataGrid
Step 5. Configure Process Bot
Configure data CRUD operations and screen transition using Process Bot.
5.1 Data Saving Module
Configure CRUD operations using Modules.
- Click [Process Bot] icon (
- Click [Activities] tab, and double-click the ‘DataGrid CRUD Template’ Module.
- After clicking the Module icon( ), configure the detailed options.
Select the options according to the Module status.
Click the [Save] button to complete the Module settings.
5.2 Form change Module
Set navigation to another form when a button is clicked within the Report.
- Set it to navigate to the Log Form when the [BTN_LOG] button is clicked.
- Double-click the [BTN_LOG] Control.
- Click the [Activities] tab, and double-click the ‘Activate Form(Move to other form + Refresh)’ Module.
- Click the Module icon ( ) and configure the detailed options.
Select the options according to the Module structure.
Set it to navigate to the Log Form and trigger a quert on the DataGrid1 Control when the [BTN_LOG] is clicked.
Click the [Save] button to complete the module configuration.
5. Connect the [BTN_LOG] > OnClick event to the Module.
6. Set it to navigate to the MAIN Form when the [BTN_MAIN] button is clicked.
7. Double-click the [BTN_MAIN] Control.
8. In the [Activities] tab, go to Modules > By Controls > Form, and double-click ‘Activate the Form(Move to other form + Query Configuration)’ Module.
Click Module icon(
) to configure the detailed options.Select the appropriate options according to the Module configuration.
Set it to navigate to MAIN Form and to Query using DataGrid Control when [BTN_LOG] is clicked.
Click the [Save] button to complete the module setup.
9. Connect [BTN_MAIN] > OnClick event to the Module.
10. Save it after checking the process bot is configured as shown below.
11. Check if the report works as expected.
버전 | 날짜 | 댓글 |
---|---|---|
현재 버전 (v. 29) | 2025-06-20 12:37 | 영문 가이드 작성자 |
v. 28 | 2025-06-20 11:34 | 영문 가이드 작성자 |
v. 27 | 2025-05-07 15:31 | 영문 가이드 작성자 |
v. 26 | 2025-05-07 10:07 | 영문 가이드 작성자 |
v. 25 | 2025-05-07 10:02 | 영문 가이드 작성자 |
v. 24 | 2025-05-02 17:51 | 영문 가이드 작성자 |
v. 23 | 2025-05-02 17:15 | 영문 가이드 작성자 |
v. 22 | 2025-04-01 21:08 | 영문 가이드 작성자 |
v. 21 | 2025-04-01 21:05 | 영문 가이드 작성자 |
v. 20 | 2025-04-01 21:04 | 영문 가이드 작성자 |
v. 19 | 2025-04-01 21:01 | 영문 가이드 작성자 |
v. 18 | 2025-04-01 20:59 | 영문 가이드 작성자 |
v. 17 | 2025-04-01 20:58 | 영문 가이드 작성자 |
v. 16 | 2025-04-01 20:56 | 영문 가이드 작성자 |
v. 15 | 2025-04-01 20:55 | 영문 가이드 작성자 |
v. 14 | 2025-04-01 20:48 | 영문 가이드 작성자 |
v. 13 | 2025-04-01 20:48 | 영문 가이드 작성자 |
v. 12 | 2025-04-01 20:46 | 영문 가이드 작성자 |
v. 11 | 2025-04-01 20:31 | 영문 가이드 작성자 |
v. 10 | 2025-04-01 20:25 | 영문 가이드 작성자 |
v. 9 | 2025-04-01 18:19 | 영문 가이드 작성자 |
v. 8 | 2025-04-01 15:14 | 영문 가이드 작성자 |
v. 7 | 2025-04-01 15:01 | 영문 가이드 작성자 |
v. 6 | 2025-04-01 10:55 | 영문 가이드 작성자 |
v. 5 | 2025-04-01 10:55 | 영문 가이드 작성자 |
v. 4 | 2025-04-01 10:55 | 영문 가이드 작성자 |
v. 3 | 2025-04-01 10:40 | 영문 가이드 작성자 |
v. 2 | 2025-03-31 16:38 | 영문 가이드 작성자 |
v. 1 | 2025-03-31 16:15 | 영문 가이드 작성자 |