Overview

  • New reports no longer store the report data source in the report template by default. You can change this option in the report's Document Properties, however be aware that this gives anyone with the report template full access to your data source
  • New implementation of the Datasource Manager
  • Redis support as cloud persistence backend was removed. If you use it then migrate to MongoDB before you update
  • Cloud synchronization and events to run i-net Clear Reports shared across several cloud nodes added
  • Let's Encrypt protocol version ACMEv2 supported. The Let's Encrypt protocol version ACMEv1 will be end of support on November 1st, 2020. If you use Let's Encrypt certificates for HTTPS then you need this update
  • Critical Security Update for Help Plugin (CVE-2020-11431)
  • Fixed XXE vulnerability for authenticated users with privileges to ad-hoc reporting or remote designer (CVE-2020-12684)
  • Fixed multiple XSS vulnerabilities (login was not required).
  • Fixed a path traversal vulnerability which allowed access to files within the installation folder and its sub-folders
  • AdoptOpenJDK updated to version 11.0.3
  • Cloud providers like AWS, Jelastic, Heroku supported
  • New Prompt dialog implementation
    • User experience improved
    • Cleaner, more modern look and feel
    • Theming supported
    • More than 1000 default values supported
    • Prompt dialog added to Task Planner
    • Google Web Toolkit framework and plugin removed
  • Java version 12 now supported
  • Plugin "Notifications" added for receiving status updates and error messages as well as optional recurring, configured messages
  • Plugin "UpdateCheck" added to regularly check for updates of the system. The Plugin also provides a maintenance module to manually check for updates and to control how often it should check for updates and to display the changes made since the installed version. Download links will be provided in case a new version is available
  • Redis and MongoDB are now supported locations for the persistence of i-net Clear Reports in cloud environments
  • Cookie banner added to the web interface to indicate the use of cookies for the login
  • Event Log views added to Statistics app in report server web interface

i-net Clear Reports report server

New Features / Improvements

  • The "External visible URL" being used for the EHLO command when connecting to an SMTP server
  • Any subdomain (like *.example.com) on "Allowed Cross Origins" supported
  • PDF export: Dejvu-Sans is used as default font for font embedding if no other font is available in the font path

Fixed Bugs

  • Possible deadlock on startup occurred if a custom configuration was set via "clearreports.config" or "clearreports.configfile"
  • Permission check with Authentication Groups for logged in users was wrong
  • Multiple values in the property "Other VM Arguments" in configuration dialog "Web Server" were not supported
  • Rare rounding error occurred when the scale of a number was reduced by more than 9 digits in a formula function
  • Access to the repository with Login using WebDav has not worked on Windows
  • OutOfMemory or ReportCache errors occurred because of problems with false positive low memory detection. The log output contains the warning: "There was a low memory situation and possibly some jobs were canceled." and maybe other subsequent errors

i-net Clear Reports runtime

Changed Behavior

  • Fix the recognition of value data types for JSON data sources if the source files contain white spaces
  • Null values in JSON data source supported
  • New data Sources will be saved in the new application scope now
  • The property "driverLibrary" has been removed from the list of properties for Data Sources. Additional drivers for databases have to be provided using the "lib" directory of the installation

New Features / Improvements

  • Thai support for the formula function ToWords
  • Add Engine.SetData to the .NET process bridge
  • Notification for low disk space added
  • Locale of the client is used for formatting in the prompt dialog, e.g. for date formatting
  • The webserver can be configured to send addtional header fields with HTTP responses to, e.g. enforce HSTS or provide custom server information to the web client

Fixed Bugs

  • Security issue "Cross-Site Scripting" occurred
  • Unknown operation: com.inet.report.renderer.doc.controller.bk@0 occurred with TotalPageCount (NofM) in subreports
  • Property RELOAD_ON_NEW_REQUEST does not work if there was no output format specified in the report URL
  • "java.io.NotSerializableException: com.inet.font.truetype.i" occurred if a font path was set and "Page NofM" or PageCount was used in very large reports. Because of that the server could hang
  • Regression occurred: Special field "current user" and the formula WebUserName returns the display name. Now it returns again the id of the user and not the display name
  • Embedded fonts used in PDF documents embedded in a sub report where missing in the created report
  • Layout of text in right to left fonts (Arabic, Hebrew) was wrong, if the text parts have different styles (bold, italic, etc.). It occurs in the output formats: PDF, PostScript, image and Java report viewer
  • Sorting in charts with 2 groups was incorrect if the first category value does not contains all series values of the chart. In this case the sorting of the series was incorrect
  • PDF export: Embedded fonts with glyphs in the range of 0xF000-0xF0FF were not dispalyed in PDF file
  • CSV export: Empty CSV export with encoding UTF8 opened with MS Excel. MS Excel shows the content "" in the first cell instead of a complete empty table
  • ORA-01000: maximum open cursors exceeded - occurred if Oracle JDBC driver was used
  • NullPointerException in debug mode if a plugin has no version information
  • Patching the SQL command to query the metadata (column names) was wrong if the command contains function listagg(...) within group .... In this case WHERE 1=0 was added to the listagg function
  • XLSX / ODS export: Percentage number was incorrectly displayed (multipled by 100)
  • Patches the SQL command to query the metadata (column names) was wrong if the SQL statement contains strings which contains brackets, e.g. REPLACE(A.FIELD,';)',')'). In this case WHERE 1=0 was added after the ORDER By clause
  • Break algorithm improved for Text Interpretation "HTML(advanced)" to prevent breaks in text lines
  • Table source identifier with a package name will be always used as name of a stored procedure and never as name of a table. This makes it possible to use the same name for a package stored procedure and a table
  • IllegalStateException: REGISTER error occurred because a classloader loop occurred if the i-net Clear Reports libaries has been added to /lib directory
  • Percent formatting in the XLSX export format was incorrect

