Customer Query Builder

The  Customer Query Builder   is a tool that enables SedonaOffice Users to create custom queries based on your company’s data that is stored in the SedonaOffice database.  A Customer Query Builder report design builds a SQL query behind the scen...

For a User to be able to use the Customer Query Builder, certain security privileges must be granted to the User through the User Group Security options within SedonaSetup.  The following User Group Security options located within Application Acces...

Before attempting to design any report query, it is important to understand the structure of the CQB Design form and how it operates.  The CQB Report Query Designer is divided into five major elements which are briefly described below.  Follow the ...

Across the bottom of the CQB Report Design form are a series of function buttons.  The definition of each Function Button is shown below. Mail Merge Button SedonaOffice offers a feature that allows a User to create Mail Merge letters ba...

This section will walk through the step-by-step creation of a simple report query, the printing of the query results, and saving the report query design to a file.  The result of this sample report will be a list containing customer names and addre...

Below will show how to add fields into Customer Query Builder to get a customer list.  These steps have been used completed in SedonaOffice version 6.2.0.14. OVERVIEW This document goes over how to do a basic setup in QueryBuilder to get a...

Issue: The registration code was added to SedonaOffice before it was added to the customer query builder, so older versions of SedonaOffice do not have it in the query builder, so users cannot get a list of these if needed on a report. ...

Customer Query Builder not working Customers may submit a case stating, Customer Query Builder is not working getting error message Runtime Error 3021. This is rare but happens when a customer upgrades their Sedona Office version. ...