i-net Clear Reports

Changes in Release 7.1

i-net Crystal-Clear runtime

New features

  • New: “Glyph orientation” as a property for text elements. This causes each individual character to be rotated according to the setting chosen. Combined with text rotation, this makes it possible to have vertical text display in reports, for example for traditional Chinese reports. This can be done by setting text rotation to 270° and glyph orientation to “LEFT”.
  • New: Text interpretation “Advanced HTML” added. It supports tables and css in text displayed in a field.
  • Database Connection:
    • New: Property “validationQuery” was added to DataSourceConfiguration which allows to specify a SQL statement which should be used to validate the database connection. By default no value is set for this property as java.sql.Connection.isClosed() is used to validate the connection only.
  • New: Function “translate” with 2 parameters: text to translate, array with values to replace placeholders in the text.
  • New: Lower margin and upper margin now calculated relative to the distance between two gridlines. This may result in a smaller margin between axis and chart.
  • New: “Prompting text” and “Description” of the prompt default values can be translated using a Resource Bundle (see sample multi_Language_Reports in the i-net Crystal-Clear documentation).
  • New: Email Request Handler (init=email).
  • The property “PromptBehavior” has been added. It defines under which cases the prompt dialog is to be shown, depending on whether or not default values are to be viewed as set values.

Fixed bugs

  • The property formula for “date time order” was not read properly and so did not have any effect.
  • Requesting a report with “init=svg” did not show an error page if rendering of the report failed.
  • Database Connection:
    • Engine.setData(ResultSet) can handle columns with the same name (of different tables) now if the meta data of the JDBC driver returns the table name for these columns.
    • Oracle functions did not work with the original Oracle JDBC driver.
  • Due to a bug in version 6.5 rendering of wmf encoded images produced poor quality outputs.
  • Merging two sections when the bottom section had a line or a box in it caused strange problems in the rendering of the line or box.
  • Datasource: Cached (already used) datasources have not been reloaded before execution. Therefore changed entries, like password, has not been used.
  • Function “StrCmp” has not sorted all characters alphabetically, e.g. 'a', 'b', 'ä' instead of 'a','ä', 'b'.
  • IllegalArgumentException occurred if a polar chart with 3 groups was used.
  • Drill-Down does not work if the group name contains '&' or '='.
  • Formula function 'min' produced error results if there are some records with NULL.
  • Japanese / Chinese: Word Wrap was not possible between characters. It was possible after or before white spaces, only.
  • Sorting and grouping was not case sensitive. Now it is configurable in crystalclear.properties with property collation.

API changes

  • The method Area.indexOf() return the correct value for the first 5 (default) Areas now instead to throw an exception.

i-net Crystal-Clear - Java Viewer

New features

  • Zoom level can be changed with mouse wheel when Ctrl-key is pressed.
  • Prompt request dialog will be displayed if there is at least for one parameter field no value specified using API, report URL or prompt request dialog.
    To get the behavior of version 6.5 (or earlier) you can use the property “PromptBehavior” in the configuration tool.

Fixed bugs

  • The zoom levels “Page Width”, “Page Height” and “Whole Page” not translated.
  • There was a bug in closeReportView(int) which could cause an ArrayIndexOutOfBoundsException if the last report was closed.
  • closeAllReportViews() caused the toolbar to be removed as well.
  • Checkboxes in the search dialog does not show if they have the focus. Useful for working with keyboard.
  • MemoryBar not visible in Drill-Down or sub-report tab.
  • Chinese characters sometimes not correct selected.
  • Method Chart.setStyle(int style) not accepted PIE3D_MULTIPLE_STYLE and PIE3D_PROPORTIONAL_MULTIPLE_STYLE as valid styles.
  • Sometimes a wrong current page number was displayed in the toolbar when “Double Page” view and different zoom levels were used.
  • OutOfMemoryError has occurred if multiple large reports were displayed.
  • There was a thread-related error which caused an IndexOutOfBoundsException while moving the mouse over a tooltip.
  • Page count problem with dynamic zoom (e.g. page width) and continuous or continuous double view has occurred.
  • NullPointerException has occurred if the searching string includes character '%'.

API changes

  • The ViewerContext interface has been extended by two methods “export” and “print”, which are used when the user exports or prints a report. Also, the default implementation of ViewerContext, SwingViewerContext, has been made public and can now be extended.

i-net SchedulerXML

Fixed bugs

  • Rendered reports could be lost for Email/File/Ftp action if memory cache was used. Although this fix we recommend to use hard disk or database cache with i-net SchedulerXML.
  • Chinese characters could get scrambled in the web configuration tool. (e.g. as task name)
  • The scheduler could not have been activated nor deactivated if the web configuration tool was started with Chinese locale.

i-net DesignerXML

Fixed bugs

  • Applying changes to a multi selection did change all property formulas of the selected elements to be set to Crystal syntax.
  • Changing the currency type was possible although the number field should use system default format.
  • The parameter dialog now allows to set default values with seconds for time and datetime types.
  • The value of a FieldElement could not be set as Hyperlink.
  • The group dialog did not allow hierarchical grouping for date/time and date time fields.
  • Adding/changing a SQLExpression field did remove unused summary fields.
  • Visual Database Wizard: After clicking on “To SQL” button the wrong dialog was displayed. It was not possible to select a datasource.
  • Eclipse plug-in does not find crystalclear.properties.
  • The sub-report name or the sub-report on demand link was displayed with the wrong font size in the design view.
  • ConcurrentModificationException occurred if copy / paste was often used.
  • It was not possible to remove an unused connection with the “remove” button as it was disabled.
  • Underline was deselected in properties dialog although element has property underline set to true.
  • Color of the font color button in the toolbar changes each time a field with a different color was selected.

i-net software strives to provide accurate product documentation. Please give us your feedback using the form below.
NOTE: This form is for documentation feedback only. For technical assistance, please send an email to clearreports@inetsoftware.de.

 

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