i-net Crystal-Clear

Changes in Current Release 8.0

i-net Crystal-Clear runtime

New Features / Improvements

  • Chart2 API replace the old Chart API. Chart2 and all classes in the package “com.inet.report.chart” and in it's sub packages are members of the new Chart2 API.
  • API: Time properties now include the ability to set a long, medium, or short default format for the time, instead of having the medium format automatically taken as it was before.
  • Excel export:
    • Time properties “AM/PM Position” and “Base” supported.
    • Date property “Format | Day” supported.
    • Pictures, blobs, Java Beans and charts are now embedded as PNG images in the exported XLS file.
  • PDF export: Creation of signed PDF files.
  • The class com.inet.report.Database now provides more methods which can be overridden to change the communication with the database.
  • Crystal Reports report templates with JDBC / JNDI connections supported.
  • Formula Functions:
    • A new formula function “CurrentDrillDownLevel” was added, which returns a number of which group level the report was drilled down to - 0 if not at all, otherwise the index of the group, 1-based.

Changed Behavior

  • At least Java 5 is required.
  • Boxes across multiple sections are now behind other report elements so that they does not hide other report elements.
  • i-net Crystal-Clear no longer uses a crystalclear.properties file but rather stores its preferences in the Preferences of the system on which it runs, e.g. the Registry in Windows.
  • Excel export: If a Report Title was set then the Report Title plus index is used as sheet name.
  • Because of the new Configuration API, the methods RDC.getConfigurationProperties and RDC.setConfigurationProperties are now deprecated. Instead, you should switch to using the ConfigurationManager and Configuration methods such as Configuration.putAll(Map map).
  • A database field in the Page Header section displays the record of the first visible Detail or Group section. In previous versions the first record was displayed, suppressed or not.
  • Database driver DLL names (e.g. pdssql.dll) replaced by Data Source Configurations that was introduced in version 7.0.

Fixed Bugs

  • Excel export:
    • NumberFormatException occurred if Java 5 (or higher) and a custom number format with BigDecimal values and negative exponents was used.
    • If a report contains a cross-tab and an element on the right side of this cross-tab then the exception “Formatting removed” could occur while opening the export report with Excel.
    • Error while opening exported file in Excel has occurred if brackets were used for the Date property “Day of Week”.
    • Format for Date property “Day of Week” position “Trailing” was incorrect.
    • Property formula for the time properties Hour, Minute, Second, Hour/Min separator and Min/Sec separator was not used.
    • Value “None” has no effect for the Time Property Hour and for the Date Property Month.
    • Empty rows could occur sometimes because positions of elements containing text were estimated on the basis of the font height instead of the actual element height.
    • Logical fonts (Serif, SansSerif, Monospaced) were only supported for report elements containing static text, e.g. labels. Now, they are also supported for field elements such as number and date fields.
  • Postscript export: Boxes with the same size but different border width was displayed with a different size.
  • RTF export:
    • A border from a text field was used for an image although there was no border set for the image.
    • Positioning for boxes with different border widths was incorrect.
  • Reports using stored procedures could have failed if used with InterBase or Oracle databases.
  • Wrong record selection formula was executed if drill-down was used and the record selection formulas contained comments.
  • Formula Functions:
    • The ToText function with the parameter combination (Number,String,Number,String,String) which interprets the given number with provided formatting pattern, number of decimal places, thousands separator character, and decimal point character, was not accepted or correctly evaluated.
    • The function BytesFromFile was not able to open files with the path syntax “c:\…”
    • The function propercase did not handle the ß-character correctly.
    • The return value type of an assignment operation to an array index (e.g. a[1]:=“x”) was the variable's value type. Now, the value type of the assigned value will be returned.
  • When using setSQL, there could be the error “Please delete the referencing fields first.” if columns from the query were used in the record selection formula and the property ignoreFiltering was set to false.
  • Adding two identical stored procedures with parameters to a report caused a problem with incorrect referencing of the parameter fields at run-time.
  • Lines and boxes across multiple sections starting in the Report Header area were drawn into the first instance of the details section, only.
  • Lines with enabled property “Extend to Bottom of Section” were displayed as point in an above section, if the section containing this line was suppressed.
  • Sub-reports that are design larger as a page was not displayed in repeated sections.
  • The property “log.dateformat” was not regarded for log file creation.
  • Multi-section lines starting in the report header section only went through the page header on page 1. They did not go through the page header sections on any following pages.
    Unless the value of the property “Compatibility Level” is set to a version before 8.0, the lines will now go through all page header sections.

