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.

Seal Report 6.8

New Features 6.8:

• New Report Task Templates with custom scripts and parameters.
  Several templates located in the 'Sources\TaskTemplates' repository folder are available to perform basic operations (Load tables in database, Execute reports) in multi-thread tasks (Loop, Parallel)
• New Task properties to handle retries in case of error.
• Sub-Report: the popup text shows also the current cell value.
• Server Manager configuration: New 'Web CSS Files' and 'Web JavaScript Files' properties to
  include CSS or JS files in the Web Report Server application.
• Server Manager configuration: New 'Help Link' property to add a help link in the Web Report Server.

Issues addressed in 6.8:

• 195 Report Designer: Restrictions are lost when using 'Reset to Default value' for the Operator.
• 197 Report Designer: After a reload, the model elements are not synchronized with the Tree View.

Seal Report 6.7.2

New Features 6.7:

• Two-Factor Authentication: 2 new scripts are available in the Security Provider to generate and send the
  security code by email (using SMTP or SendGrid) or by SMS (using Twilio client) and then to check it.
• Implementation of Gauge component: Check Sample Report "05-Gauges"
• Startup Reports can be used to control the Web Report Server interface after a user login (e.g. having a dedicated Welcome screen),
  Check Sample Reports "40-Startup Report" and "41-Startup Folder"
• The profile parameter 'Execution mode' is also used for Drill and Sub-Report navigation (New window by default or not).
• The "information_button" view parameter has moved to "information_mode" (enabled, enabledshown, disabled).

Issues addressed in 6.7.2:

• 193 Report Designer: Ctrl+C or Delete does not work when editing a tree node label.
• 194 Report Designer: Model Tree View is not refreshed when using SQL Models.
• Security update for System.Data.SqlClient

Issues addressed in 6.7:

• 187 Wild char does not work on translations of context 'FolderName'
• 188 When editing a model with the Report Designer, elements are not translated in the treeview and panels.
• 189 SendGrid Email device cannot be used for email notification.
• 190 Error may occur when browsing folders in the Web Report Server:
  The process cannot access the file '_Profile.xml' because it is being used by another process.
• 191 Unexpected exception got when using SMTP Device with HTML attached: 'The specified content type is invalid'
• 192 SQL Model: modifying the SQL does not change the elements proposed in the treeView without a refresh.

Seal Report 6.6.1

New Features 6.6.1:

• Local Temporary directories is always preferred than C:\Windows\Temp.
• Small fixes on the distribution.
• Update of Nuget packages.
• New configuration "MaxWorkingSet" in appsettings.json to limit process memory.

New Features 6.6:

• .Net 6
• Security Logins used by the 'Basic Authentication' Security Provider.
• Email Device: In addition to SMTP, support of SendGrid Client.
• Report Designer: New option 'Empty if repeated' to empty duplicate values in the table.
• New property 'Css Classes' for columns and report elements to control the Css Classes applied to the result cell.
• New restriction operators: 'Contains any', 'Contains all', 'Does not contain any', 'Does not contain all'.
• Server Manager Tools: New options to export/import objects from an Excel file to ease mass updates.
• Translations files can also be provided in Excel format (.xlsx instead of .csv).
• For translations having Context: ReportDisplayName, ReportViewName, ReportGeneral, ReportOutputName, FileName,
  wild char * can be used to ease the matching of the Instance field:
  '*Order Detail.srex' for Ends With '*Order Detail.srex'
  '\Samples\*' for Starts With '\Samples\'
  '*Samples*' for Contains 'Samples'
  '*' for any value
• Seal Report Scheduler:
  New Server Configuration options: Report Scheduler Mode, Run in Outer Process.

Migration Issues

The \Web distribution folder has been renamed to \Core and contains now the SealTaskScheduler.exe application.
Check the new Server Configuration options for the Scheduler.

For existing schedules using the Windows Task Scheduler:
Run the Server Manager in Administrator mode, then use the menu 'Tools->Synchronize report schedules...'

Check the schedules:
Run the Windows Task Scheduler, and check the tasks defined for Seal Report:
Edit properties, Tab Action, check that 'Program/script' and 'Start in' path have the \core sub-folder.
(e.g. 'C:\Program Files\Seal Report\SealTaskScheduler.exe' to 'C:\Program Files\Seal Report\core\SealTaskScheduler.exe')

