mvQuery Features

Queries

Queries are built using simple drag and drop technology.
Support for “Phrases” (locally defined groups of fields, sort & selection criteria.
Support for “Joins” (references remote fields without the need for building dictionary items).
Queries can be saved for future use
Retrieved data is displayed in a spreadsheet or table, and can be manipulated to automatically generate extra columns based upon fields, calculations and formulae.
Field associations are retained
Calculations using meta-columns on the result-set take account of multi-values.
Report designer utilizes multi-values
Option to retain multi-values when exporting.
Word mail-merge will utilize multi-values (e.g., in the address line).
Dictionary builder for create/amending host based items (subject to security settings).
Support for exploded selections; support for indices.
Multivalue-aware break-point support in the result set and report designer.
Options for sample runs and prompt levels
Retrieve parser for converting TCL statements.

Various reports can be generated automatically:
- Standard Column Report
- Combination Report for controlling multi-values
- Form Report
- Mailing Labels
- Disk labels & charts
- Fonts, alignment, print areas, etc., can be adjusted within the Report Designer
Experts and Function Builders guide the user through complex Dictionary Item creation.
Data can be copied to the Clipboard and pasted into a variety of delimited formats, such as MS Acess.
Support for multi-section reports
New report header, report footer, record header, record footer and value line sections.
Support for complex multi-value break point management and break headers.
Optional sections dependent on the data
Labels and Forms (both US & UK Avery label support).
Full Print Preview.
Graphics and Barcode Support.
Report serialization

The System Manager controls user access with a Windows-based Administration client. This allows creation of reporting accounts, restriction of files and items per user within the account as well as maintaining audit trails.
mvQuery can use “database” select lists as well as powerful database programs or paragraphs which can run before and after a query to either populate a work-file or create a select list.
Exporting to Office Applications

More advanced users (System Administrators) can create standard system wide queries that can be used by multiple users.
A shortcut can be created on users’ desktops that, when clicked, will run, display or print a number of standard reports
“Favorites” networked or a local collection of stored query definitions can be organized into catalogs