Friday, May 22, 2020

Stonefield Query for GoldMine Version 7.5 Released

We are pleased to announce the release of version 7.5 of Stonefield Query for GoldMine. Here are the new features.
  • Clicking a data point in a chart in a dashboard may now refresh other charts in the dashboard. This allows you, for example, to have a chart showing sales by year and another chart showing sales by month in a specific year. Clicking a year in the first chart changes the year used in the second one.
  • Related to the previous feature, you can have a chart in a dashboard automatically cycle through its X-axis values as filter values for other reports in the dashboard.
  • You can now specify that a chart included in a quick or cross-tab report should appear on its own page.
  • Charts now show "(None)" instead of a blank series.
  • The Output each group as a separate file option for outputting to file or email is now supported for chart reports.
  • The paging control in a chart now only appears if there's more than one page of data points.
  • Column heading objects no longer appear on the last page of a report containing a chart at the bottom.
  • Negative numbers formatted to display with parentheses are now right-justified on the last numeric position rather than on the closing parenthesis.
  • You can now specify vertical alignment for objects—top, middle, or bottom—in the Advanced Report Designer.
  • The connection process for SQL Server databases with TLS 1.2 enabled has been improved.
  • Microsoft Excel documents created by outputting a report using Excel Data-Only (Fast) output now support the desired font and size for each column and display fields formatted as % properly.
  • Tooltips are now supported. You can specify the tooltip for a field in the Properties dialog and that tooltip appears when you hover the mouse over a value for that field in the Preview window, in a PDF file, and in a HTML file.
  • You can now enter comments for a folder when you create or edit it and the comments are shown on the Information page of the Reports Explorer.
  • The default value for the Weeks starts on setting in the Options dialog is now the same as your Windows Regional Settings.
  • You can now report on several fields in the reports table, including Comments, Created By, and Created At, in the usage reporting module.
  • Preview functionality in the Advanced Report Designer that was removed in version 7.2 was restored.
  • The default for the Display grid lines setting is now turned on.
  • Cross-tab reports output to Excel Data-Only (Fast) now handle numeric row fields as numeric and don't include subtotals.
  • You can now optionally sum a numeric field in the row of a cross-tab report.
  • You can now specify a list of values for the user to choose from in the GetValuesForParameter function.
  • You can now create and populate a ValuesCollection object using the new ValuesCollection function.
  • Emailing using SMTP now handles email servers that use a newer protocol for SSL.

Wednesday, May 20, 2020

Stonefield Query for Sage Pro ERP Version 7.5 Released

We are pleased to announce the release of version 7.5 of Stonefield Query for Sage Pro ERP. Here are the new features.
  • Clicking a data point in a chart in a dashboard may now refresh other charts in the dashboard. This allows you, for example, to have a chart showing sales by year and another chart showing sales by month in a specific year. Clicking a year in the first chart changes the year used in the second one.
  • Related to the previous feature, you can have a chart in a dashboard automatically cycle through its X-axis values as filter values for other reports in the dashboard.
  • You can now specify that a chart included in a quick or cross-tab report should appear on its own page.
  • Charts now show "(None)" instead of a blank series.
  • The Output each group as a separate file option for outputting to file or email is now supported for chart reports.
  • The paging control in a chart now only appears if there's more than one page of data points.
  • Column heading objects no longer appear on the last page of a report containing a chart at the bottom.
  • Negative numbers formatted to display with parentheses are now right-justified on the last numeric position rather than on the closing parenthesis.
  • You can now specify vertical alignment for objects—top, middle, or bottom—in the Advanced Report Designer.
  • Microsoft Excel documents created by outputting a report using Excel Data-Only (Fast) output now support the desired font and size for each column and display fields formatted as % properly.
  • Tooltips are now supported. You can specify the tooltip for a field in the Properties dialog and that tooltip appears when you hover the mouse over a value for that field in the Preview window, in a PDF file, and in a HTML file.
  • You can now enter comments for a folder when you create or edit it and the comments are shown on the Information page of the Reports Explorer.
  • The default value for the Weeks starts on setting in the Options dialog is now the same as your Windows Regional Settings.
  • You can now report on several fields in the reports table, including Comments, Created By, and Created At, in the usage reporting module.
  • Preview functionality in the Advanced Report Designer that was removed in version 7.2 was restored.
  • The default for the Display grid lines setting is now turned on.
  • Cross-tab reports output to Excel Data-Only (Fast) now handle numeric row fields as numeric and don't include subtotals.
  • You can now optionally sum a numeric field in the row of a cross-tab report.
  • You can now specify a list of values for the user to choose from in the GetValuesForParameter function.
  • You can now create and populate a ValuesCollection object using the new ValuesCollection function.
  • Emailing using SMTP now handles email servers that use a newer protocol for SSL.

