Tuesday, April 17, 2012

We are pleased to announce the immediate release of Stonefield Query for GoldMine 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.

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.

The Calendar Recurrences table (added in GoldMine 9.0) is now available in Query, when Query is connected to a GoldMine 9.0+ database.

The Product Name field (added in GoldMine 8.5) is now available in Query's Opportunities table, Projects table, and Opportunity/Project table, when Query is connected to a GoldMine 8.5+ database.

Query now has a relationship defined between the Case Contacts Link table and the Combined Main and Other Contacts table. This allows for the proper reporting of the data shown on the Contacts tab in GoldMine's Cases view, using Query's Cases table and Combined Main and Other Contacts table.

A new Secondary Contact ID field is now available in the Combined Main and Other Contacts table. This field shows the ID for secondary contacts, and is blank for main contacts.