Stonefield Query Version 4.2 for
Stonefield Query Version 4.2 for HEAT® Specific Features
|A user-friendly database report writing, query, and data mining tool designed specifically for HEAT®
Now you can put Business Intelligence reporting in the hands of the end-user where it belongs.
Stonefield Query has been customized specifically for HEAT® giving you an intuitive, easy-to-use BI reporting solution that you will love!
Stonefield Query has all of the built-in features you expect in an enterprise reporting solution including a Report Scheduler, Role-based Security, Report Templates, Drill Downs, Exclusion/Inclusion Filters, Emailed Reports, Customizable SQL Select, Advanced Report Designer and Multiple Output Options.
Now your sales people, administrative staff, and management can take advantage of the wealth of information stored in your HEAT® system when they need it.
You can create elegant and persuasive Quick Reports, Charts/Graphs, Cross-Tabulation Reports and Labels (mailing, barcode, etc) in minutes with little or no technical knowledge. No more waiting for the already overburdened IT or report developers to build reports on their timetable.
We are pleased to announce the immediate release of Stonefield Query for HEAT version 4.2. There are lots of new and improved features in version 4.2.
- You can now edit formulas from Step 2 in the report wizards. When a formula is selected, click the Edit Formula button to edit it. Otherwise, that button appears as "New Formula", so clicking it creates a new formula. Formulas now appear in report wizards with "[Formula]" after the name so you can distinguish them from real fields.
- You can now specify the order that a formula appears in its table when fields are displayed in table order. This is useful if you want a formula to appear somewhere other than at the end of the list of fields.
- You can now specify the number of rows a dashboard has. For example, if there are four charts in a dashboard and you specify two rows, the dashboard will have two rows of two charts each.
- Two new templates are available: Modern: this template has alternating light and dark rounded rectangles in the detail band and a blue rounded rectangle for column headers.
- Modern with Title: this template is similar to Modern but with a title page showing the report name, comment, user, date, and filter.
To add these to the list of available templates, choose Template Editor from the Tools menu, click Import, and select these templates from the Sample Templates folder.
- Objects in templates have a new Center option, which is useful for images such as logos that you want to be centered horizontally on the page.
Stonefield Query can now automatically sum numeric fields when you add them to a report. Turn on the Automatically sum numeric fields setting in the Options dialog to use this feature.
- The Format page of the Field Properties dialog of the Advanced Report Designer now has a Display date only setting that works like the same setting in the Properties dialog of the report wizards: turn this setting on to display the date only or turn it off to display the date and time.
- You can now specify whether missing date values are included in a chart when a date field is used in as the category (X-axis) field.
The License Manager now includes a Copy button to copy the selected serial number to the Clipboard. This makes it easier to specify your serial number when requesting technical support.
- You now get a warning if you try to schedule a report that has ask-at-runtime filter conditions, since that prevents a scheduled report from running.
Because exclude filter conditions are often erroneously used in place of a normal "not equals" filter (for example, you want a list of customers who aren't in Germany and use an exclude condition of Country equals Germany rather than the correct way, with a normal filter condition of Country does not equal Germany), you now get a warning if you try to create an exclude condition of this type, although that doesn't prevent you from using it.
- Most cross-tab reports run faster now.
- You can now output cross-tab reports that have Show Change or Show % Change turned on to Microsoft Excel, CVS, or PivotTable files even when the report can't be previewed or printed because it has too many columns.
- Stonefield Query starts up faster than before.
The setting of the "display only directly related tables" button is no longer remembered because it was easy to miss that this option was turned on and then wonder why all of the tables weren't displayed.
- Turning on Use same options next time report is run on the Output page of the Reports Explorer now saves the selected printer if it isn't the default printer. This allows you to always print the report to the same printer, such as sending mailing labels to a label printer.
You can now specify the name of a report to edit or that a report should be created with the New Report Wizard with command-line parameters.
|- Supports all versions of HEAT® up to 9.5
- All custom HEAT® tables and fields are available, and appear with the descriptions assigned by the HEAT® Administrator
Tables are organized into logical Data Groups
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 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 your HelpDesk Hours-of-Operation into account
Can create reports on the HEAT "First Level Support" tables. These tables represent a HEAT Knowledge base of "First Level Support Solutions"
Create a Quick Report for HEAT
approx 10 min
This getting started video will provide you with an overview of the six steps in the
Quick Report Wizard to help you create your first report.