History database table

<< Click to Display Table of Contents >>

Navigation:  Project > Reports > Table report objects >

History database table

Previous pageReturn to chapter overviewNext page

historydatabasereporttable

 

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:

 

columnscollection

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:

 

conditionstyle

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:

 

conditionstyle

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:

 

variablescollection

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