API Changes

  • Added Classes
    • com.inet.report.config
      • Configuration
      • ConfigurationManager
      • LicenseKeyInfo
    • com.inet.report
      • Chart2
    • com.inet.report.chart
      • All classes in this package and in it's sub packages.
  • Added Methods
    • com.inet.report.cache.Cache
      • getFailureCause(ReportCacheKey)
    • com.inet.report.ParagraphProperties
      • getFirstLineIndentFormula()
      • setFirstLineIndentFormula(FormulaField)
      • getLeftIndentFormula()
      • setLeftIndentFormula(FormulaField)
      • getLineSpacingAbsoluteFormula()
      • setLineSpacingAbsoluteFormula(FormulaField)
      • getLineSpacingRelativeFormula()
      • setLineSpacingRelativeFormula(FormulaField)
      • getRightIndentFormula()
      • setRightIndentFormula(FormulaField)
    • com.inet.report.Section
      • addChart2(ChartStyle,int,int,int,int)
    • com.inet.report.TextProperties
      • getGlyphOrientationFormula()
      • setGlyphOrientationFormula(FormulaField)
      • getTextRotationFormula()
      • setTextRotationFormula(FormulaField)
    • com.inet.report.ValueProperties
      • getDateFormatType()
      • setDateFormatType(int)
      • getDateFormatTypeFormula()
      • setDateFormatTypeFormula(FormulaField)
      • getTimeFormatType()
      • setTimeFormatType(int)
      • getTimeFormatTypeFormula()
      • setTimeFormatTypeFormula(FormulaField)
    • com.inet.viewer.ReportView
      • getDefaultAttributeSet(int,int)
      • print(PrinterJob,PrintRequestAttributeSet)
    • com.inet.viewer.SwingReportView
      • showPrintDialog(Component,PrinterJob,HashPrintRequestAttributeSet)
  • Methods and Constants deprecated as of Version 8
    • com.inet.designer.DesignerDataModel
      • openChartDialog(Chart)
    • com.inet.report.AbstractValueElement
      • getDateWindowsDefaultType()
      • setDateWindowsDefaultType(int)
      • getDateWindowsDefaultTypeFormula()
      • setDateWindowsDefaultTypeFormula(FormulaField)
      • setUseSystemDefaultFormat(boolean)
      • getUseSystemDefaultFormat()
      • setUseSystemDefaultFormatFormula(FormulaField)
      • getUseSystemDefaultFormatFormula()
    • com.inet.report.Chart
      • all members of this class
    • com.inet.report.ChartFormatProperties
      • getDateWindowsDefaultType()
      • setDateWindowsDefaultType(int)
      • getDateWindowsDefaultTypeFormula()
      • setDateWindowsDefaultTypeFormula(FormulaField)
      • setUseSystemDefaultFormat(boolean)
      • getUseSystemDefaultFormat()
      • setUseSystemDefaultFormatFormula(FormulaField)
      • getUseSystemDefaultFormatFormula()
    • com.inet.report.DatabaseTables
      • createDatasource(String,String,String,String,String,String)
      • createDatasource(String,String,String,String)
    • com.inet.report.Datasource
      • dll_connectionByConfiguration
      • getDll()
      • setDll(String)
    • com.inet.report.Element
      • getHyperlinkType()
      • setHyperlinkType(int)
    • com.inet.report.Engine
      • setPath(String, String, String)
      • setPath(java.net.URL)
      • getGroupTree(int, int)
    • com.inet.report.GroupTree
      • getData(byte[],int,int)
      • createErrorTree(boolean)
    • com.inet.report.HyperlinkProperties
      • NO_HYPERLINK
      • FILE_HYPERLINK
      • WEBSITE_HYPERLINK
      • EMAIL_HYPERLINK
      • FIELD_VALUE_HYPERLINK
      • getHyperlinkType()
      • setHyperlinkType(int)
    • com.inet.report.RDC
      • getCrystalClearPropertyPath()
      • setConfigurationProperties(Properties)
      • getConfigurationProperties()
    • com.inet.report.Section
      • addChart(int, int, int, int, int)
    • com.inet.report.ValueProperties
      • USE_WINDOWS_LONG_DATE
      • USE_WINDOWS_SHORT_DATE
      • NOT_USING_WINDOWS_DEFAULTS
      • getDateWindowsDefaultType()
      • setDateWindowsDefaultType(int)
      • getDateWindowsDefaultTypeFormula()
      • setDateWindowsDefaultTypeFormula(FormulaField)
      • setUseSystemDefaultFormat(boolean)
      • getUseSystemDefaultFormat()
      • setUseSystemDefaultFormatFormula(FormulaField)
      • getUseSystemDefaultFormatFormula()
    • com.inet.viewer.SwingViewerContext
      • SwingViewerContext()
  • Moved Methods
    • com.inet.report.Element
      • getManualFormatFormula() moved to AbstractValueElement.getManualFormatFormula()
      • setManualFormatFormula(FormulaField) moved to AbstractValueElement.setManualFormatFormula(FormulaField)
  • Removed Deprecated Methods and Constants
    • com.inet.report.Area
      • setSectionWillbePrinted(int)
      • getSectionWillBePrinted()
    • com.inet.report.Chart
      • setXAxisSource(Field)
      • getXAxisSource()
    • com.inet.report.CrossTab
      • dropColumn()
    • com.inet.report.DatabaseTables
      • *_JOIN
      • addJoin(String , String , String , String , int )
    • com.inet.report.Engine
      • setPath(String)
      • setPath(String, String)
    • com.inet.report.Fields
      • getGroupSortField(int)
      • getGroupSortFieldsCount()
    • com.inet.report.FormulaField
      • getBasicSyntax()
      • setBasicSyntax(boolean)
    • com.inet.report.Group
      • setKeepGroupTogether(boolean)
      • getKeepGroupTogether()
    • com.inet.report.RDC
      • gc(Engine)
    • com.inet.report.ReportProperties
      • getPageWidth()
      • setPageWidth(int)
    • com.inet.report.ReportServletJSP
      • props

