Report design - expression

zhaozj2021-02-16  84

The most basic type of expression is the expression of displaying a field value in the text box. This type of expression is referred to as a field expression. To link the database field to the report item, the expression must include the fields collection, field name, and value properties.

The expression in the report item and attribute must begin with the equal sign (=).

function:

Function Description AVG Returns the average of all non-null values ​​of the specified expression. Count Returns counts for each value of the specified expression. CountDistINCT Returns counts for all different values ​​that specify the expression. Countrows Returns the count of rows within the specified range. First returns the first value of the specified expression. Last returns the last value of the specified expression. Max returns the maximum value in all non-empty values ​​of the specified expression. MIN returns the minimum value in all non-empty values ​​of the specified expression. STDEV returns the standard deviation of all non-null values ​​of the specified expression. STDEVP returns the overall standard deviation of all non-empty values ​​of the specified expression. SUM returns the sum of the values ​​of the specified expression. VAR returns the variance of all non-null values ​​that specify the expression. VARP returns the overall variance of all non-empty values ​​of the specified expression.

转载请注明原文地址:https://www.9cbs.com/read-12570.html

New Post(0)