Stonefield Query SDK Version 8.6

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

• The new Display as Tooltip setting allows point labels for charts to be displayed when you hover the mouse over a data point rather than all the time. This is handy for charts with a lot of data points or where point labels would otherwise overlap if always displayed.

• You can now output each group to separate tabs rather than separate files when outputting to Excel data format.

• The application now supports large data files and queries that result in more than 2 GB of data.

• You can now roll in one report at a time rather than a set of reports in a dashboard.

• Gauges now have a header so they can show the report name and filter conditions.

• You can now specify that a custom SQL statement is sent directly to the database engine as is rather than being processed by the reporting engine first by prefixing the SQL statement with *=. This is necessary for some complex custom SQL statement that the reporting engine may parse incorrectly.

• The new Maintenance Utility provides functions to clean up the reports table, reset the ADMIN password, contact the activation server to refresh licenses, and fix security issues that could cause some users to not have access to some reports.

• You can now specify ACTION=REFRESH on the command line to contact the activation server to refresh licenses.

Stonefield Query for Sage Pro ERP Version 8.5

Stonefield Software is pleased to announce the release of version 8.5 of Stonefield Query for Sage Pro ERP. There are several new features in this version.

• A new report type, Tiled Dashboard, is now available.

• The new Edit button in step 2 of the Dashboard Wizard allows you to edit the selected report included in the dashboard.

• Dashboards now have a toolbar with buttons to pause/restart refreshing or move to the previous or next set of reports.

• Dashboards no longer display a blank cell while a report is being refreshed.

• You can now add a watermark to a report when you print or output to PDF.

• The new Include Totals output setting determines whether totals are included in Microsoft Excel data format documents.

• The Use Saved Email Settings option in the Schedule Report Wizard allows you to specify whether or not to use saved email settings.

• The Advanced Diagnostics setting in the Options dialog creates additional diagnostic files helpful for tracking down certain types of issues.

• The Other Data Sources dialog now has a Refresh button.

• Charts no longer show point labels for 0 values.

• The Commonly Used functions list in the Expression Builder and the list of function when you choose Is as the operator for a filter now both have fiscal year functions.

• You can now ignore certain filter conditions when scheduling a report.

• The GL Chart of Accounts table now appears in the Accounts Payable and Accounts Receivable modules.

Stonefield Query for Sage 300 Version 8.5

Stonefield Software is pleased to announce the release of version 8.5 of Stonefield Query for Sage 300. There are several new features in this version.

• A new report type, Tiled Dashboard, is now available.

• The new Edit button in step 2 of the Dashboard Wizard allows you to edit the selected report included in the dashboard.

• Dashboards now have a toolbar with buttons to pause/restart refreshing or move to the previous or next set of reports.

• Dashboards no longer display a blank cell while a report is being refreshed.

• You can now add a watermark to a report when you print or output to PDF.

• The new Include Totals output setting determines whether totals are included in Microsoft Excel data format documents.

• The Use Saved Email Settings option in the Schedule Report Wizard allows you to specify whether or not to use saved email settings.

• The Advanced Diagnostics setting in the Options dialog creates additional diagnostic files helpful for tracking down certain types of issues.

• The Other Data Sources dialog now has a Refresh button.

• Charts no longer show point labels for 0 values.

• The Commonly Used functions list in the Expression Builder and the list of function when you choose Is as the operator for a filter now both have fiscal year functions.

• You can now ignore certain filter conditions when scheduling a report.

• Sage 300 2025 is now supported.

Stonefield Query for GoldMine Version 8.5

Stonefield Software is pleased to announce the release of version 8.5 of Stonefield Query for GoldMine. There are several new features in this version.

• A new report type, Tiled Dashboard, is now available.

• The new Edit button in step 2 of the Dashboard Wizard allows you to edit the selected report included in the dashboard.

• Dashboards now have a toolbar with buttons to pause/restart refreshing or move to the previous or next set of reports.

• Dashboards no longer display a blank cell while a report is being refreshed.

• You can now add a watermark to a report when you print or output to PDF.

• The new Include Totals output setting determines whether totals are included in Microsoft Excel data format documents.

• The Use Saved Email Settings option in the Schedule Report Wizard allows you to specify whether or not to use saved email settings.

• The Advanced Diagnostics setting in the Options dialog creates additional diagnostic files helpful for tracking down certain types of issues.

• The Other Data Sources dialog now has a Refresh button.

