In this step of the wizard, you must identify the Liberty Reports function that you wish to add to your worksheet.
Note - The wizard does not expose all available Liberty Reports functions. Click here for a complete list of the available functions.
The function that you select will determine the remaining steps of the wizard.
The following functions can be inserted using the wizard. Click the function name for more details on a specific function.
| Function | Description |
|---|---|
| DBFind | Locates a specific row in the table and returns the value for the specified column. The row can be identified using the combination of a filter and an index. The filter is applied to select matching rows, then the index is used to specify which row in the result set should be used. Finally, the specified column value is returned. |
| 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. |
| DBSum | Returns the sum of the values from a column in a table. The rows that are included 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. |
| DBAvg | Returns the average value from a column in a table. The rows that are included in the average can be limited by applying a filter. |
| DBMax | Returns the largest value from a column in a table. The rows that are compared can be limited by applying a filter. |
| DBMin | Returns the smallest value from a column in a table. The rows that are compared can be limited by applying a filter. |
| DBName | Returns the name of the database for the specified connection. Click Back to select a different connection. |
| DBUser | Returns the name of the user logged in using the specified connection. Click Back to select a different connection. |
| LRWorkbook | Returns information about the workbook's file and path. |