Releases · ariacom/Seal-Report (original) (raw)

Seal Report 8.5

Version 8.5 – Release Notes

New Features 8.5

• Report Restrictions: Added support for handling blank values (NULL or empty) in restriction definitions.
• Web Report Server: Introduced a new “Web Main Additional Script” option to inject dynamic JavaScript into the main page.
• Report Designer: Added a search box to filter elements in the tree view.
• Scheduling: New system report “Schedule Sequencer” to centralize schedule trigger definitions.
• Dependencies: Bump MimeKit from 4.13.0 to 4.15.1 by @dependabot[bot] in #169
• QuestPDF Integration: Add Support for QuestPDF Companion by @nickakin in #171

Issues Addressed (v8.5.0)

• #231: Add/Remove buttons in the collection editor were visible for restricted collections (e.g., Security Parameters).
• #232: Fixed Excel export warning when the report Display Name uses a custom script.

Seal Report 8.4

New Features in Version 8.4

Web Report Server

• Configuration of Security Groups and Logins can now be edited directly from the Web Report Server interface.
• Added new configuration scripts and dialog boxes to manage user password changes and password resets from the Web Report Server.
  • A default implementation is provided for Security Logins.

Email Device

• Integrated the MimeKit library to enhance email formatting, attachment handling, and reliability.

Report Designer

• Improved performance of the TreeView component when loading or navigating large Data Sources.

Seal Report 8.3.1

What's Changed

• Server Manager: Data Sources can reference other Data sources.
• Rework of Dynamics .cs files compilation.
• Fix CommonValue when the enum is for Numeric or DateTime types by @berchierm in #120
• Added a few options to the Excel export format by @berchierm in #121
• Corrected a text on a label for PDF options by @berchierm in #123
• SQLite Support by @ApioxFR in #125
• Adds QuestPDF.Barcode by @nickakin in #132
• Use RawDisplayValue in barcode by @nickakin in #133
• Startup Optimisation by @jb-modist in #135
• Load Script String replacement for NoSQL Sources by @jb-modist in #137
• Update QuestPDF.Barcodes and QuestPDF version by @nickakin in #139

Issues Addressed in Version 8.3.1

• 229 For SQLLite connections, columns of type DateTime are converted to String

Issues Addressed in Version 8.3.0