• Charts no longer show point labels for 0 values.

• The Commonly Used functions list in the Expression Builder and the list of function when you choose Is as the operator for a filter now both have fiscal year functions.

• You can now ignore certain filter conditions when scheduling a report.

Reporting4ACT! Version 8.5

Stonefield Software is pleased to announce the release of version 8.5 of Reporting4ACT! There are several new features in this version.

• A new report type, Tiled Dashboard, is now available.

• The new Edit button in step 2 of the Dashboard Wizard allows you to edit the selected report included in the dashboard.

• Dashboards now have a toolbar with buttons to pause/restart refreshing or move to the previous or next set of reports.

• Dashboards no longer display a blank cell while a report is being refreshed.

• You can now add a watermark to a report when you print or output to PDF.

• The new Include Totals output setting determines whether totals are included in Microsoft Excel data format documents.

• The Use Saved Email Settings option in the Schedule Report Wizard allows you to specify whether or not to use saved email settings.

• The Advanced Diagnostics setting in the Options dialog creates additional diagnostic files helpful for tracking down certain types of issues.

• The Other Data Sources dialog now has a Refresh button.

• Charts no longer show point labels for 0 values.

• The Commonly Used functions list in the Expression Builder and the list of function when you choose Is as the operator for a filter now both have fiscal year functions.

• You can now ignore certain filter conditions when scheduling a report.

• Act 26 is now supported.

Stonefield Query for ALERE Version 8.5

Stonefield Software is pleased to announce the release of version 8.5 of Stonefield Query for ALERE. There are several new features in this version.

• A new report type, Tiled Dashboard, is now available.

• The new Edit button in step 2 of the Dashboard Wizard allows you to edit the selected report included in the dashboard.

• Dashboards now have a toolbar with buttons to pause/restart refreshing or move to the previous or next set of reports.

• Dashboards no longer display a blank cell while a report is being refreshed.

• You can now add a watermark to a report when you print or output to PDF.

• The new Include Totals output setting determines whether totals are included in Microsoft Excel data format documents.

• The Use Saved Email Settings option in the Schedule Report Wizard allows you to specify whether or not to use saved email settings.

• The Advanced Diagnostics setting in the Options dialog creates additional diagnostic files helpful for tracking down certain types of issues.

• The Other Data Sources dialog now has a Refresh button.

• Charts no longer show point labels for 0 values.

• The Commonly Used functions list in the Expression Builder and the list of function when you choose Is as the operator for a filter now both have fiscal year functions.

• You can now ignore certain filter conditions when scheduling a report.

• Alere 19 is now supported.

Stonefield Query for AccountMate Version 8.5

Stonefield Software is pleased to announce the release of version 8.5 of Stonefield Query for AccountMate. There are several new features in this version.

• A new report type, Tiled Dashboard, is now available.

• The new Edit button in step 2 of the Dashboard Wizard allows you to edit the selected report included in the dashboard.

• Dashboards now have a toolbar with buttons to pause/restart refreshing or move to the previous or next set of reports.

• Dashboards no longer display a blank cell while a report is being refreshed.

• You can now add a watermark to a report when you print or output to PDF.

• The new Include Totals output setting determines whether totals are included in Microsoft Excel data format documents.

• The Use Saved Email Settings option in the Schedule Report Wizard allows you to specify whether or not to use saved email settings.

• The Advanced Diagnostics setting in the Options dialog creates additional diagnostic files helpful for tracking down certain types of issues.

• The Other Data Sources dialog now has a Refresh button.

• Charts no longer show point labels for 0 values.

• The Commonly Used functions list in the Expression Builder and the list of function when you choose Is as the operator for a filter now both have fiscal year functions.

• You can now ignore certain filter conditions when scheduling a report.

• AccountMate 13.01 is now supported.

Stonefield Query SDK Version 8.5

Stonefield Software is pleased to announce the release of version 8.5 of the Stonefield Query SDK. There are several new features in this version.

Report Designer

• A new report type, Tiled Dashboard, is now available.

• The new Edit button in step 2 of the Dashboard Wizard allows you to edit the selected report included in the dashboard.

• Dashboards now have a toolbar with buttons to pause/restart refreshing or move to the previous or next set of reports.

• Dashboards no longer display a blank cell while a report is being refreshed.

• You can now add a watermark to a report when you print or output to PDF.

• The new Include Totals output setting determines whether totals are included in Microsoft Excel data format documents.