Edit 'core\appsettings.json' and update the RepositoryPath if necessary.

Issues Addressed in 6.6.1:

• 186 SendGrid Email device may not work.

Issues Addressed in 6.6:

• 184 TaskDatabaseHelper methods do not work for Oracle.ManagedDataAccess.Client connections.

Seal Report 6.5.3

New Features 6.5:

• .Net 5: New architecture, New components.
• Support of Mongo DB as LINQ Table: Dynamic generation of stages.
• New MySQL connection type: MySQL.Data (#55)
• New MS SQLServer connection type: Microsoft.Data.SqlClient.SqlConnection
• New parameter 'Color mappings' in the chart templates to specify the colors for each value.
• New 'Execution Mode' property in Security Groups and User Profile to execute reports in a new Window by default.
• User Profile: Default data source connections can be defined to allow execution on different connections.
• XML Serialization of entities (Reports, Sources, etc.) keeps a readable format.
• Server configuration: New property 'Web Session Init Script' to execute a script when a Web Session is started.
• Server configuration: New property 'Use host name to define the Personal Folder name' to allow
  multiple Web sites on the same installation.
• Server Manager Tools: New menu to import object from another Data Source file.
• Report Designer and Server Manager: Support of shortcut keys in the Tree view (ctrl+up, ctrl+down, del, etc.),
  Drag & Drop is allowed for table columns.

New Features 6.5.1:

• Support of native Oracle connection: Oracle.ManagedDataAccess.Client
• New 'Connection Script' to initialize and open the connection.

New Features 6.5.3:

• Fix MySql.Data 8.0.25 (#65)
• OpenId Authentication (#63 and #64)

Migration Check List:

• Personal Folders have now simplified names with no hash code suffix.
  Remove the _ suffix of all Personal Folders located in Repository folder SpecialFolders\Personal (e.g. 'john_12344' becomes 'john')

Issues Addressed in 6.5.3:

• 183 Execution of an output having HTML format on an EMail Device may have an incorrect display result.

Issues Addressed in 6.5.2:

• 182 The SealSchedulerService does not start properly.

Issues Addressed in 6.5.1:

• 181 Invalid distribution of SealTaskScheduler in the setup.

Issues Addressed in 6.5:

• 170: ChartJS: Secondary axis does not work for horizontal bars.
• 171: Sorting tables with Sub-totals may cause an unexpected exception.
• 172: Web Report Server: Folder view has blank padding after executing a report with a Print HTML View.
• 173: The View property 'Use model name' is always reset to false when the report is loaded.
• 174: Editing custom restrictions for a report output may raise an exception.
• 177 LINQ Joins may not work if more than 2 tables are involved.
• 178 Reports are displayed in the Web Menu even if the 'Show in the Web Menu' is set to False.
• 179 Columns generation for SQL Model does not use the Connection specified in the model.

Seal Report 6.1

NEW FEATURES 6.1:

• Web Report Server: New main multi-level menu to execute the reports.
  A dedicated 'Menu Script' can be used to customize the menu.
  The menu includes the recent reports executed.
• Web Report Server: Reports can be executed either within the application or on a new window.
• Dashboards have moved to reports.
  A new Widget View can be used to keep the previous look and functionalities.
• New Report Model View parameter 'Navigation Drill View' to execute the drill navigation using another root view.
• User profile: Startup options can be configured to execute a report.
• Enumerated list can have different values per connection.

Migration Check List:

• Dashboards do not exist anymore and have moved to reports.
  If you want to convert your Dashboards to Reports, please use the asset 'Convert Dashboards to 6.1.zip'
• Web Report Server: 'PreLoad' option does not exist anymore.
• Restrictions View: 'New window: View to execute' has been moved to a parameter
• Rework of 'Folders Script' and 'Folder Detail Script'
• The 'Model Container' view template has been replaced by 'Container'

Issues Addressed in 6.1:

• 157: 'Smart Copy' on report models may not work.
• 165: Pre Load Script are not executed in Sub-Models of a LINQ model.
• 166: Using a 'Smart Copy' from a restriction may corrupt the restriction text.
• 167: Enumerated lists dynamically loaded and refreshed before execution do not show values.
• 168: Web Report Server: The Reports Search does not used translated names.
• 169: View parameters 'Drill enabled' and 'Sub-Reports enabled' do not work in Model Views.