i-net Clear Reports

Overview

  • Scheduler redesigned: The web GUI of the i-net Clear Reports scheduler has been replaced by a new Remote Interface module. You can access it in the Remote Interface or using the URL:
    http://<servername>:<port>/[<servlet-context>]/remote/scheduler
  • Configuration manager modul completely re-implemented: The configuration manager modul has been redesigned and re-implemented. Note: It won't work with Internet Explorer 6 and 7.
  • HTML export completely re-implemented: To improve the quality of the HTML export format, it has been completely re-implemented. It looks now more simliar to the report design. Vertical lines and boxes are supported.
  • HTML export in compressed zip archive added: With the “htm.zip” export format, it is now possible to request a ZIP archive containing the exported HTML and image files.
  • New export format ODS: The export format ODS has been added to the list of supported export formats.
  • Crosstab completely re-implemented: Because of a lot of bugs and problems with the old implementation of the crosstab, it has been re-implemented completely.
  • isNull(currentFieldValue) returns false: The currentFieldValue of a number field is not null, therefore isNull(currentFieldValue) returns false, always. Only if the currentFieldValue is a String, then it could be null.

i-net Clear Reports runtime

New Features / Improvements

  • The HTML export has been completely re-implemented to improve the output of the exported HTML file. It is based now on HTML 4 und CSS 3.0.
  • New Export Formats:
    • HTM.ZIP - HTML export in compressed zip archive
    • ODS
  • JavaBean “ZXingBarCodes” added. With this bean it is possible to add QRCode to a report.
  • It's now allowed to call a Formula Expander Class function from inside a user defined function(formula).
  • Improved error message when entering an invalid prompt value.
  • CSV Export: Multiple characters can be used as one delimiter, e.g.: |;:
  • HTML export:
    • The HTML viewer will not open the same subreport or drill-down-report again but simply activate an already existing tab.
    • HTML Viewer can open links with http(s), file, ftp, smb and afp in a separate window and according to the current system.
  • Main and subreport share the same database connection, if the datasource is identical.

Changed Behavior

  • Summary functions in formulas now accept single values as well. Count and distinctCount now work for range-arrays as well.
  • The report URL parameter “navigation” has been removed, because it is not supported with the new HTML export format.
  • The report URL parameter “sql” has been removed.
  • DatePart(“ww”,x) is now compatible with the calendar of different locales. Before it was compatible with Crystal Reports.
  • Subreport on demand links will only be created on a client server request.

Fixed Bugs

  • If the URL contained the promptonrefresh parameter, an HTML prompt dialog would not correctly submit its parameters.
  • Field formatting issues using “suppress if zero” in combinated with a “fixed currency symbol” has occurred.
  • IllegalArgumentException with number formulas for Java Beans occurred, if the target Java Type of the Java Beans was double. This could occur for example with the Gauge Bean.
  • In rare cases, a background color of subreport elements was not or only once displayed, if only one background color was used for the report elements and if a background color has been set for at least one report section.
  • IndexOutOfBoundsException occurred during processing the record selection formula.
  • Formula function “PreviousIsNull” has returned null instead of true if it was used for the first data set.
  • A call of method setData(ResultSet) has created a database connection if there was a valid DataSourceConfiguration.
  • Only the first column was added to the report, if MySQL was used and the used stored procedure contains two columns with the same name from different tables.
  • Page Footer was printed in not printable area if the report footer with enabled “Underlay Following Section” did not fit on the page.
  • ReportReaderNet:
    • Various number properties such as “allow field clipping” and others are now read correctly including their property formulas.
    • When non-subreport elements were in the same section as a subreport, Crystal Reports templates were often loaded with warnings such as “Possible errors in subreport…”.
    • The group property “Keep Group Together” was not read correctly from Crystal Reports templates. It was always set to false.
    • Summary fields in Crystal Reports templates which were set to running total fields and had both a “evaluate on change of” setting as well as a “reset on change of” setting lost the “evaluate on change of” setting.
    • Error when using ReportReaderNet with Crystal Reports XI R2 occurred.
    • Error while using ReportReaderNet with Crystal Reports 2011 occurred.
  • Excel export:
    • NullPointerException occurred.
    • If a slash was used as delimiter in a custom date format then this date was displayed with the locale default delimiter.
  • It could occur a problem during the creation of database connection to a Apache Derby database.
  • Exception occurred, if a report was added as subreport that contains lines and/or boxes spanning mutliple sections and starts in the page header or ends in the page footer.
  • Line spanning multiple sections was missing on a page, if it ends in the group footer and there was no group footer on that page.
  • Dead locks on MacOS occurred during start of the i-net Designer or report server.
  • PDF export:
    • Title and subject from document properties were not written into created PDF file.
    • An picture in the exported PDF file was corrupt, if it's location was set with picture property “Dynamic Image Location”.
    • Unicode mapping for multibyte characters was incorrect.
  • RecordSelection optimization for subreports - this will now work completely equals to the main report. Fixed removal of Prompt placeholders in case getSQL was called on the engine before it was executed.
  • Data export: Some data in group footer sections were incorrect.
  • Excel export: Because of some static text in subreports, it could occur that Excel opens an exported .xls files in the protected view.
  • A database connection leak on calling SQLValueProvider.getDefaultValues() without calling Engine.execute().
  • Text export: Embedded Fonts were ignored for calculating the metrix of the TXT export.
  • The Java viewer does not display characters, if the used font can not be embedded but was added to the font path.
  • The error message “The failure cause for the report could not be returned.” was displayed. Now, the correct error message will be displayed.
  • HTML export:
    • Clicking the reload button in an HTML output of a report with prompts caused the originally entered prompt values to be lost in some cases.
    • Elements in the crosstab description section were displayed outside of the table, if Internet Explorer was used.
  • ReportReader has read all special fields as print date, if Crystal Reports 2011 rpt file was used.

