Stonefield Query has the following features:- All custom tables and fields are available, and appear with the descriptions assigned by the HEAT administrator rather than the actual table and field names.
- Tables are organized into logical data groups. Rather than selecting from over a hundred tables when creating a new report, you first select the data group you wish to work with, then select from the small set of tables in that data group.
- Dates are displayed as you expect them (actual dates), rather than the way HEAT stores them (as characters, such as "2000-01-19"). In other report writers, you have to use complex expressions to convert character dates to true dates.
- The Elapsed Hours (Based on Help Desk Hours) and Elapsed Days/Hours (Based on Help Desk Hours) fields in the Call Logging and Call Assignments tables show the elapsed hours for a call taking the hours of operation of your Helpdesk (rather than total elapsed time) into account.
- 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.