i-net Crystal-Clear

Changes in Release 6.0.01

i‑net Crystal-Clear runtime

New features

  • New setup.
  • Scheduling of reports (i‑net Crystal-Clear Plus).
  • Sending exported reports per email (part of Scheduling).
  • Text Interpretation (Rich Text and HTML) for string and memo (database) fields now supported.
  • “Keep Object Together” now supported (text & field objects).
  • JavaBeans (e.g. progress bar or calendar) as design elements now supported.
  • Configuration tool: Available IP addresses are displayed in the dialog “General Options”.
  • Excel export: Support for cross tabs in xls files has been added.
  • New export format: TXT.
  • Database Connection:
    • Support added for:
      • Multiple databases in one report.
      • Multiple stored procedures / tables in one report.
      • Support of SQL commands, that can be used like a view.
    • The connection properties host/catalog/schema/user/password/url can be set for each data source in the main report and in the sub reports separately per URL. For more information please have a look at “Feature Overview”→“URL Parameters”
  • “New Page After” and “New Page Before” is now supported within sub reports. This causes a page break within the main report. The page headers and footers are still displayed for each page (unless suppressed).
  • New formula function: “FileFormat” - returns the export format as a string.
  • “ChrW” and “AscW” - each with the same functionality as “Chr” and “Asc” have been added to the formula functions.
  • New report property: “Convert null value to default” has been added.
  • New special field: Record Count.
  • Various new chart features:
    • Top N sorting for the groups
    • Specified sort order for the groups
    • Original sort order
    • Ascending and descending order option
    • It is now possible to manually set the step-size for the y-axis

Fixed bugs

  • Charts:
    • Now it is possible to design black and white charts on a white background because the first used color is black instead of white.
  • Excel export: Multiple bugs with multi column and mailing label reports have been fixed.
  • Database Connection:
    • Support of column alias names ending with a white space.
    • If the joins formed a cycle, one of the joins was ignored. Now the linking condition of that join will be appended to the join syntax. In the case of a multiple data source report, the join will be checked after fetching the data from the database server.
    • The formula function “currentDate” returned a wrong month.
    • Only Informix database with stored procedure: A NullPointerException caused by an Informix JDBC driver bug will be avoided now.
    • Support for Informix stored procedures with “IBM Informix JDBC Driver for IBM Informix Dynamic Server”. The SP parameter needs to be set with the URL parameter “sproc<NumberOfInputParameter>”. Setting the parameter with “prompt<PromptName>” is not possible because the driver don't make available the parameter name.
    • A bug that the data of clob columns was not read properly has been fixed.
  • Lines and boxes from page footer to the report footer was repeated if the report footer span over multiple pages. This means if the line or box should be end in a report footer section on the first report footer page then a line or box was printed on follow report footer pages from page header to the page footer.
  • Memory Cache now deletes timed out reports safe.
  • The flag not “Can Grow” for subreports does not continue the sub report on the next page now.
  • Suppressed multi section lines and boxes that begins in a suppressed section was printed.
  • The background of a subreport with “can grow” can be to large if in the subreport has a group with “group keep together”. Now the background and border of the subreport is correct.
  • A bug with join link type Left and LeftEqual by joining on i‑net Crystal-Clear has been fixed.
  • A bug with vertical lines -going from one section to another- and enabled “print at bottom of section” has been fixed. The vertical line was displayed as single point, only.
  • Java Viewer:
    • The title of the message box “Export completed” now displayed internationalized.
    • Bug with round boxes has been fixed: Border for round boxes was displayed also if the border was disabled.
  • Various layout and positioning bugs removed, display of fonts now using floating point sizes and positions rather than rounding up each time.
  • There was a UTFDataFormatException each time a character needing 3 bytes in UTF encoding was stored in a variable - this has been fixed.
  • PDF export: Bug with round boxes has been fixed: background for round boxes without a border was not displayed.
  • RTF export:
    • Lines with “\r” were exported strangely, this has been fixed.
    • Wrong size of the image frames has been corrected, if shadow is enabled.
  • Various “suppress if duplicated” bugs which cause unwanted suppression of certain elements were fixed.
  • A bug with report property “Select distinct records” by sorting on i‑net Crystal-Clear has been fixed.
  • A bug that settings of horizontal and vertical gap for labels were read and saved not properly has been fixed.
  • An ArrayIndexOutOfBoundsException while scanning the prompts of a report via the web configuration tool of the i‑net SchedulerXML has been fixed.
  • A bug that the i‑net SchedulerXML was not running if the web configuration tool was disabled has been fixed.