i-net Crystal-Clear - Java Viewer

New Features / Improvements

  • The Java Viewer now has a context menu available if the clipboard copy function is enabled. This menu contains the items “Copy” and “Clear Selection” - copying used to only be accessible through the keyboard shortcut “Ctrl+C”.

Fixed Bugs

  • The class ReportViewChangeListener was not visible in the file: CC-Viewer.jar.
  • The export drop down button could be active even if all exporting was disabled for a certain report.
  • While using embedded fonts, certain letters could (in rare cases) disappear from the displayed text in the report when reloading rather than refreshing the report (such as when previewing the report in the designer). This occurred mainly in the designer, and only if the report changed in such a way that a font changed and less letters were needed.
  • Loading a jar file which was not a Java Report Archive did not show a readable error message.
  • Sub-report prompts were not shown as such. They now again show the name of the sub-report in parentheses behind the prompt name in the viewer's parameter request dialog.
  • The prompt dialog had graphical glitches if some prompts had a description while others did not.
  • When closing a window which held a ReportViewer, the ReportViewer would close all report views when getting the “windowClosing” event. However, if after this event the window was not closed after all (i.e. if the window close was canceled), the Viewer had already closed its report views too soon, leading to a grey viewer panel. Instead the Viewer now listens for a windowClosed event to then remove its views.
  • A memory leak in the Viewer was fixed when closing and opening many viewers from within the same application.
  • In rare cases in the report designer with multiple pages view, the report viewer could end up showing white pages only until the report was refreshed.
  • For multi-column reports, an empty group tree was shown in the viewer. Now the (empty) group tree is no longer shown.

API Changes

  • Added Methods
    • ReportView.getDefaultAttributeSet(int, int)
    • ReportView.print(PrinterJob, PrintRequestAttributeSet)
    • SwingReportView.print(PrinterJob, PrintRequestAttributeSet)
    • SwingReportView.showPrintDialog(Component, PrinterJob, HashPrintRequestAttributeSet)
  • Methods deprecated as of Version 8
    • SwingViewerContext.SwingViewerContext()

i-net DesignerXML