• The Use Saved Email Settings option in the Schedule Report Wizard allows you to specify whether or not to use saved email settings.

• The Advanced Diagnostics setting in the Options dialog creates additional diagnostic files helpful for tracking down certain types of issues.

• The Other Data Sources dialog now has a Refresh button.

• Charts no longer show point labels for 0 values.

• The Commonly Used functions list in the Expression Builder and the list of function when you choose Is as the operator for a filter now both have fiscal year functions.

• You can now ignore certain filter conditions when scheduling a report.

Stonefield Query Studio

• The new DashboardTile property of the Application object indicates which tile of a tile dashboard is currently displayed.

• The new IncludeTotals property of Report objects can be set to True to include totals in Microsoft Excel data format documents.

• MD5.fll is no longer deployed.

• You can hide the Show Password button on the Email page of the Options dialog by setting oApp.lDisplayShowPassword to false in a script, such as Application.AfterSetup or Application.AfterLogin.

Stonefield Query for AccountMate Version 8.4

Stonefield Software is pleased to announce the release of version 8.4 of Stonefield Query for AccountMate. This is mainly a maintenance release but there are a few new features.

• A report can now be scheduled to repeat every so many hours.

• You can now specify that scheduled tasks be synced across time zones.

• The Schedules dialog now has an Import function to allow you to import schedules, such as when moving Stonefield Query from one machine to another.

• The Print Setup dialog now allows you to choose a different paper size and source, overriding the template settings.

• If a formula starts with "=", it's output as a formula to Excel.

• The email settings in effect at the time a report was scheduled was created are used to email the report when the schedule runs.

Stonefield Query for ALERE Version 8.4

Stonefield Software is pleased to announce the release of version 8.4 of Stonefield Query for ALERE. This is mainly a maintenance release but there are a few new features.

• A report can now be scheduled to repeat every so many hours.

• You can now specify that scheduled tasks be synced across time zones.

• The Schedules dialog now has an Import function to allow you to import schedules, such as when moving Stonefield Query from one machine to another.

• The Print Setup dialog now allows you to choose a different paper size and source, overriding the template settings.

• If a formula starts with "=", it's output as a formula to Excel.

• The email settings in effect at the time a report was scheduled was created are used to email the report when the schedule runs.

Reporting4ACT! Version 8.4

Stonefield Software is pleased to announce the release of version 8.4 of Reporting4ACT! This is mainly a maintenance release but there are a few new features.

• A report can now be scheduled to repeat every so many hours.

• You can now specify that scheduled tasks be synced across time zones.

• The Schedules dialog now has an Import function to allow you to import schedules, such as when moving Stonefield Query from one machine to another.

• The Print Setup dialog now allows you to choose a different paper size and source, overriding the template settings.

• If a formula starts with "=", it's output as a formula to Excel.

• The email settings in effect at the time a report was scheduled was created are used to email the report when the schedule runs.

• Act 26 is now supported.

Stonefield Query for GoldMine Version 8.4

Stonefield Software is pleased to announce the release of version 8.4 of Stonefield Query for GoldMine. This is mainly a maintenance release but there are a few new features.

• A report can now be scheduled to repeat every so many hours.

• You can now specify that scheduled tasks be synced across time zones.

• The Schedules dialog now has an Import function to allow you to import schedules, such as when moving Stonefield Query from one machine to another.

• The Print Setup dialog now allows you to choose a different paper size and source, overriding the template settings.

• If a formula starts with "=", it's output as a formula to Excel.

• The email settings in effect at the time a report was scheduled was created are used to email the report when the schedule runs.

Stonefield Query for Sage 300 Version 8.4

Stonefield Software is pleased to announce the release of version 8.4 of Stonefield Query for Sage 300. This is mainly a maintenance release but there are a few new features.

• A report can now be scheduled to repeat every so many hours.

• You can now specify that scheduled tasks be synced across time zones.

• The Schedules dialog now has an Import function to allow you to import schedules, such as when moving Stonefield Query from one machine to another.

• The Print Setup dialog now allows you to choose a different paper size and source, overriding the template settings.

• If a formula starts with "=", it's output as a formula to Excel.

• The email settings in effect at the time a report was scheduled was created are used to email the report when the schedule runs.

• Sage 300 2025 is now supported

Stonefield Query for Sage Pro ERP Version 8.4

Stonefield Software is pleased to announce the release of version 8.4 of Stonefield Query for Sage Pro ERP. This is mainly a maintenance release but there are a few new features.