i-net Designer

Fixed Bugs

  • Layout of text in right to left fonts (Arabic, Hebrew) was wrong in the design view, if the text parts have different styles (bold, italic, etc.)
  • NullPointerException occurred when opening an rpt file with corrupt subreport, created by an older i-net Designer version
  • Hairline box without background was not printed in the Java output (report preview)
  • Warning for required .NET Framework 3.5 removed

New Features / Improvements

  • Users are no longer required to have Java installed separately anymore: the Designer now supports a protocol handler to open a locally installed i-net Designer instead of the JNLP variant

HTML Report Viewer

Fixed Bugs

  • XLSX export: Line offset was wrong on third sheet if "New sheet per top level" was enabled
  • The automatic font scaling did not work as expected in Internet Explorer

Report Repository

New Features / Improvements

  • Persistence Repository implementation added

Maintenance

New Features / Improvements

  • Benchmark for CPU and IO rating added

Task Planner

New Features / Improvements

  • XML export added to the task planner
  • Prompt values added as placeholder that can be used for example for report name or in email action.
  • It is now supported to set "Delete previous results after X days" for a file action. With this property it is possible for example to delete old backups
  • Prompt dialog added
  • It is now supported to select a preconfigured datasource for a database series. The user defined JDBC settings are still possible

Fixed Bugs

  • Buttons to sort and filter task list not displayed if task list is very long

Data Source Manager

New Features

The Data Source Manager has been reworked from the ground up and comes with an all-new Remote GUI interface. It now supports assigning datasource permissions to specific user groups

  • Completely new Data Source Manager Interface
  • New Data Sources will always be created in the Application Scope
  • Existing Data Sources in the former User/System/Temp/Session - Scopes will be readonly in the Remote GUI
  • Assigning user group permissions to datasources can be performed by users with the User Manager permission.
  • Data Sources can be exported individually using the cards menu and multiple Data Sources can be exported using Click and CTRL+Click / CMD+Click to select and then using the top menu "Export" Button
  • The Import (top menu → Add → Import) of Data Sources will always create the new Data Sources in the editable Application Scope
  • The former Scopes are available via API only. The Remote Interface only displays the indirectly using the "visibility" entry in the Data Source card
  • Default value of the property "Supports SQL92" in a new Oracle datasource is true now

Fixed Bugs

  • For a new Oracle datasource the default value of the property "Supports SQL92" was false. Since Oracle version 9 it supports the SQL ANSI 92 syntax. Therefore the default value is true now
  • The datasource manager allows to enter a custom database/catalog name while still suggesting existing names
  • Cannot read property 'driver.group.basic' of undefined occurred if a datasource was saved without modifications

SDK

New Features / Improvements

  • Engine.SetData added to the .NET process bridge

Fixed Bugs

  • Report server was started with command line parameter "-importdatasource" or "-forceimportdatasource"

Report Server

New Features / Improvements

  • A restart in the server interface triggers a restart of all nodes if database persistence (MongoDb, Redis) is used
  • Event log contains a "node" column if it runs with database persistence (MongoDb, Redis)
  • Let's Encrypt certificate requests now work with multiple server and database persistence
  • Default "Font Path" for PDF export and Java viewer added. The default font path contains DejaVu fonts for Monospaced, Sans Serif and Serif fonts. Font embedding of DejaVu fonts is enabled by default

Fixed Bugs

  • Configuration data lost if MongoDB was used for persistence with multiple report server instances
  • Synchronization of cached user data, groups, task planner, maintenance data between multiple nodes was incorrect if using database persistence (MongoDb, Redis)
  • Fix the recognition of value data types for JSON data sources if the source files contain white spaces
  • In Chrome browser it was not possible to save the PDF result of a report if it was already displayed in PDF viewer of the Chrome browser. The save prompt indicates ‘Save as type: All Files (*.*)’ instead of PDF
  • Text export: Charset was set incorrectly
  • Property RELOAD_ON_NEW_REQUEST does not work if there was no output format specified in the report URL
  • Configuration data lost if MongoDB was used for persistence with multiple report server instances
  • Infinite loop occurred when using report viewer in an iFrame

Java Report Viewer

Fixed Bugs

  • NoSuchMethodError: 'void java.lang.SecurityManager.checkSystemClipboardAccess()' occurred if Java report viewer was use with Java 11

User and Groups

New Features / Improvements

  • It is now supported to give users or user groups the permission (serverprint) to remotely print on specific printers connected to the server. Now each group can be set to only print on its own server / network printer
  • Multiple LDAP server on authentication supported as fallback
  • Account id of the user added to the "stored data" view

Changed Behavior

  • A master account will be created after a valid login using the master password even if the setting "Create new User" is deactivated
  • New feature "stay logged in". After login, each user will remain logged in until they log out. After 28 days, they will be automatically logged out. It is also possible to delete user sessions in the "User and Groups" module, if you have the permission to access this module
  • Login Sessions displayed in the User details