In the Script Editor, you can register DataSource and source code for use in your reports.
DataSource
By writing SQL statements or utilizing i-META to register a DataSource, you can retrieve data from the DB.
No | Category | Description |
① | DataSource Creation Area | Right-click the Data Source folder, and click New to create a new DataSource. Right-clicking an existing DataSource allows you to create(New), delete(Delete), copy(Copy), or rename(Rename) DataSource. |
② | SQL Input Area | You can write SQL statements. |
③ | SQL Variable Area | You can configure the variables used in SQL query. |
④ | SQL Execution Result Window | Displays the results after executing the SQL Query. |
How to Register a DataSource
- Right-click the DataSource folder
- Select New
- Select DB Connection
- Write a SQL statement
- Click the Execute button or press the F5 key to verify the data retrieval
- Click the Save button to save
Client Script
You can write necessary features for reports in JavaScript.
JScript Editor window is automatically generated when the Script Editor is opened.
No | Type | Description |
① | Source Code Input Area | You can write a source code necessary for a report's operation. With an API selected, pressing the 'F1' key will open the API Document window. |
② | API Function Creation | You can find the necessary API functions for each Control and automatically generate the corresponding function by double-clicking it. |
③ | API Document | You can search for necessary API functions. |
Server Script
You can write a report's functions to be executed on the server in JavaScript.
No | Type | Description |
① | Server Script Creation Area | Right-click the Server Script folder and click New to create a new DataSource. Clicking Template allows you to use SeverScript templates for data storing and using procedures. Right-clicking an existing DataSource allows you to create(New), delete(Delete), create a Template(Template), or rename(Rename) the Server Script. |
② | Server Script Input Area | you can write a source code necessary for a report's operation. With an APPI selected, pressing the 'F1' key will open the API Document window. |
③ | API Document | You can search for necessary API functions. |
How to Register a Server Script
- Right-click the Server Script folder
- Select either New or Template
- Write code
- Click Save button to save