• A report can now be scheduled to repeat every so many hours.

• You can now specify that scheduled tasks be synced across time zones.

• The Schedules dialog now has an Import function to allow you to import schedules, such as when moving Stonefield Query from one machine to another.

• The Print Setup dialog now allows you to choose a different paper size and source, overriding the template settings.

• If a formula starts with "=", it's output as a formula to Excel.

• The email settings in effect at the time a report was scheduled was created are used to email the report when the schedule runs.

• The GL Chart of Accounts table now appears in the Accounts Payable and Accounts Receivable modules.

Stonefield Query SDK Version 8.4

Stonefield Software is pleased to announce the release of version 8.4 of the Stonefield Query SDK. This is mainly a maintenance release but there are a few new features.

• A report can now be scheduled to repeat every so many hours.

• You can now specify that scheduled tasks be synced across time zones.

• The Schedules dialog now has an Import function to allow you to import schedules, such as when moving Stonefield Query from one machine to another.

• The Print Setup dialog now allows you to choose a different paper size and source, overriding the template settings.

• If a formula starts with "=", it's output as a formula to Excel.

• The email settings in effect at the time a report was scheduled was created are used to email the report when the schedule runs.

Stonefield Query for Sage Pro ERP Version 8.3

Stonefield Software is pleased to announce the release of version 8.3 of Stonefield Query for Sage Pro ERP. There are several new features in this version.

• You can now specify additional files to attach to an email in addition to the file for the report.

• Cross-tab reports now support Highest and Lowest total types for date and datetime fields in the Data area.

• You can now specify the horizontal orientation—left, right, or center, with center being the default—for a chart included in a quick or cross-tab report.

• If you add another data source using the Other Data Sources dialog and that data source isn't available (for example, the other data source is a Microsoft Excel document located on someone's local drive), you no longer get an error message and Stonefield Query will still start up.

• You can now specify that a table added in the Other Data Sources dialog is non-reportable.

• There are several DataGrid enhancements:

  • The new Options dialog allows you to turn on "zebra stripes" (alternate row coloring) and specify what the alternate color is, display zero as blank, display a "splitter" between the grid and any text box for memo fields, auto-fit the grid to the column widths when the form opens, and select the font and size for the grid.
  • The mouse pointer displays as an up arrow (sort ascending), down arrow (sort descending), or "no" symbol (column cannot be sorted) when it's over a column header.
  • Logical (yes/no) fields now display as check boxes.

• You can now choose to not display a row field in a cross-tab report by setting its width to 0.

• The recipient of an emailed report is now logged to the diagnostic file.

• The tool tip for a field in step 2 or 3 of the report wizards now displays if a dynamic color or style is used for the field.

Stonefield Query for Sage 300 Version 8.3

Stonefield Software is pleased to announce the release of version 8.3 of Stonefield Query for Sage 300. There are several new features in this version.

• You can now specify additional files to attach to an email in addition to the file for the report.

• Cross-tab reports now support Highest and Lowest total types for date and datetime fields in the Data area.

• You can now specify the horizontal orientation—left, right, or center, with center being the default—for a chart included in a quick or cross-tab report.

• If you add another data source using the Other Data Sources dialog and that data source isn't available (for example, the other data source is a Microsoft Excel document located on someone's local drive), you no longer get an error message and Stonefield Query will still start up.

• You can now specify that a table added in the Other Data Sources dialog is non-reportable.

• There are several DataGrid enhancements:

  • The new Options dialog allows you to turn on "zebra stripes" (alternate row coloring) and specify what the alternate color is, display zero as blank, display a "splitter" between the grid and any text box for memo fields, auto-fit the grid to the column widths when the form opens, and select the font and size for the grid.
  • The mouse pointer displays as an up arrow (sort ascending), down arrow (sort descending), or "no" symbol (column cannot be sorted) when it's over a column header.
  • Logical (yes/no) fields now display as check boxes.

• You can now choose to not display a row field in a cross-tab report by setting its width to 0.

• The recipient of an emailed report is now logged to the diagnostic file.

• The tool tip for a field in step 2 or 3 of the report wizards now displays if a dynamic color or style is used for the field.

Stonefield Query for GoldMine Version 8.3

Stonefield Software is pleased to announce the release of version 8.3 of Stonefield Query for GoldMine. There are several new features in this version.

• You can now specify additional files to attach to an email in addition to the file for the report.

