Tuesday, May 23, 2017

Stonefield Query for Sage Pro ERP Version 6.1

We are pleased to announce the release of version 6.1 of Stonefield Query for Sage Pro ERP. There are lots of new features in this release.

  • A new type of output is available for chart reports: Microsoft Excel - Chart, which outputs to an Excel chart rather than an Excel spreadsheet containing an image, which is what Microsoft Excel - Full Format does.

  • The Find Reports by Name and Find Reports Using Field functions have been combined into a single Find Reports function in the Tools menu. The dialog displayed when you choose this function allows you to find all reports having a keyword in the name or comment, being last modified on or after a certain date, or containing a specified field.

  • Many optional settings that had to be set by manually editing Data.ini are now maintained in the Options dialog.

  • The new No Group Footer option for a grouped field specifies that you don't want a group footer for that field.

  • You can now fine-tune label dimensions in step 5 of the Label Wizard.

  • The new Add group to file name output option allows you to determine when the group name is added to the file name. This also allows you to do Microsoft Word Merge output to separate documents.

  • You can now use HTML tags in the body of a email.

  • You now only get a warning when a summary report containing ungrouped and unsummarized fields is previewed in the Quick Report Wizard, not when it's run any other time.

  • You can now select Highest and Lowest for Summary of a non-numeric grouping formula. This makes it easy to find the oldest or earliest invoice date by customer, for example.

  • There is better support for group recalculation formulas. You can now sort a report on such a formula. These formulas are now significantly faster than before, especially in summary reports. You can now use calculated fields in the numerator or denominator or for the grouping of these formulas.

  • The new Create bookmarks on this field setting in the Group Header Band Properties dialog in the Advanced Report Designer does the same thing that setting does in the Field Properties dialog in the report wizard, but you can now control it for advanced layout reports.

  • More complex SQL statements (those with more terms in parts of the statement) are now supported.

  • The AfterData script of a report now has access to the result set for a cross-tab before it's pivoted. It also has access to the result set used for a chart in a quick or cross-tab report that includes a chart through the ChartResultSet variable.

  • You now get a warning when creating a formula that does division that doesn't check if the denominator may be zero to avoid "division by zero" errors.

  • Blank row fields now display "(None)" for the value in a cross-tab report.

  • Bookmarks on grouped fields in summary report are now supported.

  • The ask-at-runtime filter dialog now shows which condition of the total number of conditions you're currently on.

  • The default setting for the Run report with no records option for new quick and cross-tab reports is now turned on. That means unless you turn it off, when you run a report that has no records matching the filter conditions, the report runs but displays a blank report.

  • The Commonly used expressions list in the Expression Builder has new items for First Day of Last Year, Last Day of Last Year, and This Day Last Year.

  • The Elegant template has better support for subreports.

  • There are new templates: Elegant With Subreport Spaces and Elegant With Indented Group Headers.

  • If a scheduled report can't be emailed, the error code is now -35 instead of the generic "some error occurred" -12.

Stonefield Query for Sage 300 Version 6.1

We are pleased to announce the release of version 6.1 of Stonefield Query for Sage 300. There are lots of new features in this release.

  • A new type of output is available for chart reports: Microsoft Excel - Chart, which outputs to an Excel chart rather than an Excel spreadsheet containing an image, which is what Microsoft Excel - Full Format does.

  • The Find Reports by Name and Find Reports Using Field functions have been combined into a single Find Reports function in the Tools menu. The dialog displayed when you choose this function allows you to find all reports having a keyword in the name or comment, being last modified on or after a certain date, or containing a specified field.

  • Many optional settings that had to be set by manually editing Data.ini are now maintained in the Options dialog.

  • The new No Group Footer option for a grouped field specifies that you don't want a group footer for that field.

  • You can now fine-tune label dimensions in step 5 of the Label Wizard.

  • The new Add group to file name output option allows you to determine when the group name is added to the file name. This also allows you to do Microsoft Word Merge output to separate documents.

  • You can now use HTML tags in the body of a email.

  • You now only get a warning when a summary report containing ungrouped and unsummarized fields is previewed in the Quick Report Wizard, not when it's run any other time.

  • You can now select Highest and Lowest for Summary of a non-numeric grouping formula. This makes it easy to find the oldest or earliest invoice date by customer, for example.

  • There is better support for group recalculation formulas. You can now sort a report on such a formula. These formulas are now significantly faster than before, especially in summary reports. You can now use calculated fields in the numerator or denominator or for the grouping of these formulas.

  • The new Create bookmarks on this field setting in the Group Header Band Properties dialog in the Advanced Report Designer does the same thing that setting does in the Field Properties dialog in the report wizard, but you can now control it for advanced layout reports.

  • More complex SQL statements (those with more terms in parts of the statement) are now supported.

  • The AfterData script of a report now has access to the result set for a cross-tab before it's pivoted. It also has access to the result set used for a chart in a quick or cross-tab report that includes a chart through the ChartResultSet variable.

  • You now get a warning when creating a formula that does division that doesn't check if the denominator may be zero to avoid "division by zero" errors.

  • Blank row fields now display "(None)" for the value in a cross-tab report.

  • Bookmarks on grouped fields in summary report are now supported.

  • The ask-at-runtime filter dialog now shows which condition of the total number of conditions you're currently on.

  • The default setting for the Run report with no records option for new quick and cross-tab reports is now turned on. That means unless you turn it off, when you run a report that has no records matching the filter conditions, the report runs but displays a blank report.

  • The Commonly used expressions list in the Expression Builder has new items for First Day of Last Year, Last Day of Last Year, and This Day Last Year.

  • The Elegant template has better support for subreports.

  • There are new templates: Elegant With Subreport Spaces and Elegant With Indented Group Headers.

  • If a scheduled report can't be emailed, the error code is now -35 instead of the generic "some error occurred" -12.

