Thursday, October 30, 2014

Stonefield Query SDK Version 5.0

Stonefield Software Inc. is pleased to announce the release of version 5.0 of the Stonefield Query SDK. This release has numerous new features.

Report Designer

  • Stonefield Query has a new report type: gauge report. This allows you to create a gauge showing the current value of something compared to a target or goal value.
  • You can now create a "grouping" formula. A grouping formula is a powerful tool that allows you to create filtered summary values. For example, suppose you want columns in a report that show the sales for last year and the current year-to-date for each customer. Those aren't single values retrieved from the database. Instead, for the first column, use a grouping formula that sums up the sales records for each customer for last year, and use a similar one but for the current year for the second column.
  • You can now password protect the file created when a report is output to file or email.
  • You can now print to Dymo LabelWriter labels.
  • The Schedule Report function is now available only to advanced users.
  • A new output type is now available: Microsoft Excel - Full Format (*.xlsx), which creates Excel 2007 or later files. The former Microsoft Excel (*.xls) output type was renamed to Microsoft Excel 97-2003 - Full Format (*.xls) so you can tell them apart. The new type does not require Microsoft Excel to be installed to create the file.
  • The "red" error dialog that appears when something goes wrong now has a Help button that brings up the help with information about that dialog.
  • The Locations page in the Options dialog is now available only to administrative users.
  • The Subscription Expired dialog, which appears when you have subscription licenses and your subscription has expired, now has a "Don't remind me again" option; turn that option on to prevent the dialog from appearing again. Also, those licenses are now deactivated rather than being deleted, so if you renew your subscription, they are reactivated.

SDK

There’s only one major new feature in Stonefield Query Studio: the new Find Possible Relations function makes it easier to create relationships between tables: it examines all tables, looking for field names in common as possible relationships.