Behavior Change

  • Viewer: refresh command no more removes all entries of a report from cache, but only entries with the same parameters. Note, the export format parameter will not be regarded in this case.

API changes

  • Database Connection:
    • New public class com.inet.report.Datasource.
    • New public class com.inet.report.TableSource.
  • Cache:
    • New function Cache.getReports() - returns a list of ReportCacheKeys of all reports in Cache.
    • New function Cache.delete(ReportCacheKey key) - removes a specific report from Cache.
  • Engine:
    • New function Engine.getEmbedableFontNames() - returns true type font names for all fonts that can be used for font embedding
    • New function Engine.setConnectionCloseOnFinishing(boolean) - if value is true, i‑net Crystal-Clear don't close the set Connection.

i‑net DesignerXML

New features

  • Eclipse plug-in now available.
  • Now supported:
    • SQL Commands
    • Change/Enter SQL: It is now possible to enter the SQL statement for the complete report or single tables.
    • Change table alias name, and the table's location (which connection, etc.)
    • Change and remove schemas
    • Multiple stored procedures (also mixes with tables) in the same report (without subreports).
    • Multiple connections can be used at once - the tables in the Database Wizard are then color-coded according to their corresponding connection. 
  • Customized JavaBeans (e.g. status bar or calendar) as layout element now supported.
  • The field box has been enhanced to display the table name of a database field too.
  • Selecting a function or keyword in the formula editor and pressing “F1” will bring up the help regarding this keyword.
  • Selecting an element in the design panel and pressing “F4” will bring up the properties dialog of this element.
  • Undo/redo is now available during edit of a formula field/sql expression field.
  • It is possible now to set the exact position of an element with a new dialog.

Fixed bugs

  • A crash that has occurred if Copy & Paste was used with elements that includes property formulas has been fixed.
  • Join types are now visible in the visual database wizard.
  • A bug within a embedded i‑net DesignerXML when hiding the preview tab has been fixed.
  • A bug within a embedded i‑net DesignerXML that fonts were loaded before setting the crystalclear.properties has been fixed.
  • A bug within a embedded i‑net DesignerXML that on close not every report window was removed has been fixed.
  • Can grow has been disabled if a rotation angle is selected.
  • A bug that the name of a formula or sql expression field has disappeared from the dialog and it was impossible to save the formula has been fixed.
  • A bug that the section property “suppress if duplicated” was loaded from the property “suppress” has been fixed.
  • A bug that a subreport could have been inserted into a subreport (which is not allowed) has been fixed.
  • Hierarchical grouping is no longer available if specified order or summary order is selected for a group.
  • A bug that the popup menu element “align” and “resized” were invisible has been fixed.
  • A bug that you were able to create two formula-, prompt-, sql- or summary-fields with the same name has been fixed.
  • If a formula expander class has not been found no error message was displayed.
  • DatabaseWizard: The bug that “show SQL” showed a select statement if a stored procedure is used has been fixed.
  • A bug that the link types “less than” and “less equal than” has been swapped in the in the join dialog has been fixed.
  • Various connection and table source bugs of the Database Wizard were fixed.
  • Mailing Label: Vertical gap was saved as horizontal gap and vice versa.
Documentation Sitemap

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 crystalclear@inetsoftware.de.

 

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