Stonefield Query for Sage 300 Version 7.5 Released

We are pleased to announce the release of version 7.5 of Stonefield Query for Sage 300. Here are the new features.
  • Clicking a data point in a chart in a dashboard may now refresh other charts in the dashboard. This allows you, for example, to have a chart showing sales by year and another chart showing sales by month in a specific year. Clicking a year in the first chart changes the year used in the second one.
  • Related to the previous feature, you can have a chart in a dashboard automatically cycle through its X-axis values as filter values for other reports in the dashboard.
  • You can now specify that a chart included in a quick or cross-tab report should appear on its own page.
  • Charts now show "(None)" instead of a blank series.
  • The Output each group as a separate file option for outputting to file or email is now supported for chart reports.
  • The paging control in a chart now only appears if there's more than one page of data points.
  • Column heading objects no longer appear on the last page of a report containing a chart at the bottom.
  • Negative numbers formatted to display with parentheses are now right-justified on the last numeric position rather than on the closing parenthesis.
  • You can now specify vertical alignment for objects—top, middle, or bottom—in the Advanced Report Designer.
  • Microsoft Excel documents created by outputting a report using Excel Data-Only (Fast) output now support the desired font and size for each column and display fields formatted as % properly.
  • Tooltips are now supported. You can specify the tooltip for a field in the Properties dialog and that tooltip appears when you hover the mouse over a value for that field in the Preview window, in a PDF file, and in a HTML file.
  • You can now enter comments for a folder when you create or edit it and the comments are shown on the Information page of the Reports Explorer.
  • The default value for the Weeks starts on setting in the Options dialog is now the same as your Windows Regional Settings.
  • You can now report on several fields in the reports table, including Comments, Created By, and Created At, in the usage reporting module.
  • Preview functionality in the Advanced Report Designer that was removed in version 7.2 was restored.
  • The default for the Display grid lines setting is now turned on.
  • Cross-tab reports output to Excel Data-Only (Fast) now handle numeric row fields as numeric and don't include subtotals.
  • You can now optionally sum a numeric field in the row of a cross-tab report.
  • You can now specify a list of values for the user to choose from in the GetValuesForParameter function.
  • You can now create and populate a ValuesCollection object using the new ValuesCollection function.
  • Emailing using SMTP now handles email servers that use a newer protocol for SSL.

Friday, May 1, 2020

Stonefield Query SDK Version 7.5

We are pleased to announce the release of version 7.5 of the Stonefield Query SDK. Here are the new features.

