Skip to Content

Changes for page 6. Flexible Reports Guide

Last modified by Iaroslav Platonov on 2026/06/08 15:20
From version 3.1
edited by Lana
on 2025/11/13 00:24
Change comment: There is no comment for this version
To version 3.3
edited by Lana
on 2025/12/10 22:42
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -1,0 +1,57 @@
1 += CONTENT =
2 +
3 += 1. INTRODUCTION =
4 +
5 +CENTO is a multifunctional software platform for data collection, processing, and display. This guide describes the flexible reporting tool in CENTO.
6 +
7 +It is assumed that the user, having read the User's Manual, is already familiar with the basic elements of the CENTO interface.
8 +
9 +Flexible reports in CENTO are designed to create, edit, upload/download Excel reports based on the collected data. This function allows to create reports of any form and composition.
10 +
11 +Flexible reports can be created both within a single time unit (day, month, year) and for a period specified by the user.
12 +
13 +The manual contains a description of the following operations:
14 +
15 +* Creating and editing report templates in the web interface;
16 +* Generating reports from templates;
17 +* Viewing and editing created reports;
18 +* Downloading and uploading report files in Excel is supported with version control.
19 +
20 += 2. QUERY LANGUAGE =
21 +
22 +== 2.1. General information ==
23 +
24 +The core of the flexible reports functionality is a query language that enables the extraction of archived data from the database. Excel (.xlsx) files are used to work with this data.
25 +
26 + There are two types of files:
27 +
28 +* A template is used to define the layout and structure of a report, including queries to archived data.
29 +* A report is a ready–made document generated from a template that contains the data received as a result of filling in the cells.
30 +
31 +The template is generated by the user in .xlsx file and then uploaded via CENTO forms. Queries are entered into the cells of the template, and the system inserts the resulting value into the cell where the query was placed.
32 +
33 +Editing of the report template is also available through the web interface, as described in section 3.
34 +
35 +The template can contain multiple sheets, Excel formulas, charts, conditional formatting, and a summary report. An example of the generated sheet of an .xlsx file is shown in Figure 2.1.
36 +
37 +1.
38 +11. Timestamps
39 +
40 +Timestamps can be specified in the query language. They are designed to transmit information about the date and time associated with the report.  There are four types of timestamps:
41 +
42 +**#created** displays the date and time when the report was created.
43 +
44 +**#related** displays the date associated with the report (in flexible reports for the period, the timestamp is ignored).
45 +
46 +**#begin** displays the start date of the report period (only for flexible reports for the period).
47 +
48 +**#end** displays the end date of the report period (only for flexible reports for the period).
49 +
50 +Each timestamp should be placed in a separate cell.
51 +
52 +1.
53 +11. Query format
54 +
55 +The query is divided into 4 parts/groups separated with the ":" symbol.
56 +
57 +