Client Management                               Customer Query Builder                               Understanding the CQB Report Query Designer

Understanding the Customer Query Builder

Report Query Results – Once a query design is complete the User will click the Refresh Results button located at the lower left of the CQB Designer form.  The results of the requested data will be displayed in this grid area.

When designing report queries it is important to understand how data is linked and stored in the SedonaOffice database.  For example, if a User selected fields from the Invoice Data Group and fields from the Equipment Data Group, the report would make no sense in that Invoices have no direct relationship to a System Equipment List. 

The Database Explorer is a utility available on the SedonaOffice website which provides a road-map to the design of the SedonaOffice database.  This utility illustrates which fields in which tables are linked to each other and provides other valuable information that is extremely useful in understanding the data table structures and relationships.  It is highly recommended all Users that will be designing report queries review this utility first.  This utility should be considered recommended reading.  The Database Explorer may be downloaded from this page of the SedonaOffice website: http://www.sedonaoffice.com/Downloads.html.

ss3006

Previous Page                               Page  2 of 15                              Next Page