Thursday, May 18, 2017

Stonefield Query SDK Version 6.1

We are pleased to announce the release of version 6.1 of the Stonefield Query SDK. There are lots of new features in this release.

Report Designer
  • A new type of output is available for chart reports: Microsoft Excel - Chart, which outputs to an Excel chart rather than an Excel spreadsheet containing an image, which is what Microsoft Excel - Full Format does.

  • The Find Reports by Name and Find Reports Using Field functions have been combined into a single Find Reports function in the Tools menu. The dialog displayed when you choose this function allows you to find all reports having a keyword in the name or comment, being last modified on or after a certain date, or containing a specified field.

  • Many optional settings that had to be set by manually editing Data.ini are now maintained in the Options dialog.

  • The new No Group Footer option for a grouped field specifies that you don't want a group footer for that field.

  • You can now fine-tune label dimensions in step 5 of the Label Wizard.

  • The new Add group to file name output option allows you to determine when the group name is added to the file name. This also allows you to do Microsoft Word Merge output to separate documents.

  • You can now use HTML tags in the body of a email.

  • You now only get a warning when a summary report containing ungrouped and unsummarized fields is previewed in the Quick Report Wizard, not when it's run any other time.

  • You can now select Highest and Lowest for Summary of a non-numeric grouping formula. This makes it easy to find the oldest or earliest invoice date by customer, for example.

  • There is better support for group recalculation formulas. You can now sort a report on such a formula. These formulas are now significantly faster than before, especially in summary reports. You can now use calculated fields in the numerator or denominator or for the grouping of these formulas.

  • The new Create bookmarks on this field setting in the Group Header Band Properties dialog in the Advanced Report Designer does the same thing that setting does in the Field Properties dialog in the report wizard, but you can now control it for advanced layout reports.

  • More complex SQL statements (those with more terms in parts of the statement) are now supported.

  • The AfterData script of a report now has access to the result set for a cross-tab before it's pivoted. It also has access to the result set used for a chart in a quick or cross-tab report that includes a chart through the ChartResultSet variable.

  • You now get a warning when creating a formula that does division that doesn't check if the denominator may be zero to avoid "division by zero" errors.

  • Blank row fields now display "(None)" for the value in a cross-tab report.

  • Bookmarks on grouped fields in summary report are now supported.

  • The ask-at-runtime filter dialog now shows which condition of the total number of conditions you're currently on.

  • The default setting for the Run report with no records option for new quick and cross-tab reports is now turned on. That means unless you turn it off, when you run a report that has no records matching the filter conditions, the report runs but displays a blank report.

  • The Commonly used expressions list in the Expression Builder has new items for First Day of Last Year, Last Day of Last Year, and This Day Last Year.

  • The Elegant template has better support for subreports.

  • There are new templates: Elegant With Subreport Spaces and Elegant With Indented Group Headers.

  • If a scheduled report can't be emailed, the error code is now -35 instead of the generic "some error occurred" -12.

Stonefield Query Studio

Tuesday, March 21, 2017

Stonefield Query Enterprise Web Version 3.5 Released

Stonefield Software is pleased to announce the release of version 3.5 of Stonefield Query Enterprise Web. There are dozens of new features in this release, with several major ones listed below. See the online help for both Stonefield Query and Stonefield Query Studio for a complete list of new features.

Stonefield Query
  • A new report type, Batch Report, is now available. A batch report allows you to combine multiple reports in to a single output file in CSV, TXT, PDF, or XLSX formats.

  • Another new report type, SQL Passthrough, is also available for advanced users. A SQL Passthrough report allows you to build a report by entering a SQL Statement, then executing that SQL Statement against your database. The resulting report will have a report field that corresponds to each column in the data set retrieved from the database.

Stonefield Query Studio
  • Meta data discovery now works with any database with a .NET provider and can handle tables with more than 255 fields. After discovery is complete, a dialog may appear if there were issues that need to be addressed.

Wednesday, March 15, 2017

Stonefield Query for Act! Version 6.0.6250

We are pleased to announce the release of version 6.0.6250 of Stonefield Query for Act!. The changes in this release are:
  • Stonefield Query is now compatible with Act! v19.1 (2017.1).
  • Stonefield Query for Act! now includes a Convert Report to New Provider function, available on the Tools menu. This function will attempt to convert a report written with the older provider into one using the new provider.

Monday, January 23, 2017

Stonefield Query for Act! Version 6.0.6201

We are pleased to announce the release of version 6.0.6201 of Stonefield Query for Act!. The major purpose of this release is to add compatibility for the new Act! v19. The changes in this release are:
  • Stonefield Query is now compatible with Act! v19 (2017).
  • New fields "Field Changed Field", "Field Changed From Value", and "Field Changed To Value" were added to the Company History, Contact History, Group History, and Opportunity History tables in the Act! 2010+ data provider. For "Field Changed" history records, these new fields parse out their information from the details text. For other history records, these new fields simply show a blank value.
  • The SwiftPage sample reports were updated to use the newer Act! 2010+ data provider.