API Changes

  • Removed Deprecated Classes, Methods and Constants
    • com.inet.report.ChartFormat
      • setLocale (Locale)
    • com.inet.report.CrossTabDescriptionSection
      • addLine( int, int, int, int)
    • com.inet.report.Datasource
      • setup(String)
      • setup(DataSourceConfiguration)
    • com.inet.report.Element
      • copyXML2()
    • com.inet.report.RDC
      • loadEngine(File, BufferedReader)
      • loadEngine(File, BufferedReader, Properties)
      • loadEngine(File, BufferedReader, String)

i-net Clear Reports viewer

New Features / Improvements

  • The print and export button is disabled, if the report is suppressed because of no rows. It is possible to get this state using Java viewer API.

Fixed Bugs

  • ViewerException “Wrong order of nodes” occurred with hierarchical grouping and a second group in the report.
  • In field elements with HTML content, selecting and copying text from within the viewer caused extraneous spaces to be inserted before and after punctuation symbols. These spaces no longer are added.

API Changes

  • Removed Deprecated Classes, Methods and Constants
    • com.inet.viewer.ReportViewer
      • setCustomPromptEditor(String, CustomPromptEditor)
  • com.inet.viewer.SwingReportViewer
    • setCustomPromptEditor(String, CustomPromptEditor)

i-net Designer

New Features / Improvements

  • SQL Editor:
    • It is now possible to use formula with evaluation time “BeforeReadingRecords” in the SQL editor of the Database Wizard.
    • Now it is possible to use Strings prompts without quoting on any place of the SQL.
  • Crosstab properties has been improved.

Changed Behavior

  • If the page limit is exceeded then a warning page is added to the end of the report.
  • The page layout dialog no longer adapts the paper-orientation to the height/width of the paper for userdefined format.
  • Designer file chooser now only connects to repository server if the user clicks on the corresponding node.

Fixed Bugs

  • SQL Editor:
    • String parameter fields was not quoted in SQL query.
    • Property “Quote string parameters” was not enabled by default in remote designer.
  • Several bugs in Java Bean properties occurred.
    • The wrong (default) entry in a combo box of the Java Bean properties dialog was selected.
    • The JavaBean editor of the designer has used the same editor for the same class and has ignored different editors for different properties of the same type.
  • Saving a report containing a Java Bean has lost all settings of this Java Bean if the class (jar file) of this Java Bean was not in the classpath.
  • The following exception has sometimes occurred while opening a Crystal Reports rpt file: “[Report Reader] Could not convert report <temp-dir>designer<…>.rpt - problem with ReportReader. Restarting ReportReader. Reason: ERROR can not find a report file.”

Remote Designer

Fixed Bugs

  • It could occur that the library of a JavaBean, like JBarcodeBean, was loaded after a report using this JavaBean was loaded for the first time.

Report Repository

New Features / Improvements

  • Repository credentials are now optional. If they are needed for the connection, they will be requested at runtime (including an option to store the credentials permanently)

Configuration Manager

New Features / Improvements

  • Configuration Manager module has been reworked.
  • Performance improvements while starting the Configuration Manager.
  • Property “Scheduler Cache Filter” has been renamed to “Restrict report execution to the Scheduler”.
  • Command line parameter “-clearreports.preferredconfig” added.

Changed Behavior

  • The new remote interface moduls for scheduler and configuration won't work with Internet Explorer 6, 7 or 8.

Fixed Bugs

  • A single negative IP filter caused all IP addresses to be blocked. Now, if only negative IP filters are entered, all IP addresses EXCEPT the ones entered as negative filters will be allowed.

Scheduler

Changed Behavior

  • The old web GUI of the scheduler has been replaced with a new scheduler modul for remote interface.
  • The URL parameter “init=scheduler” is not supported anymore. You can use the following URL to open the scheduler remote module: http://<servername>:<port>[/<servlet-context>]/remote/scheduler.
  • “Cache Action” and property “Cache Filter Enabled” has been removed. Use file action to save the report as file and then request this file.
  • The Html export in the Scheduler now supports the attachment of the date and/or time to the filename.

Ad Hoc Reporting

New Features / Improvements

  • Ad hoc reporting now allows to download the current report as an i-net Clear Reports report file (.rpt).
  • Ad hoc reporting now allows to export and import save points and share them across different accounts.

Changed Behavior

  • The performance of the Visual Database Wizard for reports with very large counts of tables (approx. > 30) has been improved.
  • The rendering of reports in Ad-Hoc(Swing and Web) can now be stopped at any time.

Setup

Changed Behavior

  • Oracle OC4J application server not supported anymore. It supports only Java 5.
  • Standalone Configuration & Recovery Manager will be installed with i-net Clear Reports.

.Net Edition

New Features / Improvements

  • .Net report viewer sample added to the samples folder: “<install-dir>clientdocumentationsamplesviewer_.net”.

Fixed Bugs

  • On 64-bit machines, i-net Clear Reports .NET was incorrectly installed in the “Program Files (x86)” folder.
 

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