Softpedia >Windows >Internet >Servers >Database Utils >Seal Report >  Changelog

Seal Report Changelog

What's new in Seal Report 8.0.1

Apr 2, 2024
  • 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.
  • New Features 8.0.1:
  • PDF and Excel Renderer templates for 'Model Detail'

New in Seal Report 8.0 (Mar 11, 2024)

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

New in Seal Report 7.2 (Dec 12, 2023)

  • 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:
  • Folders of File Server Devices (FTP, SCP, SFTP) are not correctly displayed.
  • Password of File Server Devices (FTP, SCP, SFTP) cannot be saved.

New in Seal Report 7.1.1 (Nov 4, 2023)

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

New in Seal Report 7.1 (Oct 26, 2023)

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

New in Seal Report 7.0 (Jul 19, 2023)

  • 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

New in Seal Report 6.9.3 (Mar 16, 2023)

  • Update MongoDBDriver to 2.19.9 (security).

New in Seal Report 6.9.2 (Mar 14, 2023)

  • Fix on Date Format for Oracle connection.

New in Seal Report 6.9 (Mar 1, 2023)

  • New Features:
  • 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:
  • Email Device: The attachment name is empty for report result in Excel or PDF format.

New in Seal Report 6.8 (Jan 12, 2023)

  • New Features 6.8:
  • New Report Task Templates with custom scripts and parameters.
  • Several templates located in the 'SourcesTaskTemplates' 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.
  • 97 Report Designer: After a reload, the model elements are not synchronized with the Tree View.

New in Seal Report 6.7.2 (Nov 9, 2022)

  • 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

New in Seal Report 6.7.1 (Nov 8, 2022)

  • Fixed:
  • Report Designer: Ctrl+C or Delete does not work when editing a tree node label.
  • Report Designer: Model Tree View is not refreshed when using SQL Models.

New in Seal Report 6.7 (Oct 27, 2022)

  • New Features:
  • 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:
  • Wild char does not work on translations of context 'FolderName'
  • When editing a model with the Report Designer, elements are not translated in the treeview and panels.
  • SendGrid Email device cannot be used for email notification.
  • 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.
  • Unexpected exception got when using SMTP Device with HTML attached: 'The specified content type is invalid'
  • SQL Model: modifying the SQL does not change the elements proposed in the treeView without a refresh.

New in Seal Report 6.6.1 (Jun 24, 2022)

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

New in Seal Report 6.6 (Jun 3, 2022)

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

New in Seal Report 6.5.3 (Mar 7, 2022)

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

New in Seal Report 6.5.2 (Feb 22, 2022)

  • 182 The SealSchedulerService does not start properly.

New in Seal Report 6.5.1 (Feb 19, 2022)

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

New in Seal Report 6.5 (Jan 25, 2022)

  • New Features:
  • .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.
  • 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 SpecialFoldersPersonal (e.g. 'john_12344' becomes 'john')
  • Issues Addressed:
  • ChartJS: Secondary axis does not work for horizontal bars.
  • Sorting tables with Sub-totals may cause an unexpected exception.
  • Web Report Server: Folder view has blank padding after executing a report with a Print HTML View.
  • The View property 'Use model name' is always reset to false when the report is loaded.
  • Editing custom restrictions for a report output may raise an exception.
  • LINQ Joins may not work if more than 2 tables are involved.
  • Reports are displayed in the Web Menu even if the 'Show in the Web Menu' is set to False.
  • Columns generation for SQL Model does not use the Connection specified in the model.

New in Seal Report 6.1 (Feb 19, 2021)

  • New features:
  • 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:
  • 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.