Report Designer
  • Clicking a data point in a chart in a dashboard may now refresh other charts in the dashboard. This allows you, for example, to have a chart showing sales by year and another chart showing sales by month in a specific year. Clicking a year in the first chart changes the year used in the second one.
  • Related to the previous feature, you can have a chart in a dashboard automatically cycle through its X-axis values as filter values for other reports in the dashboard.
  • You can now specify that a chart included in a quick or cross-tab report should appear on its own page.
  • Charts now show "(None)" instead of a blank series.
  • The Output each group as a separate file option for outputting to file or email is now supported for chart reports.
  • The paging control in a chart now only appears if there's more than one page of data points.
  • Column heading objects no longer appear on the last page of a report containing a chart at the bottom.
  • Negative numbers formatted to display with parentheses are now right-justified on the last numeric position rather than on the closing parenthesis.
  • You can now specify vertical alignment for objects—top, middle, or bottom—in the Advanced Report Designer.
  • Microsoft Excel documents created by outputting a report using Excel Data-Only (Fast) output now support the desired font and size for each column and display fields formatted as % properly.
  • Tooltips are now supported. You can specify the tooltip for a field in the Properties dialog and that tooltip appears when you hover the mouse over a value for that field in the Preview window, in a PDF file, and in a HTML file.
  • You can now enter comments for a folder when you create or edit it and the comments are shown on the Information page of the Reports Explorer.
  • The default value for the Weeks starts on setting in the Options dialog is now the same as your Windows Regional Settings.
  • You can now report on several fields in the reports table, including Comments, Created By, and Created At, in the usage reporting module.
  • Preview functionality in the Advanced Report Designer that was removed in version 7.2 was restored.
  • The default for the Display grid lines setting is now turned on.
  • Cross-tab reports output to Excel Data-Only (Fast) now handle numeric row fields as numeric and don't include subtotals.
  • You can now optionally sum a numeric field in the row of a cross-tab report.
  • You can now specify a list of values for the user to choose from in the GetValuesForParameter function.
  • You can now create and populate a ValuesCollection object using the new ValuesCollection function.
  • Emailing using SMTP now handles email servers that use a newer protocol for SSL.
Stonefield Query Studio
  • You can now specify comments for database, table, and relation objects in Studio. These comments aren't used anywhere but are output when you use the Export to Excel function.
  • To better support email servers using newer SSL protocols, three new files have to be distributed with Stonefield Query: MimeKit.dll, MailKit.dll, and BouncyCastle.Crypto.dll. Be sure to update or regenerate your installer script.
  • TaskScheduler.dll is no longer deployed since it was only used on Windows XP and earlier systems and Stonefield Query now requires Windows Vista and later.
  • There's a new ReportRunCancelled property for ReportEngine, a new ProcessID property for Application, and a new Tooltip property for ReportField.
  • You can now specify a list of values for the user to choose from in the GetValuesForParameter function.
  • You can now create and populate a ValuesCollection object using the new ValuesCollection function.

Thursday, February 20, 2020

Stonefield Query Enterprise Version 5.1

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

  • You can now specify a page field for Cross Tab reports.

  • When you rename a report, any custom file names stored with the export options for that report are now cleared.

  • You can now set a duration for the repeat interval of a scheduled task.

  • A user with a Report Viewer license can now edit the filter conditions of a report.

  • If a schedule fails because one of the reports didn't match any records, we now display a more specific error message about this.

  • When sending emails using the credentials of an Administrator account, email address of the user account is now used as the From address. This allows an email service like SendGrid to send from a previously verified domain.

  • A new report management interface is available under the tools menu. This allows you to change the roles or tenant setting for multiple reports at the same time. You can also delete multiple reports using this interface, rather than having to delete them one at a time.

  • Fields with a display expression can now be output to the Excel Data Only format.

  • Chart reports now automatically switch to landscape if the width of the chart exceeds the width of the page in portrait.

  • You can now set a license limit on a per Tenant basis. For example, if a Tenant has a license limit of 2, then only 2 users from that Tenant will be able to log in concurrently.

Tuesday, December 3, 2019

Stonefield Query for ALERE Version 7.4

