Stonefield Query has a simple "wizard" interface. After selecting a report from the list of available reports, you can select the sort order, enter filter conditions, and select where the output should go (printer, disk file, spreadsheet, screen preview, etc.).

In addition to running pre-defined reports, you can create your own "quick" reports in just minutes. Simply select which fields to report on from the list of available fields (full English descriptions rather than cryptic names and symbols), and you're done! You don't have to know complex stuff like join conditions; Stonefield Query takes care of that for you.

For finer control, you can select how each field should appear from a "Field Properties" dialog, including column heading, grouping, and totaling. The easy-to-use query dialog allows you to include or exclude specific records. Use the sort page to order the information how you need it. Finally, save the report so you can edit it, copy it, or make it available to others to run.

Stonefield Query has the following features:

• Powerful query and reporting tool designed with the end-user in mind. Design reports in minutes, not hours or days.
• Simple "wizard" interface. After selecting a report from the list of available reports, you can select the sort order, enter filter conditions, and select where the output should go (printer, text file, spreadsheet, screen preview, etc.).
• Full English descriptions for all field and table captions (even for optional fields) rather than cryptic names and symbols. English operators such as "equals" and "greater than" instead of "=" and ">" are used.
• Handles complex join conditions between tables automatically.
• When you create a report, you can specify whether other users can access the sort or filter pages for each one. You can even define reports that are only accessible to specific users.
• Click on the "values" button to get a list of all possible values for any field.
• Control font, color, alignment, heading, and column width for each field. Group on any field with a mouse click.
• Automatically adjusts column widths to match the data in the column.
• The Advanced Report Designer allows you to completely control the look of your reports. Move fields around, add lines, boxes, and shading, include graphics such as company logos, define calculated fields, etc.
• Output to Microsoft Excel, HTML, Microsoft Word, comma-delimited, or other types of files.
• Knows your data. You don't have to know how your data is stored or how tables are joined (you don't even have to know what a 'join' is).
• Import reports so you can use report layouts designed by other users or consultants.
• Export reports so you can share report layouts with other users.
• Display 'real' table and field names so it's easier to locate the table or field you want if you're familiar with these names.
• Context-sensitive help provides easy-to-follow instructions for every task.