Design Tools

This group of tools is available when using a designer license. These tools are used when creating or modifying reports.

Query WizardWith a designer license, this button displays the Query Wizard window which guides you through the steps of creating a query that returns rows of data with one or more columns. Once inserted, a query can be refreshed to display current information. Doing so may cause the range of cells on the worksheet to expand (with new rows inserted) or shrink (deleting rows). A query is often the primary building block of a report design.
Function WizardWith a designer license, this button displays the Function Wizard window which guides you through the steps of adding Liberty Reports functions to your worksheet. Liberty Reports functions are capable of querying specific values or aggregate values from your database so that they can be displayed in the desired location on your worksheet. These functions are often a primary building block of a report design by providing useful information in the header of the report or in the body of the report adjacent to a query.
Edit SQLIf the current cell is within the range of data returned by a query, this button displays the Edit SQL Text window allowing you to view or modify the SQL statement associated with the query. If the current cell is not within the range of data returned by a query, this button displays the Select QueryTable window allowing you to identify which query's SQL statement you wish to edit in the Edit SQL Text window.
Manage ConnectionsDisplays the Manage Databases and Connections window allowing you to manage the list of available databases and connection names.