We are pleased to announce the release of version 7.4 of Stonefield Query for ALERE. Here are the new features.

  • There's a new option when emailing a report: Embed report in email. Turn this on to include the report as HTML in the body of the email.

  • There's a new output type: Microsoft Word Merge to a PDF file.

  • Output to Microsoft Excel Full Format (XLSX file) and Microsoft Word (DOCX file) is now supported from a scheduled task since those formats no longer need the application (Excel or Word) to be installed on the system and run during output.

  • Output to HTML is now supported when emailing.

  • Users who have the Advanced setting turned off can no longer view snapshots for report runs nor turn that setting on in the Options dialog.

  • Grouping formulas that contain ask-at-runtime filter conditions now put the values of those conditions into the Parameters collection of the report object so they can be used if necessary, such as in a report header.

  • You can now change the Data group or table for an existing formula when you edit it from the Formulas dialog. You still can't change those when you edit the formula from step 2 of the report wizards.

  • If you want to manually create the result set for a report in the AfterData script of the report, enter "*:" for the SQL statement in the Customize Report Wizard to indicate that Stonefield Query should not retrieve any data itself.

  • You can now pass a single default value rather than a collection of values as the default parameter for the GetValueForParameter and GetValueForField functions if you aren't using the between or is one of operators.

  • The Check for Updates function now works with our recently changed web server.

  • A better message is displayed if testing the email settings in the Options dialog fails.

  • <img> tags are now supported in HTML content when the Display as setting in the Field Properties dialog is set to "Formatted HTML".

  • Information for several data.ini options was added to the documentation.

Monday, December 2, 2019

Stonefield Query for AccountMate Version 7.4

We are pleased to announce the release of version 7.4 of Stonefield Query for AccountMate. Here are the new features.

  • There's a new option when emailing a report: Embed report in email. Turn this on to include the report as HTML in the body of the email.

  • There's a new output type: Microsoft Word Merge to a PDF file.

  • Output to Microsoft Excel Full Format (XLSX file) and Microsoft Word (DOCX file) is now supported from a scheduled task since those formats no longer need the application (Excel or Word) to be installed on the system and run during output.

  • Output to HTML is now supported when emailing.

  • Users who have the Advanced setting turned off can no longer view snapshots for report runs nor turn that setting on in the Options dialog.

  • Grouping formulas that contain ask-at-runtime filter conditions now put the values of those conditions into the Parameters collection of the report object so they can be used if necessary, such as in a report header.

  • You can now change the Data group or table for an existing formula when you edit it from the Formulas dialog. You still can't change those when you edit the formula from step 2 of the report wizards.

  • If you want to manually create the result set for a report in the AfterData script of the report, enter "*:" for the SQL statement in the Customize Report Wizard to indicate that Stonefield Query should not retrieve any data itself.

  • You can now pass a single default value rather than a collection of values as the default parameter for the GetValueForParameter and GetValueForField functions if you aren't using the between or is one of operators.

  • The Check for Updates function now works with our recently changed web server.

  • A better message is displayed if testing the email settings in the Options dialog fails.

  • <img> tags are now supported in HTML content when the Display as setting in the Field Properties dialog is set to "Formatted HTML".

  • Information for several data.ini options was added to the documentation.

Wednesday, November 20, 2019

Reporting4Act! Version 7.4

Note that as of version 7.0, Stonefield Query for Act! is now known as Reporting4Act! - Powered by Stonefield Query.

We are pleased to announce the release of version 7.4 of Reporting4Act!. Here are the new features.

  • Reporting4Act! is now compatible with the new Act! v22.

  • Reporting4Act! now offers to check for an updated version if no compatible Act! installation is found. This helps to handle the situation where Act! has been updated to a new version and Reporting4Act! has not.

  • The conversion process for updating reports created with the older Act! data provider now updates the report's advanced layout, if one exists.

  • There's a new option when emailing a report: Embed report in email. Turn this on to include the report as HTML in the body of the email.

  • There's a new output type: Microsoft Word Merge to a PDF file.

  • Output to Microsoft Excel Full Format (XLSX file) and Microsoft Word (DOCX file) is now supported from a scheduled task since those formats no longer need the application (Excel or Word) to be installed on the system and run during output.

  • Output to HTML is now supported when emailing.

  • Users who have the Advanced setting turned off can no longer view snapshots for report runs nor turn that setting on in the Options dialog.

  • Grouping formulas that contain ask-at-runtime filter conditions now put the values of those conditions into the Parameters collection of the report object so they can be used if necessary, such as in a report header.

  • You can now change the Data Provider or table for an existing formula when you edit it from the Formulas dialog. You still can't change those when you edit the formula from step 2 of the report wizards.

  • If you want to manually create the result set for a report in the AfterData script of the report, enter "*:" for the SQL statement in the Customize Report Wizard to indicate that Stonefield Query should not retrieve any data itself.

  • You can now pass a single default value rather than a collection of values as the default parameter for the GetValueForParameter and GetValueForField functions if you aren't using the between or is one of operators.

  • The Check for Updates function now works with our recently changed web server.

  • A better message is displayed if testing the email settings in the Options dialog fails.

  • <img> tags are now supported in HTML content when the Display as setting in the Field Properties dialog is set to "Formatted HTML".

  • There have been several minor improvements to the documentation.

