Friday, December 8, 2023

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.

Stonefield Query for ALERE Version 8.3

Stonefield Software is pleased to announce the release of version 8.3 of Stonefield Query for ALERE. 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.

Thursday, November 23, 2023

Stonefield Query SDK Version 8.3

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

Report Designer

  • 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.

  • 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 Studio

  • DataEngine.GetObjectVersion script can check which database the objects belongs to with the ObjectDatabase variable.

  • A new BeforeProcessTables event in SQConfig.sqs allows you to execute custom code before tables are processed when the data dictionary is created or updated from a data source.

  • The new Application.AfterLogin script is called right after the user either successfully or unsuccessfully logs in.

Friday, December 16, 2022

Stonefield Query for Sage 300 Version 8.2.8385

We are pleased to annouce the release of version 8.2.8385 of Stonefield Query for Sage 300. This release supports Sage 300 2023.

Friday, September 30, 2022

Reporting4ACT! Version 8.2

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

  • Stonefield Query now supports Modern Authentication for email.
  • You can now indicate that a stored filter is available for all reports or just the current report.
  • More Avery label types are now supported.
  • Diagnostic files more than 30 days old are now automatically deleted.
  • Spreadsheet output was removed since it was almost never used and is superceded by new Microsoft Excel output formats.
  • Choosing the new Yes to All option when importing multiple reports means you won't be prompted for each one whether it should overwrite the existing report.

Stonefield Query for GoldMine Version 8.2

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

  • Stonefield Query now supports Modern Authentication for email.
  • You can now indicate that a stored filter is available for all reports or just the current report.
  • More Avery label types are now supported.
  • Diagnostic files more than 30 days old are now automatically deleted.
  • Spreadsheet output was removed since it was almost never used and is superceded by new Microsoft Excel output formats.
  • Choosing the new Yes to All option when importing multiple reports means you won't be prompted for each one whether it should overwrite the existing report.