Features

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 goes (printer, text file, spreadsheet, screen preview, etc.).
Full English descriptions for all field and table captions 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 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 graphs, either by themselves or included in other reports.
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.
Drilldown 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 schedule 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.
In any case where a table can be broken up in to a combination of 'New', 'Current', and 'History' items, the contents of each table will be combined, so you can don't have to worry about two or three versions of a table. Of course, the option to filter out any of the tables is still available, if you prefer to report on each table individually.
Stonefield Query only shows which tables and fields are actually available to report on. For example, if your company database does not have a Job Cost History file, you won't have to sort through the corresponding fields when writing reports.
It scans the Timberline Office database for any custom descriptions you have entered. Fields will appear in Stonefield Query the same way they appear in Timberline Office.
It will discover any custom fields you have added to your database, and allow you to report on these custom fields alongside any standard fields in the database.
Stonefield Query provides the ability to report on tables from Accounting, PO/IV, and Service Management without having to worry about the difference between a Timberline ODBC connection and a Pervasive ODBC connection.
For tables with multiple different GL Account fields, you can dynamically join between that table and the GL Account table on a field of your choosing when you run the report.