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.


© Stonefield Software Inc., 2023 • Updated: 01/20/21
Comment or report problem with topic