Dashboards have been updated with a new modern web dashboard control. Dashboards now allow you to display a number of inter-connected data analysis elements such as grids, charts, maps, gauges, and others; all within an automatically-arranged layout.

A new report monitor dialog is available. You can use this tool to monitor active reports. If a report is consuming too many server resources, you can also request that the server try to cancel the report from this screen.

When turning on Two Factor Authentication, the generated QR Code now has an issuer defined for apps that require it.

The manage reports dialog has new “Updated by” and “Updated on” columns.

When creating a new formula, it’s no longer necessary to preview the formula before saving. Instead, a warning is shown if the formula hasn’t been previewed first.

Improved performance in the browser when creating formulas in a project with a large data dictionary.

You can now include multiple subreports in the header of a report.

Added a preview button to dashboard wizard to allow previewing changes before saving.

You can now use charts and pivot grids directly in a report with an advanced layout.

You can now customize the name of the cookie that Horizon Reports sends to the browser.

When refreshing the data dictionary, you can now choose specific tables to refresh from a list.

The database tree view will now scroll to the previously selected item after a change.

If you launch Horizon Reports with no project created, you are now automatically prompted to create a new project.

You can now highlight items in the database tree view by last updated date or keyword search.

Added Format presets for different data types.

In Studio, you can now right-click on a table and choose View Table Contents to retrieve and view the table.

Added a connection string builder to Studio to help creating database connection strings.

You can now test relations with a new Test button.

The BeforeExportReport plugin method now supports changes to the export options for the report.

Moved the default location for hrsettings.json file to Project_Data. This allows setting the file permissions for the application root folder to read-only. Previous installations that have hrsettings.json in the application root will still continue to work normally.

Added support for string concat (||) operator when reporting against a data source that requires it (like SQLite).

Added new URL for directly exporting a report to file.

Stonefield Query Enterprise is now called Horizon Reports. The functionality that was previously located in the separate Stonefield Query Studio tool is now part of the web application. As a result, Horizon Reports only has one installer that can be used for both development and production environments.

Horizon Reports now uses .NET 6. This means that plugins will need to be recompiled in order to work with this release. Make sure to update the references in your plugin code from Stonefield/Stonefield.Query to HorizonReports.

The Horizon Reports API is now available as a Nuget package. When updating plugins, remove old references to Stonefield Query assemblies and add a reference to HorizonReports.Api on nuget instead.

Horizon Reports now uses entity framework to store the project and data dictionary settings, and supports SQLite, SQL Server, or MySQL/MariaDB. The first time you launch the new version, you’ll be prompted to enter the connection information for a new database. Afterwards, you can edit the hrsettings.json file to make changes to the connection settings. If there’s already a previous Stonefield Query Enterprise project in place, it will be imported automatically.

Horizon Reports now uses the NLog logging package instead of log4net to generate application logs. If you previously used a custom logging provider file with log4net, please contact support for assistance.

Creating a log support package now includes archived logs as well.

When using the MariaDB ODBC driver, MySQL specific connection settings are now used.

You can now bypass external authentication by passing a username and password as URL parameters. You could use this to log in with an Administrator account if necessary.

The first time a user logs in, they are now prompted to take a tour of the reports explorer.

Added new template objects, “GroupFooterSummaryTypeTemplate” and “SummaryFieldTypeTemplate”. These allow you to display the summary type being performed in a group footer or report footer respectively. See the new “Standard with Summary Type” template for an example of how to use it.

Administrators can now restrict acccess to email settings.

You can now change the location of point labels for Pie, Bar, and Line charts.

You can now add a shadow to chart types that support it.

Chart reports now support using a date field as the Category.

The advanced report designer can now be used to edit the layout of Charts.

You can now set templates for a chart report. The default template for charts is the new basic template called Standard Chart.

Cross-tab reports now support templates without a header band.

Cross-tab reports now support multiple embedded subreports.

Formulas created when inside a report wizard will automatically be added to the report.

You can now search formulas using the real name of the formula field (e.x. CALC20220193203922).

When working with date values in a filter condition, the entire date is now selected when you move to a date input. This allows you to immediately start typing a new value and it will automatically clear the old value.

You now get a warning if you enter an invalid date range for an “is between” filter condition.