New in Seal Report 6.0 (Dec 14, 2020)

  • NEW FEATURES 6.0:
  • LINQ Data Sources and LINQ Models to support join and query between any Data Sources (SQL, Excel, XML, OLAP Cube, HTTP JSon, etc.)
  • Full rework of the execution engine.
  • New Restrictions View Template to allow input restriction in any part of the report and in dashboard widgets.
  • Chart JS: Integration of the labels plugin (https://chartjs-plugin-datalabels.netlify.app).
  • .Net Framework 4.7.2
  • Thr Setup file is only for the 64 bit distribution.
  • New properties for a report restriction:
  • 'Operator style': visible, visible with Nulls, visible not modifiable, not visible.
  • 'First selection' for enumerated values: 'Select All', Select First', 'Select Last'
  • 'Enum Layout': Select with filter, Select without filter, Radio or checkbox
  • 'Trigger on change'
  • New property for a report element:
  • 'Show all enum values' to force all enumerated list values in the result tables.
  • 'Contains HTML' to indicate that the values contain HTML tags.
  • Enumerated lists can be loaded or updated from a razor script.
  • New Security Scripts for each user group: 'Folders Script', 'Folder Detail Script' and 'Dashboards Script' to modify the default Web security.
  • Server Configuration: New property 'Web Cultures' to select the list of cultures proposed in the Web Report Server.
  • By default, the translation cultures installed in the repository are proposed.
  • 'Custom Enumerated List' for element and restriction: New option to Clear the current enumerated list.
  • Personal or Default Dashboard View can be defined in the user security group .
  • Dashboard export with the following format: Html Print, Pdf, Excel
  • Security Robustness against Stored Cross Site Scripting XSS, Directory Traversal and Server Side Request Forgery SSRF attacks.
  • NetCore Web Report Server: SQL Server Session (#46)
  • NetCore Web Report Server: Adding configuration to be able to modify the Path Base when you use a Reverse Proxy (#47)
  • Migration Check List:
  • Seal Web Interface (SWI): Parameter use_default_restrictions in SWExecuteReportToResult() is not used anymore.
  • If the operator of a restriction is not specified, the default values are kept.
  • Restriction Flag 'Can change operator' does not exist anymore, use 'Operator style' instead.
  • Dynamic Enumerated List: Review all enumerated list with Filter Characters is default to 0 instead of 2.
  • Seal Report Licenses files (*.slc) must be moved to the Settings folder of the Repository.
  • Seal Report Converter Assemblies (*.dll) are now located in the Assemblies and Assemblies/NETCore folders of the Repository.
  • Set element property 'Contains HTML' to True to element having values containing HTML tags.
  • Issues Addressed in 6.0:
  • 158: Dashboard: Refresh on dashboard widget may not force a new execution.
  • 159: Dashboard: For a DataTables, the plus button in responsive mode does not work in widget.
  • 160: From the Web Report Server, drill navigation occurs using the default report execution view instead of the current execution view.
  • 161: Dashboard: The default User Dashboards View is saved for all users.
  • 162: Schedule by email may fail when several ouputs of the same report are scheduled at the same time.
  • 163: Automatic sort orders may be incorrect if more than 10 elements are displayed in a report.
  • 164: Report output on folder cannot be cancelled: The result file is always generated.

New in Seal Report 6.0 RC (Dec 3, 2020)

  • NEW FEATURES 6.0:
  • LINQ Data Sources and LINQ Models to support join and query between any Data Sources (SQL, Excel, XML, Olap Cube, HTTP JSon, etc.)
  • Full rework of the execution engine.
  • New Restrictions View Template to allow input restriction in any part of the report and in dashboard widgets.
  • Chart JS: Integration of the labels plugin (https://chartjs-plugin-datalabels.netlify.app).
  • .Net Framework 4.7.2
  • Only one Setup file for 64 bit version.
  • New properties for a report restriction:
  • 'Operator style': visible, visible with Nulls, visible not modifiable, not visible.
  • 'First selection' for enumerated values: 'Select All', Select First', 'Select Last'
  • 'Enum Layout': Select with filter, Select without filter, Radio or checkbox
  • 'Trigger on change'
  • New property for a report element:
  • 'Show all enum values' to force all enumerated list values in the result tables.
  • 'Contains HTML' to indicate that the values contain HTML tags.
  • Enumerated lists can be loaded or updated from a razor script.
  • New Security Scripts for each user group: 'Folders Script', 'Folder Detail Script' and 'Dashboards Script' to modify the default Web security.
  • Server Configuration: New property 'Web Cultures' to select the list of cultures proposed in the Web Report Server.
  • By default, the translation cultures installed in the repository are proposed.
  • 'Custom Enumerated List' for element and restriction: New option to Clear the current enumerated list.
  • Personal or Default Dashboard View can be defined in the user security group .
  • Dashboard export with the following format: Html Print, Pdf, Excel
  • Security Robustness against Stored Cross Site Scripting XSS, Directory Traversal and Server Side Request Forgery SSRF attacks.
  • NetCore Web Report Server: SQL Server Session (#46)
  • NetCore Web Report Server: Adding configuration to be able to modify the Path Base when you use a Reverse Proxy (#47)
  • Migration Check List:
  • Seal Web Interface (SWI): Parameter use_default_restrictions in SWExecuteReportToResult() is not used anymore.
  • If the operator of a restriction is not specified, the default values are kept.
  • Restriction Flag 'Can change operator' does not exist anymore, use 'Operator style' instead.
  • Dynamic Enumerated List: Review all enumerated list with Filter Characters is default to 0 instead of 2.
  • Seal Report Licenses files (*.slc) must be moved to the Settings folder of the Repository.
  • Seal Report Converter Assemblies (*.dll) are now locarted in the Assemblies and Assemblies/NETCore folders of the Repository.
  • Set element property 'Contains HTML' to True to element having values containing HTML tags.
  • Issues Addressed in 6.0:
  • 158: Dahboard: Refresh on dashboard widget may not force a new execution.
  • 159: Dahboard: For a Datatable, the plus button in responsive mode does not work in widget.
  • 160: From the Web Report Server, drill navigation occurs using the default report execution view instead of the current execution view.
  • 161: Dashboard: The default User Dashboards View is saved for all users.
  • 162: Schedule by email may fail when several ouputs of the same report are scheduled at the same time.
  • 163: Automatic sort orders may be incorrect if more than 10 elements are displayed in a report.
  • 164: Report output on folder cannot be cancelled: The result file is always generated.

New in Seal Report 5.5 RC 2 (Apr 24, 2020)

  • .NETCore 3.1 Distribution of the Web Report Server.
  • New Web Report Server Scheduler component to schedule reports from the Web Report Server instead of the Windows Task Scheduler.
  • When active (Property 'Use Web Report Server Scheduler' set to true in the Seal Server Configuration), schedules are saved in
  • a dedicated SpecialFoldersSchedules repository folder.
  • The Web Report Server Scheduler can be used for .NETCore or Azure deployment.
  • New File Server output device to generate reports on server using FTP, FTPS, SFTP, SCP protocols.
  • The zip options are available for all output devices.
  • The Repository Logs directory contains 3 types of log files for executions, events and schedules.
  • Audit has been enhanced to log files (including reports), folders and dashboards management (create, save, move, copy, delete, etc.)
  • The default Audit database table columns and script have been updated.
  • New System Dashboard and Reports to check the last errors, schedules and sessions of the Web Report Server.
  • Check 'System' dashboard.
  • MetaConnection: New properties 'Connection Type', 'ODBC Connection String' and 'MS SQLServer Connection String'
  • to choose the database connection used (OlebConnection, OdbcConnection or SqlConnection).
  • Common Scripts (Configuration and Report) are included in the PDF or Excel Converter scripts.
  • Tasks with step 'Models generated, before rendering' are also executed when viewing a report result.
  • New property 'Report Navigation Script' to be used with Report.GetReportNavigationFileDownloadLink() and Report.GetReportNavigationScriptLink()
  • to get custom file or content from the server.
  • Check full sample '17-Custom buttons and report navigation'
  • New ResultCell methods: AddNavigationNewReportExecution(), AddNavigationReportExecution() to execute a report from a table cell.
  • Check full sample '15-Custom buttons and report navigation'
  • PDF Converter: Update to version 15.0, native support of the Table of Contents.
  • Data report element: New advanced property 'Set empty cell to zero' to init empty table cells to 0.
  • KPI template: Button colors and icons options can be also be based on the measure value (not only trend).
  • Dashboard Widget: A report and view can be selected to be executed from the Widget title.
  • Charts: Minimum and maximum values can be specified for chart axis.
  • Report model: new properties 'Execution Set' and 'Share Result Table' to control the load of the models during execution.
  • Tasks can contain script to control model load (result table and result pages).
  • Check sample text in Task: 'Load a report model Result Table and/or build its Result Pages'
  • Migration Check List:
  • PDF Converter: In custom scripts, the Class Winnovative.PdfConverter has been moved to Winnovative.HtmlToPdfConverter.
  • Report tasks: the TaskDatabaseHelper methods ExecuteNonQuery(), ExecuteScalar() and LoadDataTable() have a new parameter for the ConnectionType.
  • Report Navigation: rights to execute the destination report are checked if the report is not located in the SubReports repository folder.
  • OutputDevice class: 'EmailZipAttachments' has been renamed to 'ZipResult' and 'EmailZipPassword' to 'ZipPassword'
  • Audit script: The default Audit database table columns and script have been updated.
  • Issues Addressed in 5.5:
  • 152: Sub-totals are not displayed when first line of data contains null (#37)
  • 153: Widget overflows are incorrect in the dashboard.
  • 154: CTE Expression may not work in table definition.

New in Seal Report 5.5 Beta 1 (Mar 17, 2020)

  • New Features:
  • .NETCore 3.1 Distribution of the Web Report Server. A zip file contains all the Web Report Server Distribution and the Repository files (appsettings.json is the configuration file).
  • Note that the following features are not supported: Report Schedules, Zip for email output.
  • MetaConnection: New properties 'Connection Type', 'ODBC Connection String' and 'MS SQLServer Connection String'
  • to choose the database connection used (OlebConnection, OdbcConnection or SqlConnection).
  • Common Scripts (Configuration and Report) are included in the PDF or Excel Converter scripts.
  • Tasks with step 'Models generated, before rendering' are also executed when viewing a report result.
  • New property 'Report Navigation Script' to be used with Report.GetReportNavigationFileDownloadLink() and Report.GetReportNavigationScriptLink()to get custom file or content from the server.
  • Check full sample '17-Custom buttons and report navigation'
  • Migration Check List:
  • PDF Converter: In custom scripts, the Class Winnovative.PdfConverter has been moved to Winnovative.HtmlToPdfConverter.
  • Report tasks: the TaskDatabaseHelper methods ExecuteNonQuery(), ExecuteScalar() and LoadDataTable() have a new parameter for the ConnectionType.

New in Seal Report 5.1.1 (Jan 24, 2020)

  • NEW FEATURES 5.1.1:
  • Support of the server pagination for Data Tables in the Dashboard Widgets.
  • Migration Check List:
  • Task Scripts (for report and server configuration) do not exist anymore, copy the previous code into Common Scripts.
  • Include the Server Common Scripts into your scripts using the @include("<script name>") directive.
  • Seal Web Interface consistency: some properties have been renamed in lower case (dashboardfolders, managedashboards, usertag, isreport, displayname).
  • Seal Converter: SealPdfConverter and SealExcelConcerter namespaces have been renamed to Seal.Converter
  • Check your existing scripts and replace 'SealPdfConverter' by 'Seal.Converter' and 'SealExcelConverter' by 'Seal.Converter'
  • Drill behavior: By default 'Navigation: Drill all elements of the hierarchy' is set to true.
  • Dashboard Widget: Set the execution view when required.
  • Issues addressed in 5.1:
  • 122: Chart JS is incorrect when the axis is a date time with a general format.
  • 132: Viewing the history in the Windows Task Scheduler does not work.
  • 133: Web Report Server: Copy/Paste may not work on files or reports having a dot in their name.
  • 134: Web Report Server: Copy is not enabled if the file is not on the first page of the files table.
  • 136: In charts, date time axis with long format are not translated.
  • 137: Navigation menu is not shown for data tables with no Server Pagination.
  • 138: Chart: If the sort is not specified for the axis, the chart is incorrect in the Web Report Server.
  • 139: Chart: If the sort is not specified for a serie element, the serie order may be incorrect.
  • 140: Enum dependencies do not work if the report has several models.
  • 141: View container templates may have incorrect margins (tag div class="container" was missing).
  • 142: Seal Web Interface: Executing report with custom restriction values may cause an unexpected exception.
  • 143: Data Table View: The option 'Invert data table' does not work.
  • Issues addressed in 5.1.1:
  • 145: After a drill navigation, restrictions of the root report are reset to the first re-execution values.
  • 146: Windows basic or integrated authentication: the groups evaluated over the AD are not searched recursively (groups contained in group).
  • 147: Data Tables: if the option 'Columns to hide' is used, the sort may not work.
  • 148: The Dashboard Manager does not allow to add Widgets.
  • 149: Data Tables Template: Parameter 'Table CSS' Style is not editable.
  • 150: Web Report Designer cannot create new SQL reports.
  • 151: Common restriction or value SQL results have additional parenthesis and may not work (e.g. in stored procedures).
  • Issues addressed in 5.1.2:
  • 152: Data Tables: The responsive button does not show the line detail.

New in Seal Report 5.1 (Dec 20, 2019)

  • New Features:
  • New Web Site dedicated for the Documentation (published at sealreport.org).
  • The project is part of the Seal solution. Feel free to contribute to the documentation.
  • Dashboards and Widgets can be generated in a dedicated user view.
  • A widget is a report's view published with dedicated properties (name, size, color, etc.)
  • A dashboard is a list of items pointing to a widget.
  • New KPI View template to display simple KPIs (Key Performances Indicator) based on the result data table.
  • Check sample '12-KPI.srex'.
  • SQL Model: New type of report's model to fully edit the Select SQL Statement.
  • SealMasterTable is now deprecated for SQL Data Sources.
  • Common Restrictions and Values can be defined in SQL with the following keywords '{CommonRestriction_MyName}' or '{CommonValue_MyName}' where MyName is the Common Restriction name.
  • Once defined, they can be edited and configured using the 'Common Restrictions' property of a Report Model.
  • The following SQL definitions can contain Common Restrictions: Table SQL, Table Additional Where Clause, Table PreSQL, Table PostSQL, Model SQL, Model PreSQL, Model PostSQL.
  • New property 'Report Input Values' in the root Views tree node. Values can be defined and used in tasks scripts or any scripts executed to generate the report.
  • Like normal restrictions, input values can be prompted to the user when the report is executed.
  • The restriction Property "Use as parameter" does not exist anymore (to be replaced by a Report Input Value).
  • Dynamic display for enumerated lists:
  • 'Select SQL for prompted restriction' is a dedicated SQL Select to get the values when a restriction is prompted.
  • The SQL can contain the '{EnumFilter}' and/or '{EnumValues_MyName}' keywords where MyName is the name of another prompted enumerated list.
  • In addition 'Filter characters to type' allows to specify the number of character to type to trigger the list (case of use of {EnumFilter}) and 'Information message' to set a message for the end user like 'Type 2 characters' or 'Select a country first'.
  • New DateTime keywords: ThisHour, ThisMinute and ThisSemester
  • Operations +/- are allowed with the following units: Y(Year), S(Semester), Q(Quarter), M(Month), D(Day), h(hour), m(minute), s(second)
  • Translations can be edited by file/language in the repository Settings folder.
  • Feel free to contribute by adding new translation files for your languages.
  • Support of Common Table Expressions (CTE) in the SQL used to defined tables or SQL Models.
  • Compilation errors are highlighted in the Template and SQL Editors.
  • Rework of the Joins evaluation and configuration in the model definition:
  • New model property 'View joins evaluated' to display the joins found and chosen for the SQL generated.
  • The Join engine has enhanced to evaluate indirect joins even if direct joins are found.
  • New property 'Joins to use' to specify the Joins to be used.
  • Server Manager: Default configuration values for the PDF and Excel Converter can be modified in the Server Configuration.
  • Update to Bootstrap 3.4.1, ChartJS library version 2.8.0, Plotly version 1.48.1, JS Tree 3.3.8
  • Issues Addressed :
  • 120: In a chart, creation order of the Series can be random.
  • 121: Server Manager: "Add Sub-Reports" configures only restrictions for elements of the current table.
  • 123: Check for Razor Syntax does not work when editing partial template views.
  • 124: During report execution, the hour displayed in the message may be incorrect.
  • 125: The 'Back to top' icon may hide total cells if the pagination is not used in the table.
  • 126: For a report restriction, the Date Time value 4 may be ignored.
  • 127: Helper to create drill children does not work for SQLServer date time.
  • 128: The Invert Data Table option in 'Data Table' view does not work.
  • 130: Sort may not work when column and row elements are defined in a model.
  • 131: A LEFT OUTER Join is not converted to RIGHT OUTER Join when the join is bidirectional.

New in Seal Report 5.0 (Jun 26, 2019)

  • NEW FEATURES 5.0:
  • New Web Site dedicated for the Documentation (published at sealreport.org).
  • The project is part of the Seal solution. Feel free to contribute to the documentation.
  • Dashboards and Widgets can be generated in a dedicated user view.
  • A widget is a report's view published with dedicated properties (name, size, color, etc.)
  • A dashboard is a list of items pointing to a widget.
  • New KPI View template to display simple KPIs (Key Performances Indicator) based on the result data table.
  • Check sample '12-KPI.srex'.
  • SQL Model: New type of report's model to fully edit the Select SQL Statement.
  • SealMasterTable is now deprecated for SQL Data Sources.
  • Common Restrictions and Values can be defined in SQL with the following keywords '{CommonRestriction_MyName}' or '{CommonValue_MyName}' where MyName is the Common Restriction name.
  • Once defined, they can be edited and configured using the 'Common Restrictions' property of a Report Model.
  • The following SQL definitions can contain Common Restrictions: Table SQL, Table Additional Where Clause, Table PreSQL, Table PostSQL, Model SQL, Model PreSQL, Model PostSQL.
  • New property 'Report Input Values' in the root Views tree node. Values can be defined and used in tasks scripts or any scripts executed to generate the report.
  • Like normal restrictions, input values can be prompted to the user when the report is executed.
  • The restriction Property "Use as parameter" does not exist anymore (to be replaced by a Report Input Value).
  • Dynamic display for enumerated lists:
  • 'Select SQL for prompted restriction' is a dedicated SQL Select to get the values when a restriction is prompted.
  • The SQL can contain the '{EnumFilter}' and/or '{EnumValues_MyName}' keywords where MyName is the name of another prompted enumerated list.
  • In addition 'Filter characters to type' allows to specify the number of character to type to trigger the list (case of use of {EnumFilter}) and 'Information message' to set a message for the end user like 'Type 2 characters' or 'Select a country first'.
  • New DateTime keywords: ThisHour, ThisMinute and ThisSemester
  • Operations +/- are allowed with the following units: Y(Year), S(Semester), Q(Quarter), M(Month), D(Day), h(hour), m(minute), s(second)
  • Translations can be edited by file/language in the repository Settings folder.
  • Feel free to contribute by adding new translation files for your languages.
  • Support of Common Table Expressions (CTE) in the SQL used to defined tables or SQL Models.
  • Compilation errors are highlighted in the Template and SQL Editors.
  • Rework of the Joins evaluation and configuration in the model definition:
  • New model property 'View joins evaluated' to display the joins found and chosen for the SQL generated.
  • The Join engine has enhanced to evaluate indirect joins even if direct joins are found.
  • New property 'Joins to use' to specify the Joins to be used.
  • Server Manager: Default configuration values for the PDF and Excel Converter can be modified in the Server Configuration.
  • Update to Bootstrap 3.4.1, ChartJS library version 2.8.0, Plotly version 1.48.1, JS Tree 3.3.8
  • Issues Addressed in 5.0:
  • 120: In a chart, creation order of the Series can be random.
  • 121: Server Manager: "Add Sub-Reports" configures only restrictions for elements of the current table.
  • 123: Check for Razor Syntax does not work when editing partial template views.
  • 124: During report execution, the hour displayed in the message may be incorrect.
  • 125: The 'Back to top' icon may hide total cells if the pagination is not used in the table.
  • 126: For a report restriction, the Date Time value 4 may be ignored.
  • 127: Helper to create drill children does not work for SQLServer date time.
  • 128: The Invert Data Table option in 'Data Table' view does not work.
  • 130: Sort may not work when column and row elements are defined in a model.
  • 131: A LEFT OUTER Join is not converted to RIGHT OUTER Join when the join is bidirectional.

New in Seal Report 4.1 (Nov 12, 2018)

  • NEW FEATURES 4.1:
  • In addition to 32bit, 64bit assemblies and setup are available.
  • Note that the samples are based on MS Access and will not work with the 64bit version.
  • Common Scripts can be defined in the Server Configuration and Report Tasks.
  • These scripts allow to define common razor functions in all executed scripts.
  • New library and enhancements for the Script/SQL editors.
  • New view template parameter: 'Data tables: Sort configuration' to sort a column after the load.
  • The column/element property "Contains HTML" is not supported anymore.
  • New menu for execution messages: 'Autoscroll' (with a template parameter) and 'Export Messages'
  • A new sample report '06-Country Maps' is available to show the use of the plotly maps.
  • Seal Report Converter: The Excel Generation uses EPPlus OpenXML Library to generate Excel Workbook.
  • Note that existing conversion scripts have to be checked.
  • Issues Addressed in 4.1:
  • 112: Select Object Dialog: The number of selected objects is incorrect.
  • 113: CSV Output for several models: New line characters are missing.
  • 114: For MSSQL Server, columns of type UUID are imported as Numeric by the wizard.
  • 115: After displaying a result, using '<>' in the data table filter does not work.
  • 116: The "Model Detail" template does not compile.
  • 117: Chart NVD3 Title is not positioned correctly.
  • 118: Drill down on an empty value does not work.
  • 119: Circular joins are not handle correctly.

New in Seal Report 4.0.1.0 (May 18, 2018)

  • NEW FEATURES 4.0.1:
  • In report model: New option to hide the first header line of the data table.

New in Seal Report 4.0.0.0 (May 11, 2018)

  • NEW FEATURES 4.0:
  • Use of .Net Framework v4.5.
  • Full rework of rendering and the view templates:
  • Reports results generated are now fully responsive (implementation of bootstrap 3 layout and components).
  • Partial view templates. Container and Model Container templates to render bootstrap grid layout.
  • New chart librairies: ChartJS and Plotly.
  • New option to show a sub-total line in the main data table when the value of a row element changes.
  • CSV Format is a native format for report results. CSV Templates are not available anymore.
  • Drill and sub-reports menus are available when clicking on chart .
  • Supported for all ChartJS, Plotly Charts and for the NVD3 Pie Chart.
  • Support of unicode characters for the translations, the Translations files located in the Settings Repository directory must be in UTF8 Encoding.
  • Optimization of the engine to build the SQL when many Joins are defined.
  • New restrictions options: 'Can change' operator, 'Rows for Value 1' input.
  • Issues Addressed in 4.0:
  • 102: MySQL columns with white spaces are incorrectly created by the Wizard ([] instead of ``)
  • 105: Web Report Server: After modification, the user's profile is not correctly displayed
  • 106: Check Razor Script does not work for global tasks script referencing a server size Tasks Script
  • 107: Web Report Designer: The DateTime Picker is incorrect for US Dates
  • 108: Joins may produce incorrect SQL.
  • 109: Sort Series by point value is incorrect when the chart has several Series.
  • Check list when migrating from previous 3.x versions:
  • Custom templates: May refer to unsupported templates.
  • Themes are not supported anymore.
  • Charts: Implementation modified.
  • Custom parameters for output: Implementation modified.
  • Microsoft Charts are not supported anymore.
  • Custom Cell CSS for Elements is not supported anymore: use Cell Script instead.
  • Translations: Convert previous translation files to UTF8 encoding.

New in Seal Report 4.0.0.0 Beta (Apr 18, 2018)

  • NEW FEATURES 4.0:
  • Use of .Net Framework v4.5.
  • Full rework of rendering and the view templates:
  • Reports results generated are now fully responsive (implementation of bootstrap 3 layout and components).
  • Partial view templates. Container and Model Container templates to render bootstrap grid layout.
  • New chart librairies: ChartJS and Plotly.
  • New option to show a sub-total line in the main data table when the value of a row element changes.
  • CSV Format is a native format for report results. CSV Templates are not available anymore.
  • Drill and sub-reports menus are available when clicking on chart .
  • Supported for all ChartJS, Plotly Charts and for the NVD3 Pie Chart.
  • Support of unicode characters for the translations, the Translations files located in the Settings Repository directory must be in UTF8 Encoding.
  • Optimization of the engine to build the SQL when many Joins are defined.
  • New restrictions options: 'Can change' operator, 'Rows for Value 1' input.
  • Issues Addressed in 4.0:
  • 102: MySQL columns with white spaces are incorrectly created by the Wizard ([] instead of ``)
  • 105: Web Report Server: After modification, the user's profile is not correctly displayed
  • 106: Check Razor Script does not work for global tasks script referencing a server size Tasks Script
  • 107: Web Report Designer: The DateTime Picker is incorrect for US Dates
  • 108: Joins may produce incorrect SQL.
  • 109: Sort Series by point value is incorrect when the chart has several Series.
  • Check list when migrating from previous 3.x versions:
  • Custom templates: May refer to unsupported templates.
  • Themes are not supported anymore.
  • Charts: Implementation modified.
  • Custom parameters for output: Implementation modified.
  • Microsoft Charts are not supported anymore.
  • Custom Cell CSS for Elements is not supported anymore: use Cell Script instead.
  • Translations: Convert previous translation files to UTF8 encoding.

New in Seal Report 3.4.0.0 (Dec 8, 2017)

  • NEW FEATURES 3.4:
  • Performance enhancements when loading the Repository for the first
  • report execution or edition: Implementation of the static Repository Server.
  • Support of browser without Cookie.
  • Requires <sessionState cookieless="AutoDetect"> in the web.config.
  • Debug Mode can be enabled to trace all the Web Report Server calls in the Event Viewer.
  • Requires <add key="DebugMode" value="true" /> in the web.config <appSettings> section.
  • Web Report Server: Responsive design for navigation from mobile device.
  • Report output: New option for custom parameters and CSS values.
  • For report view, "Use custom configuration" is not supported anymore.
  • Issues Addressed in 3.4:
  • 099: Report Designer: Custom parameters for output can only be overwritten if they have not the
  • default value defined for the parameter.
  • 100: Seal Web Interface: The interface SWExecuteReportToResult() generates hyperlinks for images.
  • 101: The state of the data tables displayed (sort, pagination, etc.) may be incorrect after a report execution.

New in Seal Report 3.3.0.0 (Oct 26, 2017)

  • NEW FEATURES 3.3:
  • Data Source: Sort by Name is available per element category.
  • Report Designer: An element can have a custom enum list for special sort or display.
  • Server Configuration: New Property 'Report Creation Script'.
  • New report sample: '34-Task Generate several Report Results'
  • New Model View NVD3 parameter 'Add Points with Null' (true by default) to remove empty points in charts.
  • New 'Open HTML' View template to insert custom HTML or processing during rendering.
  • New Report View Parameter 'Auto-Refresh (seconds)' to re-execute automatically the report.
  • New Report View Parameter 'Load all Models' to force the load of all models during execution.
  • New 'ThisQuarter' date time keyword for restrictions.
  • Web Report Designer: New options to hide summary, page table or main table.
  • Web Report Designer: Calculation options can be edited.
  • The new property Report.OtherResultFilePath can be used in a custom view template to specify another report result.
  • Issues Addressed in 3.3:
  • 92: Joins are auto-created when a column is added from catalog.
  • 93: Web Report Designer: Using IE, filter on restriction values does not work.
  • 94: Optimization of the SQL built to resolve complex joins. Joins preferences were not used in this case.
  • 95: Option 'Invert Data Table' does not work when viewing a result in HTML, PDF or Excel.
  • 96: Copying an enumerated list raises an unexpected exception.
  • 97: Report Designer: View custom template text is lost when edited again without modification.
  • 98: CSV Model raises an exception if the model has a Microsoft Chart defined.

New in Seal Report 3.2.3.0 (Jul 23, 2017)

  • NEW FEATURES 3.2.3:
  • Web Report Designer: Aggregate for restrictions can be edited.

New in Seal Report 3.2.2.0 (Jul 14, 2017)

  • Issues Addressed in 3.2.2:
  • 87: Date Time format for restrictions may not work when time is used.
  • 88: Web Report Server: Invalid user name or password appears on Login screen.

New in Seal Report 3.2.1.0 (Jul 12, 2017)

  • Web Report Designer: Chart sort options can be edited
  • Server Manager: Enhancement of the security groups summary

New in Seal Report 3.2.0.0 (Jun 10, 2017)

  • NEW FEATURES 3.2:
  • Web Report Server Security, the folder right can have the following values:
  • No right,
  • Execute reports / View Files,
  • Execute reports and outputs / View Files,
  • Edit schedules / View Files,
  • Edit reports / Manage Files
  • In addition, a flag "Files only" can be specified to dedicate the folder to report result publication.
  • Web Report Server: New personal folder right on Security Group to allow only result publication.
  • Web Report Server: New properties to control the publication of the report views
  • and outputs in the Web Report Server:
  • View: 'Web Execution'
  • Output: 'Public Execution', 'Public Edition'
  • Web Report Designer: Multiple schedules can be edited.
  • Web Report Designer: The security can be defined on Devices.
  • Update of the libraries of the PDF And Excel Converter:
  • Version 14.0 for PDF and 7.0 for Excel
  • Norwegian translations and calendar (Thanks to Stigh Aarstein)
  • Rework of the CSS of the restrictions (seal.css).
  • Report.cshtml includes 2 files that can be used to customize globally CSS or JavaScript:
  • custom.css (must be located in the 'ViewsContent' folder)
  • custom.js (must be located in the 'ViewsScripts' folder)
  • Issues Addressed in 3.2:
  • 83: The Excel converter may not format date elements as expected.
  • 84: Web Report Server: Buttons for managing files can always be clicked.

New in Seal Report 3.1.0.0 (Apr 13, 2017)

  • NEW FEATURES 3.1:
  • Server Side Pagination: In order to display big tables, the datatables component uses server pagination by default. The sort and filtering are also performed on the server.
  • This option can be disabled using a dedicated parameter of the Root View: 'Server Pagination Enabled'
  • Rework of the Seal Web Interface API: SWI prefix has moved to SW when the call returns HTML result.
  • Check new API description and samples at http://demo.sealreport.org/WebInterfaceAPI.html
  • Web Report Server: The temporary directory is not used anymore for the result publication.
  • Enum values may also have a display restriction value (e.g. to remove html tags set in the display value).
  • or custom cell CSS.
  • Sql defined for Enum values can be built from a Razor script.
  • New parameter in the 'Root View' to inject JavaScript in the report result: 'Additional JavaScript'.
  • New Source property 'Init Script' to execute a Razor script when a report is initialized.
  • New Property 'Init Script' to execute a Razor script when a report is initialized.
  • Default numeric and date formats have been move from Source to Server Configuration.
  • Server Configuration: New Properties 'Init Script' and 'Tasks Script'.
  • Web Report Designer: The security can be also defined on Data Sources and Connections.
  • Issues Addressed in 3.1:
  • 77: The tooltip is incorrect for the NVD3 Multichart with 2 axis having different formats.
  • 78: Images may not be displayed in Chrome when the result is generated locally.
  • 79: When rendering a report after an execution, charts may not be sorted.
  • 80: The Web Report Server Search can show reports not published in parent folders.
  • 81: The Password for STMP devices or Connections may not be saved (Incorrect key size).
  • 82: In the Report Designer, the restriction editor does not support characters '[' or ']'

New in Seal Report 3.0.2.0 (Jan 9, 2017)

  • Web Report Server: compilation with MINIFIED option, clean up of the main HTML.

New in Seal Report 3.0.1.0 (Dec 22, 2016)

  • NEW FEATURES 3.0.1:
  • The Web Report Server allows to reconnect after a login with a blank user name/password
  • Main Javascript files are minified in the setup
  • New Model property Build Timeout (ms) to set the maximum duration used to build the SQL (4000 ms by default)
  • Issues Addressed in 3.0.1:
  • 73: Report definition files (*.srex) may contain unused XML tags ().
  • 74: Excel Converter: Numbers having with special formats may be converted into a Date.
  • 75: The SQL Generation may fail when too many Joins are defined (Out of Memory exception).

New in Seal Report 3.0.0.0 (Dec 2, 2016)

  • NEW FEATURES 3.0:
  • Seal Web Interface 3.0: The Web Report Server has been redesigned to offer a full HTML 5 web interface and a first web report designer.
  • The Web security has been enhanced to configure rights on folders (Execute, Schedule, Edit) and rights on elements for the edition.
  • Check the API Description and Samples at http://demo.sealreport.org/WebInterfaceAPI.html
  • Warning: Note that the web report designer is only available for our sponsors (Please contact Ariacom for more information).
  • A security context can be specified for each report output.
  • An Init Script that can be executed when the report is initialized (check sample 53-Init Script - Set default restriction values).
  • The Csv separator can be specified in the Server configuration.
  • Margins of NVD3 chart are automatically adjusted.
  • Issues Addressed in 3.0:
  • 68: The aggregate function specified for Totals is not used in columns (only Sum is used).
  • 69: Between operator may not work on MS Access or MySQL.
  • 70: The Create Sub Report helper raises an error.
  • 71: Emails are not sent when addresses are separated by new lines.
  • 72: Publication on https does not work if the server is not set as local.

New in Seal Report 2.1.3 (Jun 25, 2016)

  • 67: Using the Web Report Server, enums are not correctly displayed.

New in Seal Report 2.1.2 (Jun 6, 2016)

  • 65: Error may occur if the same SQL is used for several models having an enumerated list.
  • 66: Fix regression to define drill children.

New in Seal Report 2.1.1 (Jun 6, 2016)

  • 64: In Report output, custom restrictions can not be edited (an exception is thrown).

New in Seal Report 2.1 (May 24, 2016)

  • NEW FEATURES 2.1:
  • Seal Web Interface 1.0: The Web Report Server offers a simple interface to ease the integration of Seal Report into existing Web sites.
  • Restrictions: New option to prompt only one value and to specify that the restriction is required.
  • Additional NVD3 Script: Final script to configure the chart after rendering.
  • Escape from keyboard can be used to exit Dialogs.
  • Update to MultiSelect component to v1.2.1
  • Issues Addressed in 2.1:
  • 62: Cell script are not processed in Page Tables if there is no Summary table displayed.

New in Seal Report 2.0 (Jan 29, 2016)

  • NEW FEATURES 2.0:
  • Drill Down (Multi-dimensional navigation): In the Data Source, Drill children can be defined for a table column. This allows to navigate to the child from the value of the element in the report result. A dedicated View Parameter is available to enable/disable the feature. (e.g. Product Category -> Product Name -> Order Id)
  • Sub-Reports (Master-Detail Consultation): In the Data Source, Sub-Reports can be defined for table column. This allows to execute another report from the value of the element in the report result. A dedicated View Parameter is available to enable/disable the feature. (e.g. Order Id -> Report Order Detail)
  • Log Files: One file is generated per day to log the report executions in the repository 'Logs' subfolder. The number of days to keep is configured using the Server Manager: Menu Configuration -> Configure Server
  • In addition to the standard Model template, a new Model Detail template is available to display the detail of a model in a view.
  • Report Designer supports new command arguments (/e and /x) to Execute directly a report or an Output or a View from the Windows explorer.
  • Report tasks may have a common script per Report (edited in a dedicated property of the Tasks folder) or per Data Source (edited in the dedicated property of the Source) in order to define common razor functions in every tasks.
  • The file name defined in an output folder can contain the keyword %SEALREPORTDISPLAYNAME% to specify the current report display name.
  • New column type "Unicode Text" to support Unicode characters in the restrictions for Oracle and MSSQL Server databases.
  • Default numeric and date time display formats can be specified in the Data Source.
  • Web Report Server: Portuguese Translations are available (Thanks to Arthur Jalmusny).
  • Update to JQuery v1.11.3, JQuery UI v1.11.3, DataTables v1.10.10
  • Update to Task Scheduler Managed Wrapper v2.5.4
  • Update to NVD3 Chart v1.8.1 (last commits 29/11/2015): Several new NVD3 Chart View Parameters to control the NVD3 chart. Migration issues: Custom NVD3 chart scripts have to be checked, ToolTip generation may have change.
  • PDF Converter: Update to Library v12.9
  • Issues Addressed in 2.0:
  • 53: Legends are not sorted in NVD3 charts.
  • 54: Sort is incorrect for enumerated values translated.
  • 55: Enumerated lists tanslated are not translated when restrictions are prompted.
  • 56: Init View parameters values does not work
  • 57: The Excel Converter does not work when executed several times for the same report.
  • 58: Default Locale defined in the root view is not used in Views children of a Tab Page View.
  • 59: In Report Designer, Checking 'Show Script Errors' option toggles also 'Schedule reports using current user' option.
  • 60: Characters with accents are not displayed correctly when the restrictions are prompted.
  • 61: Sort may be incorrect in columns of cross tables.

New in Seal Report 1.8 (Aug 18, 2015)

  • NEW FEATURES 1.8:
  • No SQL Data Source:
  • In addition to SQL Data Source, custom Data Source can be defined using C# script. The data source is defined with a table definition script and a load script (either in the table or in the model).
  • Check samples: 40-No SQL Source Hard Disks, 41-No SQL Source XML Google API, 42-No SQL Source RSS
  • Model Scripts:
  • For SQL Data Source, a 'Pre Load Script' can be defined in the model to modify the model before the database load and a 'Post Load Script' can be defined in the model to modify the result table after the database load.
  • Finally, a 'Final Script' is available to modify the model after the complete load.
  • Check samples: 43-SQL Source with XML Google API
  • Cell Script:
  • Custom scripts can be defined on a report element to process values after the Summary, Page and Data tables have been built in the model.
  • These scripts can be used to customize cell display and values or to perform complex calculations.
  • Check sample: 50-Cell Script - Progression and running totals
  • Warning: This feature replaces the previous 'Total Cell Script' property introduced in 1.7.
  • New restriction properties:
  • 'Custom Enumerated List' to change or assign an enumerated list,
  • 'Use as parameter' to use a restriction having the operator 'Value Only' as a simple parameter that can be used in scripts.
  • Check sample: 51-User Input - Connection and threshold
  • Repository Assemblies Sub-Folder:
  • A new sub-folder Assemblies in the Repository folder is available to add extra assemblies (.dll files) to be loaded by the applications.
  • Objects defined in the assemblies can then be used in Razor scripts.
  • Print layout: Interactive controls are not shown any more in NVD3 charts.
  • TaskHelper: New method ExecuteProcess(string path) to execute a program.
  • New options in TaskDatabaseHelper object to customize the following methods directly in the script:
  • GetTableCreateCommand(), GetTableColumnNames(), GetTableColumnValues().
  • Issues Addressed in 1.8:
  • 51: The display of execution duration hours is incorrect after 30 minutes
  • 52: Column names having spaces or special characters does not work with Oracle

New in Seal Report 1.7.1 (May 21, 2015)

  • Update of the SQL engine: in case of GROUP BY expression, the DISTINCT is not use as default.
  • Performances: Rework of the concurrency calls in the Web Report Server and in the report execution engine (no lock anymore).
  • Web Report Server: Rework of the error handling when sessions are terminated.

New in Seal Report 1.7 (May 11, 2015)

  • New Features 1.7:
  • New option to use the report schedules without being administrator of the machine: In Report Manager, option 'Schedule reports using current user', in Server Manager new menu to synchronize schedules with the current user
  • Report Output may have custom parameters and CSS for the root View
  • New parameter in the Report View Template: Show Converter buttons
  • In the tree view Table or Category node, columns can be sorted using the new 'Display Order' property. Helpers are available to sort the table (and category) by SQL Position or by Name
  • Server Manager and Report Designer: A new option 'Keep column names' is available to keep the database column names as display names when table columns are generated
  • Schedule: New option to send a notification email in case of success
  • Translations can be made for Data Source elements and enums, and folders and reports to fully localize the Web Report Server. The new translation file is located in 'Settings/RepositoryTranslations.csv' and menu helpers are available in the Server Manager
  • Update to Task Scheduler Wrapper 2.3.1
  • For performances reason, the Model property 'Show Duplicate Rows' is not available anymore. The 'SELECT Clause' property of the Model has been set to 'SELECT DISTINCT' by default to achieve the same goal
  • Support of the Excel converter interface (commercial component)
  • Also includes changes in the latest Beta version

New in Seal Report 1.7 Beta 1 (Apr 20, 2015)

  • NEW FEATURES 1.7:
  • New layout for template Themes and Web Report Server.
  • Report Manager: Custom razor script can be defined to calculate the Total Cells in a model.
  • SQL Optimisation: Models having the same SQL are only queried and built once.
  • New parameters in the Model View Template: NVD3 Chart Title, Show Summary, Page tables, Data tables and Chart.
  • Server Manager: Helper to test the SMTP server configuration.
  • BUGS:
  • 49 Smart copy does not work for enum values
  • 50 View selection in Report Designer: Unable to change the default view or to select another view for a report output.

New in Seal Report 1.6 (Dec 10, 2014)

  • New Features 1.6:
  • Web Report Server security: A security layer has been implemented through security groups to define what repository folder is published. Authentication can be made and customized using different providers (No Security, Basic, Windows, Integrated Windows, LDAP, Database...)
  • Report Tasks: Tasks allow to perform and sequence basic SQL or Script task in a report (e.g. Refreshing the enumerated list every day). A schedule only dedicated to tasks can be defined (no need of output)
  • Smart Copy: New feature to perform mass updates and copies of Models, Elements, Restrictions, Views, Tasks and Outputs in the same report or in other reports
  • Schedule: New failover options to retry a report in error and/or to send a notification email
  • Email output: New options for the Body message, to Zip the attachments and to specify the Sender and the Reply addresses
  • Web Report Server: Italian translations are available (thanks to G. Chiozza)
  • Web Report Server: User culture preferences can be specified and saved in a Cookie
  • Enumerated List: New width property to specify the display width in the restriction panel
  • Report Designer: For model, new options to replace and double clicking on an element in the tree view inserts the Element just after the Selected Element
  • MetaColumn: New property IsAggregate for columns having already SQL aggregate in their definition
  • Issues Addressed in 1.6:
  • 43 Connection specified in Models are lost after a save and reset to "Current Connection"
  • 44 In the Web application, dialogs are not correctly positioned with Internet Explorer 8,9 or 10
  • 45 Execution durations displayed in the report may not be accurate
  • 47 In the property editor, using Double click to select a Connection (for a Data Source), a Model (for a View) or a View (for an Output) or other properties having an combo box may corrupt the report
  • 48 Cross joins are not correctly handled in SQL

New in Seal Report 1.5.1 (Sep 25, 2014)

  • New feature in 1.5.1:
  • Report Designer: Implementation of the "Is Empty" and "Is Not Empty" restriction options for the text elements.
  • Issues addressed in 1.5.1:
  • 38 For a Data element, if the % calculation option is selected, the total is always displayed in the Page and Summary tables.
  • 39 Web Report Server: The output and view names are displayed in white with a white background.
  • 40 NVD3 Chart may have overlapped axis labels.
  • 41 Refresh dynamic tables reset always the previous column definitions.
  • 42 Spaces are replaced by underscore characters in output file names.

New in Seal Report 1.5 (Sep 18, 2014)

  • New Features:
  • Web Server: Performances improvement of the Web Report Server for report executions.
  • Web Server: Report having an external viewer are directly displayed.
  • Report Designer: New option to Check Razor Syntax in script editor.
  • Support of PDF Converter implementation (requires a commercial license).
  • New icons and Web presentation to ease the product branding. For the Web Server, the product name can be defined in the server configuration.
  • Report display name can be generated using a Razor Script.
  • Report Designer: Element option "Custom Cell CSS" can define up to 3 strings to display Positive and Negative numbers with different styles.
  • New column option "Contains HTML" to display HTML tags in the report result.
  • Rework of report header: fixed position of the header, new "Back to top" button
  • New server configuration option: Server is local (No internet) to use Seal Report on server having no internet access.
  • New server configuration option: Logo name to specify the logo file name.
  • Report Designer: The Drag and drop of report views allows to change the parent of the view.
  • CSS Parameters: New parameters in Report and Model templates to control Font Size, Font Family, and Tables CSS
  • Issues Addressed:
  • 30 In Report Designer: Edit Repository Source with the Server Manager does open the correct source file.
  • 32 NVD3 Chart does not work if axis contains quote characters.
  • 34 A report having 2 views with 2 custom template texts does not work.
  • 35 Tables only involved in prompted restrictions are joined oin SQL, even if no restriction is set by the user.
  • 33 Cross tables may be have ghost cells when using IE 9
  • 36 Data elements defined with a Count aggregate are not displayed in the Page and Summary tables.
  • 37 In NVD3 Chart, the label name of a series may be replaced by (right axis).

New in Seal Report 1.4 (May 8, 2014)

  • New Features:
  • Report Designer: New option to convert a Report Source into a Repository Source.
  • Report Designer: New contextual helper menus to select, remove, copy, prompt elements in a model.
  • Web Server: New option to expand sub-folders displayed in the tree view.
  • Web Server: Web Folder Description File can be a .cshtml file to display a MVC View.
  • Views: additional CSS parameters for some DIVs.
  • NVD3 Chart: Some default configuration values have been changed.
  • Issues Addressed:
  • 16 In NVD3 charts having a secondary Y axis, "(right axis)" is not translated in the legend.
  • 17 Enumerated lists with the option 'List is refreshed upon database connection' are not updated dynamically.
  • 18 Rework of the Copy features in the report designer: Copying a Model does not work.
  • 19 NVD3 Chart: If 2 Model Views have the same parent, only the first chart is displayed.
  • 20 NVD3 Chart: Legends does not display special HTML characters correctly.
  • 21 For Data elements, Totals aggregate function is not displayed and editable.
  • 22 Date keywords with accents do not work in prompted restrictions.
  • 23 Restrictions on Enumerated lists having special characters (like $) may not work.
  • 24 In a Tab page Views, the Views may not be displayed in the order specified in the Tree View.
  • 25 In restrictions, the Is Not Null operator may not work.
  • 27 In the Data Table of the report result, Sort on numeric having a space character as thousands separator does not work for number greater than 999999.
  • 28 In NVD3 charts, Date Time separator is not consistent with the current culture Date Time separator.

New in Seal Report 1.3 (Mar 22, 2014)

  • New Features:
  • Dynamic HTML 5 charts based on NVD3
  • NVD3 HTML5 Chart Support: In addition to Microsoft Chart, HTML5 Charts are available.
  • Better handling of Data source from Excel Workbook, Helper to build connection string from Excel workbooks or Access databases.
  • Samples of report for SQL Server (temporary tables, stored procedure) and Excel sources.
  • New Web Server Settings: Folder Description File Name, If not empty and a file with this name exists in the repository folder, the Web Server displays the file content in the detail frame.
  • New option to display or ignore script errors in the Report Viewer.
  • Optimization of the XML report serialization for Parameters and ChartConfigurationXML Properties.
  • Performances tuning of the engine.
  • Issues Addressed:
  • Changing the default connection of a Report Source not linked to a Repository Source causes an unexpected exception: "Object reference not set to an instance of an object."
  • Pre and Post SQL statements are not executed when checking a table, a column or when checking the SQL of a model.
  • The Copy table feature does not change the columns GUIDs, the column copied cannot be used in the models.
  • Sorting Row Elements in a Pivot table may cause invalid Data Values display
  • When Using Render View (HTML or Print), the Chart Series Values are incorrect.
  • Date separator of DateTime picker may not match the current report date separator.
  • Depending on the report language, numeric restrictions with commas may not work.
  • Copying a sub view creates a view with an incorrect parent.
  • Saving a report after changing the culture of the main view may cause restrictions to be lost.

New in Seal Report 1.2.1.0 (Feb 7, 2014)

  • Includes the last version of the Task Scheduler Managed Wrapper (better support for Windows 8 and 2012)