Stonefield Query SDK Version 5.2 - New Release Available

SANTA CLARA, Calif. - Sept. 21, 2015 - PRLog -- Stonefield Software is please to announce the release of version 5.2 of the Stonefield Query SDK. There are lots of new added features in this latest release.

Report Designer

A new type of filter operator is available for date fields: Is. When you choose this operator, you can select a date type to compare the field to, such as This Week, Last Year, or This Month to Date, from a drop-down list.

Dashboards can now include all types of reports, not just charts and gauges. Note, however, that the dashboard window doesn't scroll so it's really only appropriate for short, informative reports.

The report wizards now shows information about the field under the mouse pointer in a "balloon" tip. For the Available fields list, the balloon shows any comments about the field. For the Selected fields list in a quick report or label, the balloon shows how the field is formatted in the report: whether it's grouped or summed, what numeric or date format is used, and so on. This allows you to see at a glance information about the field without having to click the Properties button.

You can now select more than one grouping field for a grouping formula. This is necessary for a formula that, for example, show sales for a certain date range by customer and product.

A new type of output is available: Microsoft Excel - Data Only (Fast). This is similar to Microsoft Excel - Data Only but is faster and doesn't require that Excel is installed on the system. This format works better that Microsoft Excel - Data Only with scheduled reports because Excel doesn't always work correctly when run from a scheduled task.

You can now specify whether category and series fields are sorted in ascending or descending order in a chart.

You can now specify a background color for fields in a report in the Properties dialog. Sample text shows what the colors of the field will look like in the report. You can also revert to the default color for the field by turning on the new Use default color setting.

You can now export and email a report layout to someone in one step: right-click the report in the Reports Explorer and choose Email Report File, enter their email address, and click Send.

If an advanced layout report has any images, such as a company logo, those images are included in the SFX file for the report. If you export the report and send the SFX file to someone but forget to send them the image files used by the report, the Import process they use to add the report to their reports list creates a new folder called Images and puts the images imbedded in the SFX file there. The benefit of this is that you no longer get an error about a missing image in this case.

The Show totals in group headers setting for quick reports is now available for advanced layout reports.

Stonefield Query Studio

A new step 2 of the New Project Wizard allows you to specify that core Stonefield Query files should be named differently when installed on a user's system, such as naming SFQuery.exe as MyApp.exe. This is easier than the manual steps you previously had to use to create a branded version of Stonefield Query.

The Application object has a new Log method.

A new set of files, IsFunctions.DBF and IsFunctions.FPT, must be distributed with Stonefield Query so be sure to regenerate your setup script or update your existing one accordingly.

Editing the West Wind HTML Help Builder project created with the Create Help Files function now requires West Wind HTML Help Builder version 5.0.
If the user was editing a report and an error occurred, the SFX file attached to the email sent with the error report includes the user's changes.

Get the full function 30 Day demo today and try it with your Data. Stonefield Query Makes Reporting Simple.

www.stonefieldquery.com

About Stonefield Software

Stonefield Software Inc., the makers of the award-winning Stonefield Query, has been developing Business Intelligence database reporting solutions since 1991.Stonefield has partnered with over 800 OEM and ISV partners to deliver BI reporting solutions to more than 225,000 users in over 65 countries globally to date. Our customers span all sectors and industries from public to private, military to non-profits, Fortune 500 to Small and Medium Enterprises (SME). Stonefield Query has been designed and developed with the end-user in mind.