Stonefield Query for Sage Pro ERP Version 8.6

We are pleased to announce the release of version 8.6 of Stonefield Query for Sage Pro ERP. 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 300 Version 8.6

We are pleased to announce the release of version 8.6 of Stonefield Query for Sage 300. 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.

• Sage 300 2026 is now supported

Stonefield Query for GoldMine Version 8.6

We are pleased to announce the release of version 8.6 of Stonefield Query for GoldMine. 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 ALERE Version 8.6

We are pleased to announce the release of version 8.6 of Stonefield Query for ALERE. 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.

• Alere 20 is now supported.

Stonefield Query for Goldmine Version 8.6

We are pleased to announce the release of version 8.6 of Stonefield Query for GoldMine. 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 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.

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

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

Stonefield Query SDK Version 8.1

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

Report Designer

• The new Data Grid button in the ribbon and toolbar output a report to a data grid window.

• Everywhere a password can be entered, such as the login dialog or the Email page of the Options dialog, now has a "show password" button that toggles whether the password is shown as plain text or "*****" (it's always stored encrypted regardless of the setting of that button).

• You can now control what folder scheduled tasks are placed in rather than always being in the "root" folder in the Task Scheduler.

• The Test Syntax button in the Customize SQL Statement step of the Customize Report Wizard now tests whether the SQL statement works with the database engine you're connected to; previously, it only tested whether it was valid in Stonefield Query.

• If Shutdown.txt exists at startup (created either by checking for updates or clicking the Shutdown button in the Displayed Logged in Users dialog), you are now prompted whether maintenance has been completed and if you respond yes, that file is deleted and startup continues.

Stonefield Query Studio

• The View Table Contents and View Field Contents windows now have search, filter, and export to Microsoft Excel functionality.

• Project encryption is no longer supported.

• VFP9R.dll, VFP9RENU.dll, and ISXDL.dll are no longer installed since they are no longer required.

• The Generate Setup function now requires Inno Setup version 6.1 or later.

• The installer has a more modern icon and appearance.

Stonefield Query for GoldMine Version 8.0.7947

We are pleased to announce the release of version 8.0.7947 of Stonefield Query for GoldMine. The main purpose of this release is for compatibility with the new GoldMine 2021.2. The new features in this version are:

• Stonefield Query is compatible with GoldMine 2021.2.

• An issue causing some report output layouts to be distorted was resolved.

All new features and improvements from earlier version 8.0 releases are also included in 8.0.7947.

Stonefield Query SDK Version 8.0

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

Report Designer

• You can now choose to display a Microsoft Office-like ribbon rather than a toolbar and menu at the top of the Reports Explorer.

• The Microsoft Excel - Data Only and Microsoft Excel - Data-Only (Fast) output types were replaced with a single Microsoft Excel - Data Format output type. Any reports or scheduled tasks using Microsoft Excel - Data Only or Microsoft Excel - Data Only (Fast) now automatically use Microsoft Excel - Data Format instead.

• You can now specify that a field should be output as a bar code in quick and label reports.

• You can now use multiple page columns in a quick report. This is useful for reports that don't have many fields: rather than having the right side of the page empty, another column of records can be output there.

• A new date format is available: Abbrev. Month/Year. This displays a three-letter abbreviation for a month, such as "Jan 2021" for "January", which allows columns in a report, especially a cross-tab report, to be narrower.

• You can now use a dynamic expression for both the foreground (text) and background colors of a field in a report. Also, dynamic colors and font styles are now supported when you output to Microsoft Excel - Data Format.

• You can now specify an email address to be notified when a scheduled report fails due to an error.

• The Scheduled Tasks dialog has three new features: you can stop a running task, you can disable a task without deleting it, and you can select multiple tasks and delete or disable/re-enable them.

• The Preview window has some new features:

  • The new left panel, which can be expanded or collapsed, contains bookmarks, page thumbnails, and search results.
  • The mouse wheel move to the next or previous page when zoom is set to 100% or less, or scrolls within the page when it's more than 100%.
  • There are more choices for Pages to Display: all the way up to 11x5.
  • You can now zoom a report up to 6,000%.

• You can now get the CC email address to use for a report from a field.

• Fields in the group header of a quick report are now left-aligned with each other if they appear on separate lines.

• Turning on the Auto-Fit to Page setting for a cross-tab report now causes the font to be reduced automatically if it can fit all of the columns on one page.

• The GetValueForParameter function now accepts a format parameter.

• Hovering your mouse over the file name in the Output page of the Reports Explorer now shows the type of output as a tooltip. This is helpful because, for example, several output types use XLSX as a file extension.

• The SQL statement generated for a report can now be up to 16,000 characters; previously, the limit was 8,000.

Stonefield Query Studio

• A new file has to be distributed with Stonefield Query: VFPAR.dll. Be sure to update or regenerate your installer script.

• The new GetSQL script for a table returns the SQL statement to use for the table rather than a simple SELECT SomeFields FROM TableName. The benefit of this is that if a virtual table simply needs a single SQL statement, such as a UNION between two real tables, you can avoid creating a Select script for the table. Select scripts cause a query to be split into individual tables when a report is run, which can make a report run slower, especially with tables with a lot of records. A GetSQL script can potentially be significantly faster since the query isn't split in that case but instead the returned SQL statement is used as a subquery for the main SQL statement for the report.

• You can customize the ribbon displayed in the Reports Explorer in the Application.ReportsExplorerReady script.

• A new Build button appears when you choose Connection String for an ODBC connection to a database. Clicking this button displays the Connection String Builder which makes it easier to enter a connection string.

• Online help generated by Stonefield Query Studio has much better searching so there's no need for Google Custom Search. As a result, the Google Custom Search ID configuration setting was removed.

• The Application object has a new RibbonVisible property.

• The Report object has a new CCEMailField property.

• The DataEngine object has a new GetWhereFromSQLStatement method.

• The GetValueForParameter function now accepts a format parameter.

Stonefield Query SDK Version 7.6

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

Report Designer

• You can add a new data source to report on, such as another database or a Microsoft Excel document. Note: you have to be an Administrative user with an Ultimate license to use this feature.
• Related to the previous item, if there is no relationship between the tables used in a report when you add a field in step 2 of the report wizard, you are now prompted to create one rather than just being given a warning.
• You can now visually see the relationships for the tables in a SQL statement by clicking the View button in the Customize SQL Statement step of the Customize Wizard.
• You can now prevent a user running a report from ignoring an ask-at-runtime filter condition.
• The Reports Explorer now shows how long the last run of a report took. This is also available in Usage Reporting.
• You can now force all users to log out by choosing Display Logged in Users from the Tools menu and clicking the Shutdown button. Users have three minutes to finish what they're doing and exit the program or it is terminated. This is handy if you need to install a new version or perform some maintenance that requires all users to be out of the program.
• You can now use Microsoft SQL Server or some other database to host Stonefield Query's data tables, such as Users and Reports, rather than them being DBF files on disk.
• You no longer get a warning message if the Everyone group doesn't have any data sources selected in the Maintain Users and Groups dialog. That allows you to turn off all data sources for all users and then turn it on group by group.
• By default, the Login dialog displays the name of the last user who logged in. You can prevent that by adding AutoLoginName=N to Data.ini.
• Previously, the Login dialog showed a list of data sources available to the system, whether the user who logs in can access them or not. Now, it doesn't display any data sources until the user name is entered and then only shows the data sources that user can access.
• The Logged In Users menu item is now only available for Administrator users.
• You can now specify whether you want to support newer email protocols or not (some mail servers require it) in the Options dialog. You can also now turn on email logging, which is helpful if emails cannot be sent for some reason. You can also determine which of several SSL/TLS settings should be used rather than just on or off.
• You can now customize the subtotals line in the group footer of a report using a template.
• The new SpelledOut function spells out a numeric value. For example, SpelledOut(5.25) returns "Five dollars and 25 cents".
• You can now specify whether a cross-tab report with a page field has column totals or not.
• A message is now displayed if login fails.
• The Windows account a scheduled report runs under no longer has to have run the application to specify email settings. Instead, the email settings for the user who scheduled the report are used.
• The image in the Sample page of the Reports Explorer is now scrollable.

Stonefield Query Studio

• Three new files have to be distributed with Stonefield Query: SMTPLibrary2.dll, Library32.fll, and WinGraphViz.dll. Be sure to update or regenerate your installer script.
• You can now visually see the relationships for a table by clicking the View Relations button in the Properties pane for a table.
• ODBCDataSource has a new property: ConnectionFailureMessage, which is the text of any error that occurs when connecting to the database.
• The new ReportEngine.OnFinishWizard script allows you to execute code when the user clicks the Finish button in a report wizard.
• The new Quiet property of the Application object allows you to determine when Stonefield Query is running without displaying any user interface, such as when running a scheduled report.
• The Log method of the Application object can now handle format strings. This saves having to concatenate strings together for more complex log entries.
• The SaveEmailSettings method of the Application object now accepts Timeout, UseMailKit, and Logging parameters.
• Field captions are now read from IBM DB2 databases.
• The Options.Settings script can now access the Options dialog using the OptionsForm object. This allows you, for example, to programmatically remove a page from the Options dialog.
• The GetReportHeader method of the Report object now accepts a parameter indicating that only the header should be returned, omitting the filter.

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.

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

Stonefield Query for Sage 300 Version 7.4

We are pleased to announce the release of version 7.4 of Stonefield Query for Sage 300. 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".