Skip to content

@ariacom ariacom released this Mar 2, 2020 · 77 commits to master since this release

NEW FEATURES 5.5:

  • .NETCore 3.1 Project and Distribution of the Web Report Server.
  • New Seal Report Scheduler component to schedule reports from the Web Report Server, a Windows Service or a NETCore Worker Service 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 SpecialFolders\Schedules repository folder.
    The Seal Report 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'
  • Publication of SealReportLibrary.Net and SealReportLibrary.NETCore NuGet packages.

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.
  • 155: Drag and Drop to reorder Dashboards does not work.
Assets 4

@ariacom ariacom released this Jan 17, 2020 · 85 commits to master since this release

NEW FEATURES 5.1:

  • Report Task: A new property 'Execution Step' allows to execute the task after the models generation,
    before the output execution or at the end report execution.
  • New reports published in the '\System' repository folder: 'Security Summary', 'Report Inventory', 'Audit', etc.
  • Report Designer: Several properties (like 'Display Name', 'Current View', etc.) have been moved to a specific 'General' tree view node.
  • Audit Script: The configuration contains an 'Audit Script' called when following events occurred: Login, Logout, Report Execution.
    The setup includes an 'Audit' Access database with the related data source and reports.
    Check report 'System\Audit Search.srex'.
  • Web Report Server: A PreLoad process allows to speed the start up of the application (the feature can be can be disabled with the PreLoad flag in Web.Config).
    The process compiles all view templates and executes the reports involved in Dashboards.
  • Web Report Server: By default parent folders with no rights are hidden.
    A new property 'Show all folders' in the Security Group can be set to 'true' to force the previous behavior.
  • For each result cell, new navigation links for HyperLink or FileDownload can be defined.
    The file download process can be implemented in the cell 'Navigation Script' property.
    Check new samples '14-Images - File Download' and '42-No SQL Source - File Download'.
  • Navigation is active in Dashboard Widgets (Subreports, Drill, File Download and Hyperlink).
  • Report View: New property 'Reference View' to get default values from another view for parameters and template texts.
  • Setup: The Repository directory can be chosen at the first installation.
  • Restriction: New advanced property 'Display Order' to sort the prompted restrictions.
  • Server common scripts must be included using an @include("<script name>") directive.
  • Authentication with token for the Seal Web Interface:
    SWI with JWT authentication and other improvements. Refer to #25.
    SWILogin has a token parameter which is stored in the SecurityUser (as well as the Http Request) and can be used in the Security Provider Script.
    Check sample script in JWT security provider.
  • SWI: For report execution, new parameter 'use_default_restrictions' to force the use of the default values for custom restrictions not specified.
  • Prompt type: new option 'Prompt only two values' (e.g. prompt a date range in an input restriction).
  • Drill navigation: New property 'Navigation: Drill all elements of the hierarchy' to allow applied navigation to all elements involved in the hierarchy.
    e.g. When drilling up from day to month, 'Day' is replaced by 'Month' and 'Month' (if it exists) by 'Year' in the same model.
    e.g. When drilling down from month to day, 'Month' is replaced by 'Day' and 'Month' (if it exists) by 'Year' in the same model.
  • '@using Seal.Model' and '@using Seal.Helpers' are automatically added to any razor scripts if necessary.
  • Root view: new option in 'Display: Execution messages' to show messages only during execution.
  • Dashboard Widget: The root execution view can be specified to execute the report from the Widget title.
  • Sub-reports can be made from a Non-Prompted restriction. The 'Add an existing Sub-Report' helper allows to choose the restrictions to include in the link.
  • JavaScript upgrade to Data Tables 1.10.20, JQuery 3.3.1, ChartJS v2.9.3
    The following Data Tables Extensions are included: Fixed Columns, Fixed Headers and Scroller with their related properties in the DataTables view template (Check samples 06).
    Check https://www.datatables.net/extensions/index for more information.
  • Spanish Translations (Thanks to Jorge Torres)

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.
Assets 4
Jan 17, 2020
5.1.1
Dec 20, 2019

@ariacom ariacom released this Jun 26, 2019 · 224 commits to master since this release

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.
Assets 4

@ariacom ariacom released this Nov 11, 2018 · 317 commits to master since this release

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.
Assets 4

@ariacom ariacom released this May 10, 2018 · 351 commits to master since this release

NEW FEATURES 4.0.1:

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

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 libraries: 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.1:

  • 104: When rendering a report after a first execution, the sort may be lost when Row and Cols are sorted...
  • 110: Format specified as % can be reset to default when editing a Data Element.
  • 111: Seal Web Interface: csv format is not supported by SWExecuteReportToResult.

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.
Assets 3
May 10, 2018
Pre-release
Pre-release

@ariacom ariacom released this Apr 18, 2018 · 374 commits to master since this release

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.
Assets 3

@ariacom ariacom released this Dec 8, 2017 · 409 commits to master since this release

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 Cookies.
    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.
Assets 3
You can’t perform that action at this time.