• Cross-tab reports now support Highest and Lowest total types for date and datetime fields in the Data area.

• You can now specify the horizontal orientation—left, right, or center, with center being the default—for a chart included in a quick or cross-tab report.

• If you add another data source using the Other Data Sources dialog and that data source isn't available (for example, the other data source is a Microsoft Excel document located on someone's local drive), you no longer get an error message and Stonefield Query will still start up.

• You can now specify that a table added in the Other Data Sources dialog is non-reportable.

• There are several DataGrid enhancements:

  • The new Options dialog allows you to turn on "zebra stripes" (alternate row coloring) and specify what the alternate color is, display zero as blank, display a "splitter" between the grid and any text box for memo fields, auto-fit the grid to the column widths when the form opens, and select the font and size for the grid.
  • The mouse pointer displays as an up arrow (sort ascending), down arrow (sort descending), or "no" symbol (column cannot be sorted) when it's over a column header.
  • Logical (yes/no) fields now display as check boxes.

• You can now choose to not display a row field in a cross-tab report by setting its width to 0.

• The recipient of an emailed report is now logged to the diagnostic file.

• The tool tip for a field in step 2 or 3 of the report wizards now displays if a dynamic color or style is used for the field.

Reporting4ACT! Version 8.3

Stonefield Software is pleased to announce the release of version 8.3 of Reporting4ACT! There are several new features in this version.

• You can now specify additional files to attach to an email in addition to the file for the report.

• Cross-tab reports now support Highest and Lowest total types for date and datetime fields in the Data area.

• You can now specify the horizontal orientation—left, right, or center, with center being the default—for a chart included in a quick or cross-tab report.

• If you add another data source using the Other Data Sources dialog and that data source isn't available (for example, the other data source is a Microsoft Excel document located on someone's local drive), you no longer get an error message and Reporting4Act! will still start up.

• You can now specify that a table added in the Other Data Sources dialog is non-reportable.

• There are several DataGrid enhancements:

  • The new Options dialog allows you to turn on "zebra stripes" (alternate row coloring) and specify what the alternate color is, display zero as blank, display a "splitter" between the grid and any text box for memo fields, auto-fit the grid to the column widths when the form opens, and select the font and size for the grid.
  • The mouse pointer displays as an up arrow (sort ascending), down arrow (sort descending), or "no" symbol (column cannot be sorted) when it's over a column header.
  • Logical (yes/no) fields now display as check boxes.

• You can now choose to not display a row field in a cross-tab report by setting its width to 0.

• The recipient of an emailed report is now logged to the diagnostic file.

• The tool tip for a field in step 2 or 3 of the report wizards now displays if a dynamic color or style is used for the field.

• Act 25 (2023) is now supported.

• The new CopyText function puts the specified value on the Windows Clipboard.

• If Reporting4ACT cannot locate the ACT! installation folder for some reason, you can specify it using the ActFolder setting in the [Options] section of Data.ini.

Stonefield Query for AccountMate Version 8.3

Stonefield Software is pleased to announce the release of version 8.3 of  Stonefield Query for AccountMate. There are several new features in this version.

• You can now specify additional files to attach to an email in addition to the file for the report.

• Cross-tab reports now support Highest and Lowest total types for date and datetime fields in the Data area.

• You can now specify the horizontal orientation—left, right, or center, with center being the default—for a chart included in a quick or cross-tab report.

• If you add another data source using the Other Data Sources dialog and that data source isn't available (for example, the other data source is a Microsoft Excel document located on someone's local drive), you no longer get an error message and Stonefield Query will still start up.

• You can now specify that a table added in the Other Data Sources dialog is non-reportable.

• There are several DataGrid enhancements:

  • The new Options dialog allows you to turn on "zebra stripes" (alternate row coloring) and specify what the alternate color is, display zero as blank, display a "splitter" between the grid and any text box for memo fields, auto-fit the grid to the column widths when the form opens, and select the font and size for the grid.
  • The mouse pointer displays as an up arrow (sort ascending), down arrow (sort descending), or "no" symbol (column cannot be sorted) when it's over a column header.
  • Logical (yes/no) fields now display as check boxes.

• You can now choose to not display a row field in a cross-tab report by setting its width to 0.

• The recipient of an emailed report is now logged to the diagnostic file.

• The tool tip for a field in step 2 or 3 of the report wizards now displays if a dynamic color or style is used for the field.