• 225 Fix CommonValue when the enum is for Numeric or DateTime types (#120).
• 226 Web Report Server: The default connection cannot be changed in the User Profile.
• 228 ToolTip and Axis formats of decimal/thousand separator are incorrect for ChartJS and NVD3 (dot and comma are inverted)

New Contributors

• @ApioxFR made their first contribution in #125
• @nickakin made their first contribution in #132

Full Changelog: v8.2.1...v8.3

Seal Report 8.2.1

New Features in Version 8.2.1

• Server Manager: New menu option to edit and compile Dynamics .cs files..

New Features in Version 8.2

Rework of the Joins Engine

• New model option Join hash code to select a given join.

Support for Core Microsoft Azure Libraries

• A new AzureHelper class has been added to simplify Azure authentication and storage management.

New Email Server Device Using Microsoft Graph API

• The Email Device now supports the Microsoft Graph API for email integration.
• A new Output processing script option allows customization of email output.

Template text editor

• New Differences Viewer to compare the current script with the reference script

Automatic Creation of Table Joins

• In addition to OleDb, automatic table joins are now supported for the following databases:
  • Microsoft SQL Server
  • MySQL
  • PostgreSQL
  • Oracle

Postgres-Specific Model Option

• The model option 'Maximum number of records' now has server-side implementation for PostgreSQL databases.

Migration Notes

• Reports using LEFT or RIGHT OUTER joins: Ensure to review and verify your reports as the result may differ due to the changes in join processing.

Issues Addressed in Version 8.2.0

• #218: The Chart ScottPlot did not display Y-axis labels by default.
• #219: The PDF Renderer failed when a data table contained multiple header lines.
• #220: Report Designer: Modifications are not saved when using Execute in functions editor
• #221: Dynamics assemblies (got from cs code in Assemblies\Dynamics) will not work for the Web Report Server and the Report Designer at the same time.
• #222: Renderer scripts and properties are not overridden when a reference view is used.
• #223: LEFT OUTER Joins resolution can be incorrect.

Seal Report 8.1.1

New Features 8.1:

• Seal Web Interface APIs:
  • The Seal Web Interface APIs now include the sessionId (string) parameter.
  • The sessionId is returned from SWILogin and can be passed as a parameter for other calls within the session.
  • A new testWebApplication is included in the project to test the API.
• Dynamic Compiled Assemblies:
  • A new Assemblies\Dynamics folder can contain .cs files to share source code amongst report scripts.
  • Each .cs file will be compiled into a .dll assembly file that will be loaded automatically.
  • Example of .cs file:

using Seal;
using Seal.Model;
namespace MyNamespace
{
   public class MyClass
   {
       public static int MyInt = 2;
       public static void MyMethod(Report report) 
       {
           string message = "this is a test";
           System.Diagnostics.Debugger.Break();  //To use debugger in Visual Studio
           report.LogMessage(message);  
       }
   }
}

• Global Razor Cache:
  • New Assemblies\RazorCache and Assemblies\RazorCache\Win folders to store assemblies generated from static templates (Views, Tables, Tasks).
  • This feature speeds up the first load and execution of reports.
  • The feature can be enabled or disabled using the 'Enable Razor Cache' option in 'Server Configuration'.
• PostgreSQL Support:
  • Added support for PostgreSQL.
  • Added a missing dependency for QuestPDF when rendering on Linux (GitHub Pull Request #112) (Thanks to jb-modist).
• Task Reference:
  • A task can now reference another task to share Script, SQL, and Parameters.
• New Task Template - "Load Model to Database":
  • Allows loading one or several model result tables into the current database.
• New Model Option - "Maximum Number of Records":
  • Limits the result table to a maximum number of records.
  • Server implementation available for MS SQL Server, Oracle, and MySQL.
• New HTML Table Template:
  • A new template to generate a model from an HTML table (Web Scraping).
  • Check the sample: 204-LINQ Sample - Web Scraping - Countries Tables.srex.
• Report Designer Enhancements:
  • Functions defined in 'Script' for Tasks or 'Load Script' for MetaTable can now be edited individually.

Migration:

• CommonScripts in Configuration and Report must be replaced by Dynamics .cs files.

Issues addressed in 8.1.1:

• 216 PDF Renderer does not work if the report has Chart ScottPlot view.
• 217 Seal Report Designer: The Report Viewer Window may remain hidden after a report execution.

Seal Report 8.0.1

New Features 8.0.1:

• PDF and Excel Renderer templates for 'Model Detail'

New Features 8.0:

• .Net 8
• New dual-licensing model at sealreport.com to ensure maintenance, quality, and support.
  Companies with an annual gross revenue exceeding $1 million USD are required to purchase a commercial license.
• New Chart Type: ScottPlot.
• New renderers with dedicated templates to generate report results in various formats:
  • Excel Renderer based on EPPlus library.
  • PDF Renderer based on QuestPDF library.
  • HTML to PDF Renderer using PuppeteerSharp library.
  • Basic XML, CSV, Text, Word renderers.
• Logos and favicon have changed.
• New report element property: Apply CSS to title to change the CSS of the title cell.
• New 'Report Source' property: Force load to ensure that the Source is kept when executing a report.
• Command Timeout for SQL Statements can be defined in Connections and in Report Models.

Issues addressed in 8.0.1:

• 214 Seal Report Designer: the 'Convert to Repository Data Source' is not working.
• 215 The Report execution mode: 'Execute report in the current Window' does not work.

Issues addressed in 8.0:

• 210 Chart Views: Limiting series X Values may not work if labels have commas.
• 212 Using the Report Designer, Dynamic Enum Display does not work.

Migration from a previous version:

• .Net 8.0 (Microsoft Windows Desktop Runtime 8).
• ASP.Net Core Runtime 8 (Hosting Bundle).
• ResultPage.ChartXLabels and ResultPage.ChartNavigations have moved from Type string to List<string>:
  • page.ChartXLabels becomes string.Join(",", page.ChartXLabels).
  • page.ChartNavigations becomes string.Join(",", page.ChartNavigations).
  • Check your previous custom scripts for charts.
• Thank you for checking that you comply with the new dual-licensing model.

Seal Report 7.2

New Features 7.2:

• New 'Card' view to display a model values in card.
• New 'Container Grid Flex' view to use the CSS Grid and Flex layout.
• Model Reference: A model can have a reference model to share elements and restrictions.
• New Model property: 'Use SELECT DISTINCT'
• New aggregate 'Count Distinct'
• 'Tab Control' and 'Model' views: New parameter 'Show number of records' to display the number of records in the page title.
• The 'Server Pagination Enabled' parameter can be configured by 'Model' view.
• JavaScript Libraries Update:
  Bootstrap 3 3.3.7, jQuery 3 3.7.0, DataTables 1.13.7, Buttons 2.4.2, FixedColumns 4.3.0, FixedHeader 3.4.0, Responsive 2.5.0, Scroller 2.3.0, Select 1.7.0

Issues addressed in 7.2:

208 Folders of File Server Devices (FTP, SCP, SFTP) are not correctly displayed.
209 Password of File Server Devices (FTP, SCP, SFTP) cannot be saved.

Seal Report 7.1.1

New Features 7.1:

• Element sort: Automatic Sort Order is not used prior a specified order.
• Server Manager: New option to store Data Source Connections in a dedicated XML file.
• Report Designer: New buttons to Execute or Render a report when editing a razor script.
• New Cell Script Sample to color cells (background, font, bar) in a report result.

Issues addressed in 7.1.1:

207 Models are reloaded even if the 'Render' button is used from the template editor.

Issues addressed in 7.1.0:

204 Reports located in Personal folders cannot be published in the main menu or as startup report.
205 Using LINQ models, 'Automatic Descendant' does not work on aggregate columns.
206 'Menu Script' for the Web Report Server: classes property of SWIMenuItem is not used.

Seal Report 7.0

New Features 7.0:

• .Net 7
• Report Designer: The Report Viewer uses Edge Chromium instead of Internet Explorer (IE).
• Server configuration: New 'Repository Translations Script' to load dynamically
  the translations from a database or another source.
• Server configuration: 'Alternate Temp Directory' to specify another Temp directory
  used for compilation and report generation.
• All repository translation instances may use wild char * to ease the matching:
  '*Shipping.Ship Postal Code' for Ends with 'Shipping.Ship Postal Code'
  '*Order Detail.srex' for Ends With 'Order Detail.srex'
  '\Samples*' for Starts With '\Samples'
  'Samples' for Contains '\Samples'
  '' for any value
• JavaScript Libraries Update:
  jQuery 3.6.0, Bootstrap 3.3.7, DataTables 1.13.4, Buttons 2.3.6, FixedColumns 4.2.2, FixedHeader 3.3.2, Responsive 2.4.1, Scroller 2.1.1

Migration
The release requires the installation of Microsoft Edge WebView2 from https://developer.microsoft.com/en-us/microsoft-edge/webview2/

Seal Report 6.9.3

New Features 6.9.3:

• Update MongoDBDriver to 2.19.9 (security).

New Features 6.9.1:

• Rework of the default CSS Classes cell-numeric, cell-datetime, etc.

New Features 6.9:

• Report View: New property 'Enabled' to disable parsing of a Report View.
• Table Column: New property 'Css Styles' for columns and report elements to control the Css Styles applied to the result cell.
• Report Task: New property 'SQL Separator' to execute several SQL in one task.
• Server configuration contains new options for managing encryption keys storage and a collection to store
  application keys and passwords.
  The keys may be stored in a local RSA Container of the computer (Windows only).
• New task template 'Load XML to Database'
• Web Report Server: new flag "HideLoginPassword" in appsettings.json to hide Login/Password fields of the login dialog window.

Issues addressed in 6.9.3:

202 Report Execution: Messages logged in the Init Scripts are not shown.

Issues addressed in 6.9.2:

201 Fix on Date Format for Oracle connection.

Issues addressed in 6.9.1:

199 Report: The Init Script is executed twice when a report is executed.
200 Report Task: Setting a retry causes the task to be re-executed several times.

Issues addressed in 6.9:

• 198 Email Device: The attachment name is empty for report result in Excel or PDF format.