Use SQL statements in the body sections of a report to retrieve the data to display. You can use record values in body sections and SQL statements. Record values are written in braces { }.
If a record value that is used in an SQL statement returns a NULL value, it is translated as 0 or ‘’. “
|
Record Value |
Description |
|
{ColumnName} |
Displays an attribute name. The value is replaced at runtime by the record value of the respective SQL statement that is defined for the group. You can also use record values with text. Example: The display model {Name} has the FID {Fid}. |
|
{Parameter.Filter} |
Filters records. The filter is replaced at runtime with the current filter of the respective form, so that only the data of the current filtered records is printed. |
|
{Parent.ColumnName} |
Finds the record value of a parent group. |
|
{Parent.Parent.ColumnName} |
Finds the record value of the parent of a parent. |
|
{Report.Sum(ColumnName)} |
Calculates the sum of the attribute values. You can use this function only in the body and foot section. Note the differences between the sections: In the Body section, calculates the current sum. In the Foot section, calculates the total sum. Use SQL values to calculate the sum in a head section. Example: select sum(money) from table where parent={key}. |
|
{Report.Avg(ColumnName)} |
Calculates the average. You can use this function only in the body and foot section. |
|
{fun.xxx} |
Executes functions. See also Use Functions in Reports. |
|
{sql.xxx} |
Runs a complex SQL statement. See also Use SQL Values in Reports. |
|
{Parameter.xxx} |