Monday, November 18, 2019

Stonefield Query for GoldMine Version 7.4

We are pleased to announce the release of version 7.4 of Stonefield Query for GoldMine. Here are the new features.

  • Stonefield Query is compatible with GoldMine 2019.

  • Several new E-mail fields were added to the Main table.

  • There's a new option when emailing a report: Embed report in email. Turn this on to include the report as HTML in the body of the email.

  • There's a new output type: Microsoft Word Merge to a PDF file.

  • Output to Microsoft Excel Full Format (XLSX file) and Microsoft Word (DOCX file) is now supported from a scheduled task since those formats no longer need the application (Excel or Word) to be installed on the system and run during output.

  • Output to HTML is now supported when emailing.

  • Users who have the Advanced setting turned off can no longer view snapshots for report runs nor turn that setting on in the Options dialog.

  • Grouping formulas that contain ask-at-runtime filter conditions now put the values of those conditions into the Parameters collection of the report object so they can be used if necessary, such as in a report header.

  • You can now change the Data group or table for an existing formula when you edit it from the Formulas dialog. You still can't change those when you edit the formula from step 2 of the report wizards.

  • If you want to manually create the result set for a report in the AfterData script of the report, enter "*:" for the SQL statement in the Customize Report Wizard to indicate that Stonefield Query should not retrieve any data itself.

  • You can now pass a single default value rather than a collection of values as the default parameter for the GetValueForParameter and GetValueForField functions if you aren't using the between or is one of operators.

  • The Check for Updates function now works with our recently changed web server.

  • A better message is displayed if testing the email settings in the Options dialog fails.

  • <img> tags are now supported in HTML content when the Display as setting in the Field Properties dialog is set to "Formatted HTML".

  • Information for several data.ini options was added to the documentation.

Wednesday, November 6, 2019

Stonefield Query for Sage Pro Version 7.4

We are pleased to announce the release of version 7.4 of Stonefield Query for Sage Pro. Here are the new features.

  • Sage 300 2020 is now supported.

  • There's a new option when emailing a report: Embed report in email. Turn this on to include the report as HTML in the body of the email.

  • There's a new output type: Microsoft Word Merge to a PDF file.

  • Output to Microsoft Excel Full Format (XLSX file) and Microsoft Word (DOCX file) is now supported from a scheduled task since those formats no longer need the application (Excel or Word) to be installed on the system and run during output.

  • Output to HTML is now supported when emailing.

  • Users who have the Advanced setting turned off can no longer view snapshots for report runs nor turn that setting on in the Options dialog.

  • Grouping formulas that contain ask-at-runtime filter conditions now put the values of those conditions into the Parameters collection of the report object so they can be used if necessary, such as in a report header.

  • You can now change the Data group or table for an existing formula when you edit it from the Formulas dialog. You still can't change those when you edit the formula from step 2 of the report wizards.

  • If you want to manually create the result set for a report in the AfterData script of the report, enter "*:" for the SQL statement in the Customize Report Wizard to indicate that Stonefield Query should not retrieve any data itself.

  • You can now pass a single default value rather than a collection of values as the default parameter for the GetValueForParameter and GetValueForField functions if you aren't using the between or is one of operators.

  • The Check for Updates function now works with our recently changed web server.

  • A better message is displayed if testing the email settings in the Options dialog fails.

  • <img> tags are now supported in HTML content when the Display as setting in the Field Properties dialog is set to "Formatted HTML".