i-net Clear Reports

Overview

  • Java VM version 8 embedded: The Java VM version 8 is embedded with i-net Designer and Report Server on Windows and Mac. It will be installed and used if no Java VM version 8 was found on the machine.
  • .NET and Java API in ReportServer included: During setup of the report server using the Custom installation type it is possible to install the i-net Clear Reports .NET API which enables you to embed i-net Clear Reports into an .NET application.
  • Configuration Manager reimplemented / redesigned: To increase and simplify the configuration of i-net Clear Reports, the configuration manager has been redesigned and reimplemented. The assignment of properties to groups was improved. Also a “simple” and “advanced” view was introduced.
  • Report Permissions in Repository: The report permissions can now be configured in the category “Permissions” (All reports) and in the Repository Browser. This simplifies the administration of user permissions. The rights on a folder in the repository will now be inherited by subfolders. It is now possible to list files in the repository when only an execution permission is granted. The read permission is not necessary anymore to list the report files.
  • Record Selection Formula optimized: The record selection formula is now divided into a part that is executable on the database and a part that is not executable on the database. The part that is executable on the database will be added to the Where clause of the SQL statement. The other part will be executed in the memory. In previous versions the complete record selection formula was executed in memory if a part of it was not executable on the database.
  • Report URL parameter “reports” added: With this new property, it is possible to render multiple reports as one output file, e.g. PDF file.
  • Output format Excel spreadsheet (XLSX) added: It is now possible to export a report into the newer Microsoft Excel spreadsheet format XLSX. The output format XLS is deprecated and will be removed in one of the next versions.
  • Report URL parameter “sproc” is deprecated: Instead of the sproc parameter you can use any of the prompt parameters in the report URL to set the parameter field value for a stored procedure.
  • Report URL parameter “queryfile” is no longer supported: If you have report files with query files then you need to migrate it so that they use a datasource.

i-net Clear Reports runtime

The Java VM version 8 is embedded with i-net Designer and Report Server on Windows and Mac. It will be installed and used if no Java VM version 8 was found on the machine. During setup of the report server using the Custom installation type it is possible to install the i-net Clear Reports .NET API. This allows to embed i-net Clear Reports into an .NET application.

New Features / Improvements

  • Report URL parameter “reports” added - the value should be multiple reports you want to render as one output, e.g. PDF-file. Separate each report by semi-colon.
  • XLSX export for newer Microsoft Excel versions added.
  • Webserver plugin added.
  • CHAR and NCHAR values are also truncated for dynamic prompt values.
  • Limited the number of threads used by the Jetty webserver on a high cpu count machine to prevent IllegalStateException: Insufficient max threads in ThreadPool.
  • The report URL will be resolved after checkProperties. This makes it easier to work with your own address space.
  • Jetty version updated to version 9.2.10.
  • It is now supported to embed OTF fonts in PDF export and Java report viewer.
  • The record selection formula is now divided into a part that is executable on the database and a part that is not executable on the database. The part that is executable on the database will be added to the Where clause of the SQL statement. The other part will be executed in the memory. In previous versions the complete record selection formula was executed in memory if a part of it was not executable on the database.
  • If both clearreports.config and clearreports.configfile are set in the web.xml file of the i-net Clear Reports servlet then clearreports.configfile is used as fallback only if the configuration in clearreports.config was not found.
  • The PHP Proxy has been removed. The Apache setup now requires the additional modules “rewrite”, “proxy_http” and “headers” and uses the internal mechanism to forward requests via Apache to i-net Clear Reports.

Changed Behavior

  • To prevent an OutOfMemoryError, the maximum number of errors in EngineState was limited to 10.
  • Formula ADD operation is now more strict: Strings can only be added to strings. Hidden internal type conversions are no longer possible.
  • Formula fields with evaluation time BeforeReading that are included in the record selection filter can be executed on the database even if they contain local variables.
  • For Oracle database, the column name will be used as column alias instead of comment.
  • Support for database functions of MySQL v5 and greater added.
  • When quotesToLowerCase (Quote Database Identifier) property is set in datasource configuration, database identifiers are always quoted.
  • It is now supported to use cascading parameters from different database tables.
  • The method Datasource.getConnection() has a call counter now. You need to call close() as many times as you call getConnection(). Otherwise you will have a connection leak. We recommend using the try-with-resources feature introduced in Java 7:
    try( Connection conn = ds.getConnection() ) {
      // some stuff
    }

API Changes

  • Classes, methods and constants that had been set to deprecated in version 12 and older have been removed.
  • Added Classes or Interfaces:
    • com.inet.report.EngineBundle
    • com.inet.report.database.fetch.DataCollector
    • com.inet.report.database.fetch.FetchTables
    • com.inet.report.formula.UserDefinedFunction
  • Added Methods:
    • SwingViewerContext.SwingViewerContext(Component)

Deprecations

  • Report URL parameter sproc: You can use any of the prompt parameters in the report URL to set the parameter field value for a stored procedure instead.
  • Report URL parameter queryfile: If you have report files with query files then you need to migrate them so that they use a datasource.

Fixed Bugs

  • A summary field with enabled Running Total and with Evaluate “On Change Of” a group and Reset “On Change Of” any non-group field was not working correctly.
  • The required hard disk space on a restart was reduced through reusing of files.
  • The method engine.getDefaultSqlOfAllStatements(boolean leavePrompts) ignored the leavePrompts parameter.
  • In some export format, the height of a section was not increased even when it contained an image with enabled “Can Grow” property.
  • PDF form fields did not work correctly in subreports.
  • HTML export:
    • Representation of developer edition labels was incorrect.
    • Text was not displayed after multi-column layout in subreport.
  • XLS export: ArrayIndexOutOfBoundsException occurred if an image in a section did not fit to a sheet. The section now starts on a new sheet.
  • ODS export: Depending on the used cell distribution and the report design, rows with height of 0 were added.
  • Cascading parameters were required to have the same value type as their parents which is not actually necessary.
  • There were multiple issues with setting the parent references of cascading parameters.
  • The report was not executed (The data source “xxx” is not defined.) if database connection was set programmatically using setConnection but the datasource on the report was designed does not exists on the server running the report engine.
  • NullPointerException occurred with XLSX and ODS export if the Woodstox Stax XML API was in the classpath.
  • The exception “SocketException: bad argument for IP_MULTICAST_IF2” occurred on Mac OSX if ethernet adapter “en0” was not available.

