Stonefield Query for Sage 300 Version 8.0

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

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