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-based interface. After selecting a report from the list of available reports, you can select the sort order, enter filter conditions, and specify where the output goes (printer, spreadsheet, PDF file, screen preview, etc.).

• Descriptive names for all fields and tables rather than cryptic names and symbols. Descriptive operators such as "equals" and "greater than" instead of "=" and ">."

• Handles complex joins between tables automatically.

• When you create a report, you can specify whether other users can change the filter conditions or the way it's sorted. You can even define reports that are only accessible to specific users.

• Create great-looking charts and gauges, either by themselves or included in other reports.

• Display dynamic dashboards of important information you need to run your business.

• The Formula Editor allows you to define your own custom calculations to use in any report.

• Templates give your reports a common appearance, such as following corporate style guidelines.

• Easily create labels, including mailing labels, product labels, or barcode labels, without worrying about field positioning or label dimensions. All the common Avery label sizes are built-in.

• Drill down from a report to see details.

• Click 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 lay out the report exactly as you want, including company logos, lines, boxes, etc.

• Output to Microsoft Excel, PDF, HTML, Microsoft Word, comma-delimited, or other types of files. You can also email reports.

• 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).

• Schedule reports to run at any time you need.

• 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.

• Add new data sources, such as Microsoft Excel or Access, and connect them to your existing database with a few mouse clicks.

• Supports both FoxPro & SQL ALERE databases.

• Tables are organized into logical data modules. Rather than selecting from over 100 tables when creating a new report, you can first select the data module you wish to work with, then select from the small set of tables in that data module.

• Stonefield Query for ALERE will let you report on any custom tables and fields that you have defined in the USRDATA.DBF table in your ALERE installation directory.

• Stonefield Query for ALERE will automatically filter out any records that have been deleted from a table.

• Support for "User-defined Inventory Fields". Stonefield Query will use the custom descriptions that you have set for your MISC Inventory fields. These fields are found in the "Inventory Items" table.