New Features / Improvements

  • New implementation of the dialog: “Chart Properties”.
  • The font list has been made more user friendly - it is now possible to enter a font name, and the font name will be auto-completed, also the font list will jump to the selection.
  • Data Source Manager:
    • It is now possible to set a Database class for any non-user-defined data source.
    • The System or User tab will be suppressed if the scope is currently not accessible.
  • Fields Browser now supports duplicating and renaming of Formula Fields, Parameter Fields, SQL Expression Fields and Summary Fields.
  • Date, time, date time, and number properties all now have the ability to have various system default types set individually. It is for example now possible to set a LONG default type for the date part and a SHORT default type for the time part of a date time field. It is also now possible to, for example, choose a CURRENCY or PERCENT system default format for number fields.
  • New API methods to set the properties glyphOrientation and textRotation by formula have been added. These formulas can be set by i-net DesignerXML also.
  • The cross-tab data dialog accepts Formula fields as second Summary operation field.

Changed Behavior

  • At least Java 5 is required.
  • Configuration Tool replaced by Configuration Manager (see menu item: “i-net Crystal-Clear Options”).
    The Configuration Manager no longer uses a crystalclear.properties file but rather stores its preferences in the Preferences of the system on which it runs, e.g. the Registry in Windows.
  • In the dialog “Connection Manager” it is possible to select Data Source Configurations, only.

Fixed Bugs

  • Under rare circumstances, the Report Wizard could not be closed by pressing OK.
  • Different line breaks (\n and \r\n) has been used in the XML code of the rpt file.
    Now just '\n' is used.
  • Pasting RTF into the report did reduce the font size of the pasted text.
  • Changing the data source of a report could have caused an incorrect error message saying that the tables of the report could not be used anymore.
  • Report Wizard:
    • Various small GUI issues were fixed.
    • Invalid database connections could be ignored and/or cause incorrect error messages to be displayed in the Report Wizard.
    • When creating a report with two database connections with the Report Wizard, choosing a field from the second connection caused an error message “There is no table source defined.”
  • It was possible to open the “Page Layout” dialog for an embedded sub-report in the “File” menu or in the popup menu. Changing Page Layout is supported for sub-reports on demand, only.
  • Cross-tab data dialog does not accepts Formula fields as second Summary operation field that is necessary for summary operations like “Weighted Average”.
  • Parameter Field Properties:
    • Date time ranges for parameter fields could be specified with accuracy down to seconds, but the time was then rounded to the minute when running the report.
    • When changing a parameter field type to multiple and then back to single, there could be a side effect for certain formulas such as ToText.
    • It was possible to set decimal numbers for string length limits for parameter fields.
    • Setting identical values for the minimum and maximum length of a prompt value caused an exception when running the report.
  • Visual Database Wizard:
    • Various GUI problems were fixed, e.g. the size of the dialog were changed after the Refresh button was pressed.
    • When using the “to SQL” option in the Visual Database Wizard, some database fields could be duplicated, leading to side effects such as not being able to later on remove the SQL command from the report, even if no report elements referenced the command any more.
    • Invalid database connections could be ignored and/or cause incorrect error messages to be displayed in the report wizard.
    • In rare cases, editing an SQL command could lead to columns being dropped from the table source.
    • When entering incorrect SQL in the SQL editor, and then pressing cancel, the incorrect SQL was silently applied to the query.
    • When the user name for a database connection was null, it led to a problem in the Visual Database Wizard that the connection was not able to be edited.
  • SQL Editor:
    • If an incorrect alias was provided for a new command, the SQL editor would attempt to quote the name, which would in turn lead to a different error.
    • When exporting an SQL query, the SQL Editor would replace an old file without warning.

API Changes

  • Methods deprecated as of Version 8
    • DesignerDataModel.openChartDialog(Chart)

i-net Crystal-Clear Setup

New Features / Improvements

  • It is possible to import existing crystalclear.properties into a new configuration.

Changed Behavior

  • At least Java 5 is required.
  • Does not install JavaClient.jar (classic Java Viewer) anymore.
  • Application Server versions without Java 5 support not available.
  • Designer installation: crystalclear/CC-Viewer.jar will be installed instead of JavaClientSwing.jar.
  • The directory “crystalclear-php” will be created in the installation directory instead of the current directory.

Fixed Bugs

  • Empty message boxes have occurred sometimes during installation.
  • Uninstaller can not uninstall files on Windows Vista, if it does not run as administrator.

i-net Crystal-Clear Scheduler

Fixed Bugs

  • E-mail actions of two simultaneously executed task could have overwritten their attached zip archive containing rendered reports.
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.