Database functions return distinct values or aggregate values from your database. These functions are often an integral part of a report design.
| Function | Description |
|---|---|
| DBAvg | Returns an average value from a column in a table. The rows that are included in the average can be limited by applying a filter. |
| DBCount | Returns the number of rows in a table. The rows that are included can be limited by applying a filter. |
| DBFind | Locates a specific row in a table and the returns the value for a specific column. The row can be identified using a combination of a filter and an offset. First the filter is applied to the rows in the table to find matching rows. The offset is used to identify the row number to use. |
| DBLookup | Returns the value for the specified column in the row uniquely identified by the table’s primary key. A value must be supplied for each column in the primary key. |
| DBMax | The DBMax function returns the largest value from a column in a table. The rows that are compared can be limited by applying a filter. |
| DBMin | The DBMin function returns the smallest value from a column in a table. The rows that are compared can be limited by applying a filter. |
| DBSum | The DBMin function returns the sum of the values from a column in a table. The rows that are compared can be limited by applying a filter. |