Changes for page 6. Flexible Reports Guide
Last modified by Iaroslav Platonov on 2026/06/08 15:20
Summary
-
Page properties (1 modified, 0 added, 0 removed)
-
Attachments (0 modified, 0 added, 5 removed)
Details
- Page properties
-
- Content
-
... ... @@ -163,26 +163,4 @@ 163 163 164 164 == 2.5. Output of information on devices to the report. Device codes and tags. == 165 165 166 -The request **#dev.201.IP** displays the IP address of the device with id = 201201 from the configuration in the report. Instead of the device ID, the device code can be specified. 167 - 168 -**#dev.201.Name** displays the device name with id = 201201 from the configuration in the report. Instead of the device ID, the device code can be specified. 169 - 170 -**#dev.201.VendorNumber** displays the serial number of the device with id = 201 from the configuration in the report. Instead of the device ID, the device code can be specified. 171 - 172 -The serial number of the device can also be taken from the tag if the device can output its number according to any protocol. For example, the SATEC device can be queried via Modbus, and the serial number can be retrieved from the **ti11001** tag. To display this tag in the report, write the formula **y-m-d:*:ti11001 **where **ti11001** can be replaced with the tag code. In the same way, add any tags from the configuration to flexible reports. 173 - 174 -In query formulas, device IDs can be replaced with device codes. Unlike the id, the code can contain Latin letters, which allows it to encode a lot of useful information. For example, the code P22S1Y8 may mean that the device collects data on PS22 in the first bus section in cell 8. To write the code in the request, add the channel to it, for example, Energy A+, which is encrypted as **ea_imp** by default. 175 - 176 -Thus, the formula **y-m-d1:*:el-dev-201-ea_imp-30m:sum** can be replaced by the formula **y-m-d1:*:E123457ea_imp:sum**. A similar logic applies to all the formulas described above. 177 - 178 -= 3. MANAGING REPORT TEMPLATES = 179 - 180 -Flexible reports are managed in the Flexible Reports window accessible using the **Reports menu: Reports -> Flexible Reports**. 181 - 182 -A template generated in accordance with the query language specified in Section 1 is uploaded to the Flexible Reports page (see Figure 3.1) by clicking the (Create Template) button [[image:Screenshot 2025-12-10 at 19.48.07.png||height="27" width="29"]] in the upper-right corner of the template list. 183 - 184 -[[image:Screenshot 2025-12-10 at 19.48.44.png]] 185 - 186 -Figure 3.1 – Flexible Report Template Management window 187 - 188 -After clicking the button [[image:Screenshot 2025-12-10 at 19.48.07.png||height="27" width="29"]] (see Figure 3.1), a download dialog box will open. Enter the template name, type, object, and category in this dialog box. Then, select the template file (Excel file), configure auto generation if needed, select a network resource and/or email address for saving automatically generated reports (see Figure 3.2), and click the button [[image:Screenshot 2025-12-10 at 19.49.45.png||height="23" width="46"]] to complete. 166 +
- Screenshot 2025-12-10 at 19.48.44.png
-
- Author
-
... ... @@ -1,1 +1,0 @@ 1 -XWiki.Lana - Size
-
... ... @@ -1,1 +1,0 @@ 1 -128.9 KB - Content
- Screenshot 2025-12-10 at 19.49.45.png
-
- Author
-
... ... @@ -1,1 +1,0 @@ 1 -XWiki.Lana - Size
-
... ... @@ -1,1 +1,0 @@ 1 -2.8 KB - Content
- Screenshot 2025-12-10 at 19.50.16.png
-
- Author
-
... ... @@ -1,1 +1,0 @@ 1 -XWiki.Lana - Size
-
... ... @@ -1,1 +1,0 @@ 1 -69.1 KB - Content
- Screenshot 2025-12-10 at 19.50.54.png
-
- Author
-
... ... @@ -1,1 +1,0 @@ 1 -XWiki.Lana - Size
-
... ... @@ -1,1 +1,0 @@ 1 -1.6 KB - Content
- Screenshot 2025-12-10 at 19.51.40.png
-
- Author
-
... ... @@ -1,1 +1,0 @@ 1 -XWiki.Lana - Size
-
... ... @@ -1,1 +1,0 @@ 1 -3.6 KB - Content