Major Changes in Release 11

i-net Clear Reports runtime

i-net Clear Reports viewer

i-net Designer

Configuration Manager

Remote Interface

Repository

Scheduler

Setup

.Net Edition

API for a trigger added. The trigger can be used for example in email action of the scheduler.

Formula functions “ToTextFixed” and “TranslateFixed” added.

API improvement: adding a sub report to a sub report no longer leads to a corrupt engine but rather immediately throws an IllegalStateException.

It is now possible to log in with a different user name if you are already logged in.

The remote servlet now allows a redeploy and restart of the servlet without starting the whole server.

The comparison of the subreport link values is now case-sensitive.

Now the report data cache will be cleared each time you click on the refresh button.

The using of column labels with MySQL connector 5.x and query commands works now by Engine.setData(ResultSet) and Engine.setSql(String).

The mirroring of the report layout for RTL languages like Arabic respect also subreports and charts now.

It's now allowed to create variables with the name of existing functions in a Crystal-syntax formula.

Content rendered with text interpretation = 'HTML (advanced)' can now break within a word, in case the word is wider than the the field element width. This does not apply to text inside a HTML table or an auto-sized floated HTML element.

The i-net Clear Reports startpage now only shows the red warning for deactivated features.

It is now possible to execute the formula ”{StringField}[startIndex to endIndex]” on a database.

In rare cases, when saving older reports with SQL Expression Fields, the fields were incorrectly saved, making them invalid.

In rare cases, older reports had issues with SQL Expression Fields which led to them being loaded in the latest version of i-net Clear Reports as having the name “null”. This caused the report to no longer work.

Prompt names including ”</script>” in the name could cause issues in the HTML-based Prompt Dialog. The names are now correctly escaped.

An IllegalArgumentException occurred if a continuous chart was drawn with multiple null values.

A login request (HTTP code 401) need a long time with JBoss because the wrong content length was send to the client.

Report Reader:

The 'case sensitivity' parameter was ignored, if the formula function InStr was executed on database.

A section was as blank (empty) detected, if it contains only a JavaBean on top of this section (Top = 0).

Fixed a security bug which allowed a user to be partly authenticated in the system when another user opened the remote designer.

Formulas could not store any and all characters, even ones normally invalid in XML documents.

Special fields with numbers (such as Page Number and others) lost any custom number format settings when the report was saved and re-loaded.

The XML RPC method “listResources” returned an error if any of the resource names used multi-byte characters.

Special field “Page N of M” was not displayed correctly in PDF export, if the font SansSerif was used.

Field references in the field browser tree were incorrectly counted when they were referenced by parameter default value formulas and then undoing multiple steps of report design.

PDF export:

HTML export: The first paragraph was not shown, if it was empty.

Text interpretation “HTML(Advanced)” now relies on the actual fonts used by any renderer(e.g. PDF or XLS) which provides a more accurate render output for fonts not known to the Java font system.

Shutting down then restarting an i-net Clear Reports server caused the logging to be deactivated the second time around.

The data of the report was emtpy if the report was executed three times by using of report data cache.

Non JDBC Database classes has not worked, if the data source configuration of the report does not exists on the server. In this case it has tried to connect to a JDBC connection.

Added Classes

Added Methods

In the report viewer, if a report has been cancelled or is no longer valid, the navigation buttons are now disabled - before, it was possible to page through the invalid report with only white pages showing.

Changing tabs in the Safari browser to a different tab than the report viewer applet caused the report currently being displayed in the applet to no longer be visible, even after switching back to the viewer. Now, tab changes work without problems even for browsers such as Safari.

Workaround for a bug in the Java VM added. Because of the bug it could occur that the end of long text lines were cut on printing. The clipping depends on the text, font, font size and it occurs very rarely.

Selecting search results in the viewer sometimes did not highlight the result in the viewer panel when a result was on a page not currently being displayed.

Font auto scaling in the java viewer for text generated by an HTML(Advanced) text field was wrong.

Properties “Default Syntax for new Formulas” and “Default Null Behavior for new Formulas” added to the category “Extra” of the Designer Options. With these properties it is possible to set the default null behavior and the default syntax of the Formula Editor.

Prompt descriptions now are no longer automatically interpreted as HTML, so that characters such as pointed brackets are now displayed correctly. Now, if you want to use HTML formatting for your prompt description, prefix your description with ”<html>”.

Property “Suppress empty reports” added to the properties of a subreport.

Various improvements and bug fixes made for the designer's prompt editor dialog.

The Designer now supports repository URL's with redirects.

It is now possible to display the SQL statement of a command in the Database Wizard, even f the database conection is invalid.

Formula Editor: The terms ”{field} = null” and ”{field} <> null” can now be used as null-checks as well.

The summary dialog has been reworked.

The designer now acceps a file path without –open as start parameter.

The designer now creates its own special configuration called “Designer_Default” if the designer is started for the first time or the configuration the designer was based on has been deleted. This i-net Clear Reports configuration is pre-configured with various settings that make more sense for working on report design rather than for running an i-net Clear Reports server.

The fields browser tree of the subreport was displayed instead of the fields browser of the main report when opening the dialog “Subreport Links” from the context menu of the subreport prompt fields.

In the designer, re-running a report in the preview tab caused the error bar to display “Loading error” for a split second each time.

The tooltip for warnings from the problem finder now appears below the warning.

A special field of type number don't respect the “decimals” properties defined in the default values for number field elements anymore.

The tutorial “How to create a datasource” has not worked on Macs OSX.

In a German locale, the designer's prompt dialog interpreted string limit lengths incorrectly.

Sometime the selected file could not be opened in the designer filechooser due to a deactivated open button.

The context menu for links in the Database Wizard was not visible, if i-net Designer runs on Mac OS X.

Opening a subreport doesn't behave like a change to the report anymore. An undo step will be created but save is not enabled if no other changes took place.

In the designer, if a database connection was encountering a timeout and the preview process was canceled by pressing escape, the process loader could cause the designer to hang for 20-30 seconds before displaying an error.

In the designer, if a report contained an incorrect database password, the password dialog was not displayed to correct the password when trying to preview the report.

If a new report is saved and then changes are undone and the report is re-saved, the designer would incorrectly warn the user that the report had an old format.

Removed Methods

Property “Servlet Filter” added.

The scope USER_SESSION was added for datasources.

It was not possible to add more than 17 users and/or groups to the System Permissions.

The i-net Clear Reports configuration was unable to store very lengthy values in the Preferences. This had the effect that it was not possible to administer system permission rights to more than 15-20 users. This has been fixed, values can now have arbitrary length and as many users as desired can be created and administered in the i-net Clear Reports configuration manager.

The Remote Interface did not work with Internet Explorer 9.

When scanning new drivers in the web-based data source manager, the new drivers were displayed in the list, but could not be selected until leaving and re-entering the menu.

Remote Repository Browser now updates the folders and files on browser refresh.

The scheduler now use the logging of i-net Clear Reports.

During installation, ::1 and 127.0.0.1 are now both shown in the IP filter list by default, so that users will not lock localhost out of the server if their system uses IPv6 for example.

Even for a package installation, the ReportReader files are copied into the installation directory.

i-net Clear Reports .NET: One of the shortcuts in the Windows start menu was incorrectly generated and was invalid.