3305 Main Street Ste 019 Vancouver, WA 98663

Select Function

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.