Java report viewer

New Features / Improvements

  • XLSX export added to export dialog.
  • It is now possible to switch between the prompts in the prompt request dialog using Ctrl+Alt+P (for Previous) and Ctrl+Alt+N (for Next).
  • Support Open Type Fonts.
  • Embedded multipage formats, like PDF, correctly displayed.

Changed Behavior

  • Font data for fonts with different styles are embedded only if the data differs.

Fixed Bugs

  • If the Java report viewer was running at least with Java 7u65, then the printer properties dialog was not displayed after a click on the properties button in the print dialog.
  • Printer Properties dialog was not displayed since Java VM version 7u65. The printer property dialog will be displayed now immediately with Java version 7u65 or newer.
  • Characters were missing in charts legend.

HTML Report Viewer

New Features / Improvements

  • Multiple page formats in the HTML report viewer and other export formats supported when using multiple reports.
  • XLSX export added to export dialog.
  • Introduce permanent link to the export menu of the HTML VIewer. It allows copying the current export configuration. The button can be displayed via report URL parameter.
  • The HTML report viewer supports Form Authentication within the viewer itself instead of before the viewer is being displayed.
  • IPv6 supported.
  • Timezone support added to HTML report viewer. This is only supported by the Chrome browser currently.
  • Subreport position in section with enabled “Underlay Following Section” was incorrect.

Fixed Bugs

  • Depending on the used browser, one of the following errors has occurred: “TypeError: k.elementStyle is not a function” or “Object doesn't support property or method 'elementStyle'”.

i-net Designer

New Features / Improvements

  • Problem Finder: Added rule to warn on multi-section elements which cannot be rendered because it starts in an “underlay following” section.
  • Alpha-numeric sorting is now available for interactive sorting and groups.
  • New rule added to the problem finder - giving a warning for identical overlapping elements (which can happen due to Copy & Paste).

Changed Behavior

  • Properties “Disable filtering” and “Disable sorting” removed from report property dialog. They will be displayed only if the properties are already set in the current report.
  • Parameter Properties: Double-click to add a default value for a range prompt - this opens the add range dialog.

Fixed Bugs

  • Summary Field Properties: An enabled Evaluate “On Change Of” for a group field was modified to “For Each Record” if Reset “On Change Of” was enabled for any other field with the exception of groups after the report was reopened.
  • Although login type “Database Login” was set, the Database Wizard has not used this set connection.
  • If Nimbus Look & Feel was used and the i-net Designer was running with Java 8, then selected tree nodes disappeared on selection, and a popup was not displayed with the text color.
  • A disabled “Running Total” was not saved if “Evaluate - For Each Record” was enabled and “Reset - On change of” a field was enabled.
  • It was possible to delete crosstab sub elements without deleting the crosstab.
  • Database wizard:
    • It did not use the connection from a set LoginDatabase.
    • When prompts were used in SQL commands, they were not requested.
  • SQL Editor: OK button was not enabled because of invalid SQL statement.
  • GUI-lock occurred in the Report Wizard of the Remote Designer.
  • Summary dialog: Removing the running total flag from a summary field was not saved if there was a reset field.
  • Step-by-Step Tutorials were not displayed in Free Designer if it was used with Java 8.
  • The key of the translated text defined with formula function “TranslateFixed” was not listed in the Language Editor.

Configuration Manager

To increase and simplify the configuration of i-net Clear Reports, the configuration manager has been redesigned and reimplemented. The assignment of properties to groups was improved. Also a “simple” and “advanced” view was introduced.

New Features / Improvements

  • Simple / Advanced view added. Properties were divided in different views to simplify the configuration.
  • For a better understanding properties were partially move into other groups.
  • All available users and groups are displayed in the drop down box of category permissions.
  • The categories System Permissions and Report Permissions were combined into the category: Permissions. In the category Permissions it is now possible to specify which user and/or groups can execute all reports. The permissions for repository reports are specified in the Repository Browser.

Repository

Changed Behavior

  • Permissions in repository browser changed: Files and folders are now visible if the user have the execution right for this folder. Permissions are inherited to sub folders and can be overwritten in a sub folder.

Ad Hoc Reporting

New Features / Improvements

  • Permission for 'Remote Designer' now includes (former) permissions for 'Remote Datasources' as well.

Changed Behavior

  • In ad hoc reporting the user is now allowed to use all ad hoc templates and ad hoc dataviews unless a repository is used as storage and report permissions are set in the report repository.

Statistics

New Features / Improvements

  • If the 'download' of a cached report causes a new cache-entry (because a different user already requested the same report or similar) then the download shows as 'Run report again' to make clear that the report will be rendered again.
  • Benchmark widget added. It can be used to test the server utilization and speed between client and server or server and database.
  • Category “System Dumps” added. It allows you to download a memory dump or thread dump of the report server.

.NET Edition

  • The .NET edition is not available anymore. During setup of the report server using the “Custom” installation type, it is possible to install the i-net Clear Reports .NET API with which it is possible to embed i-net Clear Reports into a .NET application.

 

© Copyright 1996 - 2017, i-net software; All Rights Reserved.