<< Click to Display Table of Contents >> History database table |
|
History database report table get data from the history database.
Property |
Description |
---|---|
History DB |
Choose History DB you want to bind this history report table. |
Time interval |
Time interval with which data is taken from the database. |
Columns |
Click Collection to set up report's columns . After clicking you’ll see the window:
where: •Name - name of the column. •Title - title of the column. •Type - type of the column (Tag, DateTime, Row number). •Tag - choose tag you want to bind to this column. •Processing type - processing tag's columns values in interval. ✓FIRST VALUE - take first value from the interval. ✓LAST VALUE - take last value from the interval. ✓MIN VALUE - take minimum value from the interval. ✓MAX VALUE - take maximum value from the interval. ✓AVG VALUE - take average value from the interval. •Width - width of the column.* •Format - how to format value in the column. •Styles - choose style for the column. •Condition styles - condition styles. You can setup it by clicking Collection:
where: •Name - name of the condition style. •Column name - name of the column. •Type - type of the comparison. •Value - value to the comparison. •Color - color of the cell when the condition is right. •Font style - text's font style of the cell when the condition is right. |
Condition styles |
Click Collection to set up condition styles . After clicking you’ll see the window:
where: •Name - name of the condition style. •Column name - name of the column. •Type - type of the comparison. •Value - value to the comparison. •Color - color of the row when the condition is right. •Font style - text's font style of the row's cells when the condition is right. |
Variables |
Click Collection to set up variables. After clicking you’ll see the window:
where: •Name - name of the variable. •Column name - name of the column. •Type - type of the variable. ✓MIN VALUE - minimum value in the column. ✓MAX VALUE - maximum value in the column. ✓AVG VALUE - average value in the column. ✓SUM VALUE - summary value in the column. |
* When specifying the column width, proceed from the maximum number of pixels in width for the selected report type. So, if in the Report Properties you specified the A4 format and the orientation - Portrait, then the page width will be 595 pixels, from which subtract the number of pixels for the margins on the right and left (by default - 20 pixels on each side), i.e. the width of the table will remain 555 pixels. Distribute 555 pixels across all table columns. If the total width of all columns plus the margins on the right and left exceeds the maximum number of pixels for a given report format, the program will generate an error and the report will not be generated.
We enclose page sizes for different formats:
А4 |
595х842 |
А3 |
842х1191 |
А2 |
1191х1684 |
А1 |
1684х2384 |
А0 |
2348х3370 |