Stonefield Query has the following features:

  • Stonefield Query is a powerful query and reporting tool designed with the end-user in mind. Design reports in minutes, not hours or days.

  • The simple wizard-based interface leads you step-by-step through the process of creating a report.

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

  • Stonefield Query automatically handles complex joins between tables.

  • When you create a report, you can specify whether other users can access the report or not.

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

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

  • You can drill down from a report to see details.

  • The values button displays a list of all possible values for any field.

  • You can control font, color, alignment, heading, and column width for each field, and easily sort or group on any field.

  • The Advanced Report Designer allows you to lay out the report exactly as you want, including company logos, lines, boxes, etc.

  • You can output to Microsoft Excel, PDF, comma-delimited, or other types of files. You can also email reports or upload them to FTP.

  • Scheduling reports to run at any time you need is simple using the Schedule Wizard.

  • You can import reports so you can use report layouts designed by other users or consultants. You can also export reports so you can share report layouts with other users.

  • Displaying real table and field names may make it easier to locate the table or field you want if you're familiar with these names.