The Essential Reporting Solution for HEAT Users

Download Trial Watch video Schedule Demo View documentation

Stonefield Query for HEAT is quite simply the most powerful, easy-to-use reporting product on the market for your HEAT data. And now it's available in three different tiers to fit every budget.

Stonefield Query provides a step-by-step method to create professional business reports from information stored in HEAT. Anyone can create detailed reports, high level overview, drill-down, charts/graphs, pivot tables, and more in minutes rather than hours.


We Know HEAT

Stonefield Query knows the HEAT database structure, and has been delivering industry-leading reporting solutions for years. With three new tiers to fit everyone's budget, it has the following special features:

Sample Reports

Get started immediately with our sample reports! Stonefield Query comes with numerous sample reports that can be run or used as a starting point for report design, and used with our Basic viewer program in runtime.

Reporting Made Simple

Stonefield Query walks you through the reporting process in 6 easy-to-follow steps so you can build professional reports in minutes, not days.

Report on Custom Tables and Fields

All custom HEAT tables and fields are available, and appear with the descriptions assigned by the HEAT administrator rather than the actual table and field names.

Logical Organization

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.

Handles Dates Properly

Automatically converts dates, which HEAT stores as character values (for example, "2008-03-04" for 03/04/2008), into true date values, which works better for display purposes and for date expressions.

Handles Elapsed Time

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.

Schedule and Automatically Deliver Reports

Automatically deliver reports via e-mail, file, or printer. Schedule them to run anytime you need them to, and never miss a reporting commitment to your peers, customers, or vendors (requires Ultimate).

Charts, Graphs, and Dashboards

Create bar, line, area, and pie charts as well as series charts. Dashboards combine multiple charts into one consolidated view of your data. Zoom in and out on the dashboard, update individual reports manually, and output the dashboard to file.

Microsoft Excel PivotTable Reporting

Extend your data analysis with Microsoft Excel PivotTables.

Create Your Own Custom Formulas

Define your own custom calculations to use in any report. Use any of the hundreds of built-in functions or create your own.

Filters and Exclusions

Filters allow you to narrow down your results without programming, such as product sales by customer for this year, month, or week. Exclusions allow you to report on things not recorded in HEAT, such as all companies that bought something last year but not this year.

Multiple Database Support

You can run reports on more than one HEAT database. You can even consolidate records from multiple companies into one report (requires Ultimate).


Stonefield Query Product Tiers

FeatureBasicProPremiumUltimate
Run any type of reportXXXX
Includes built-in reportsXXXX
Import reports created by othersXXXX
Prompt for filter values ("ask at runtime")XXXX
Output reports to file (PDF, Excel, etc.)XXXX
Email reportsXXXX
Support multiple databasesXXXX
Drill down from summary to detail reportsXXXX
Report on custom tables and fieldsXXXX
Create/edit row and column ("quick") reports XXX
Create/edit cross-tabulation reports XXX
Create/edit labels XXX
Create/edit batch reports XXX
Create formulas XXX
Create drilldown reports XXX
Create/edit charts  XX
Add charts to quick and cross-tab reports  XX
Edit report layout ("Advanced Report Designer")  XX
Create/edit templates  XX
Create/edit gauges   X
Create/edit dashboards   X
Create subreports   X
Report on multiple databases in same report   X
Schedule reports   X
Usage reporting   X
Number of free support tickets per year12410
Price$125$1,500$2,000$2,500

Please note:

 All prices are in U.S. dollars.

 "Basic" viewer licenses are available by subscription only and require software maintenance be kept current

 Products can be upgraded

 Scheduled reports are not available in Citrix environments


System Requirements


Sample Reports