Thursday, July 29, 2021

Stonefield Query for GoldMine Version 8.0.7864

We are pleased to announce the release of version 8.0.7864 of Stonefield Query for GoldMine. This is mainly a maintenance release adding support for the new GoldMine version 2021.1.

Tuesday, July 13, 2021

Reporting4Act! Version 8.0

We are pleased to announce the release of version 8.0 of Reporting4Act!. 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.

Stonefield Query for GoldMine Version 8.0

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

Wednesday, June 16, 2021

Stonefield Query for ALERE Version 8.0

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

Tuesday, June 15, 2021

Stonefield Query for AccountMate Version 8.0

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

Friday, June 4, 2021

Stonefield Query Enterprise Version 6.0

We are pleased to announce the release of version 6.0 of Stonefield Query Enterprise. Here are the new features:

  • Administrators can now create usage reports. When creating a new quick report, use the new "Usage" table to access this data.

  • You can now upload report files to a SFTP server. To specify that the target ftp server should use SFTP, prefix the server name with "sftp://".

  • Report parameters are now available in the Advanced Report Designer.

  • Previewing a chart now displays the same view as when outputting the chart to a file. You'll still see the old chart view if a chart has click actions (e.g. drillthrough).

  • You can now edit the values of parameters for an existing SQL Passthrough report. You'll find these settings under Advanced Report Properties in step 5 of the report wizards.

  • In addition to being displayed with green colored text, "logged in" users now also have an icon displayed next to their entry in the user list. This should be helpful for users with certain types of color blindness.

  • You can now search formulas by name, report or caption (or tenant in a multi-tenant environment).

  • Formulas now display the tenant they belong to in a multi-tenant environment.

  • Tenant administrators can now see all schedules for users in their tenant.

  • Issues with a field display expression no longer prevent the report from running.

  • Added several new loading indicators.

  • Stonefield Query is now built using ASP.NET Core 5.0. This version supports hosting the web application in an IIS Process, where the previous version required the use of a proxy. This should improve performance. If you're migrating from a previous version, see the Migrating from an earlier release topic.

  • Stonefield Query can now automatically compile your plugins for you.

  • A new plugin type, StonefieldQueryCustomReportOutput, allows you to specify a custom output type. By default, Stonefield Query can email a report or upload it to an FTP site. This plugin allows you to specify a new type, like uploading to Azure, or storing in a local document database, for example.

  • A new log file is available, "reportlog.txt". This log file contains a log of which reports were run, when they were run, and how long each took to run.

  • Stonefield Query now supports running in a Web Farm.

  • Stonefield Query no longer uses the Windows scheduler to execute schedules. They now run in process, which means there's a lot less overhead involved in starting a schedule. This also allows the scheduler to take advantage of load balancing when running in a Web Farm.

  • You can now use UNC network paths in a provider connection string (i.e //servername/sharename).

  • Improved startup performance.

  • Users with 2FA enabled are now redirected to an intermediate token page, rather than relying on javascript on the login page to support this.

Thursday, June 3, 2021

Stonefield Query for Sage Pro ERP Version 8.0

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

  • The performance of "Current + History" tables has been improved.

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.

Friday, May 28, 2021

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.

    Wednesday, March 17, 2021

    Reporting4Act! Version 7.6.7743

    We are pleased to announce the release of version 7.6.7743 of Reporting4Act!. This is a small maintenance release. Its main purpose is to add compatibility with Act! v23. Here are the new changes:

    • Reporting4Act! is now compatible with Act! v23.

    • An issue causing formatting codes to be displayed incorrectly in the Contact Related Contacts Details field was corrected.

    This release also includes all the new features from the previous version 7.6 release.