i-net Crystal-Clear

Changes in Release 7.0

i‑net Crystal-Clear runtime

New features

  • New: i‑net Crystal-Clear Data Sources used to configure database connections.
  • Database Connection:
    • New: A new way to define connections. You can define data sources that are based on JDBC drivers and set general and JDBC driver specific properties. Such data sources can be reused in every report, making report creation easier.
    • New: MetaData cache. This cache will store execution information about database objects so that the amount of meta data queries can be reduced and the performance will be increased.
  • New: “Keep Together” for areas.
  • Crosstab:
    • New: Property formula to enable dynamic cross tab settings.
    • New: Description section in the upper left corner to add additional information to the cross tab.
  • New: Transparent images supported in Java Viewer, HTM and PDF Export.
  • Chart:
    • Using JFreeChart library to render charts.
    • New: Chart types Gantt and multiple pie charts.
    • New: Group name field and formula for chart groups.
    • New: Custom formatting properties on data axis of chart and showed labels.
    • New: Setting of chart titles color and rotating of data axis labels.
    • New: Transparent charts.
  • Currency formatting: The property “currency separator” was added so that a custom string can be set as separator between the numeric value and the currency symbol.
  • Excel export:
    • Create .xls files with defined page format settings (like paper orientation and margins).
    • Lines and boxes supported.
  • Support for Java SE 6.0 added.

Fixed bugs

  • The formula function bytesFromFile() did not work for URLs passed as parameter.
  • Multi Section elements(Line, Box) were lost on merging Sections, if the merged Section was the end Section of multi Section elements.
  • User defined formulas (UDF) did cause a NullPointerException if multiple formula expander classes were defined in the crystalclear.properties file and at least one class could not be found in classpath.
  • Bug in converting the record selection formula to a SELECT statement when using boolean constants “true” and “false” in combination with prompt fields.
  • The mailing labels was placed wrong if there was a group in the report.
  • There were various formula bugs regarding the equals operator with boolean constants or with operands of differing value types.
  • “Suppress if duplicated” has suppressed duplicated field values on multiple pages, if “Keep Together” was enabled for group or area.
  • When using Engine.setData() sql expression fields were not recognized.

API changes

  • Methods, deprecated in versions earlier 5.0 has been removed.
  • Renamed methods (old methods remain as deprecated)
    • class Area:
      • getAtBottomOfPage() replaced by isAtBottomOfPage()
      • getNewPageAfter() replaced by isNewPageAfter()
      • getNewPageBefore() replaced by isNewPageBefore()
      • getResetPageNumber() replaced by isResetPageNumber()
      • getSuppressOnDrillDown() replaced by isSuppressOnDrillDown()
    • interface BorderProperties:
      • getTightHorizontal() replaced by isTightHorizontal()
    • interface FontProperties:
      • getBold() replaced by isBold()
      • getItalic() replaced by isItalic()
      • getStrikeout()() replaced by isStrikeout()
      • getUnderline() replaced by isUnderline()
    • interface LineProperties:
      • getExtendToBottomOfSectionWhenPrinting() replaced by isExtendToBottomOfSectionWhenPrinting()
    • interface PictureProperties:
      • getCanShrink() replaced by isCanShrink()
    • class ReportCacheKey:
      • getRequestScheduleInProcessReport() replaced by isRequestScheduleInProcessReport()
    • class ReportProperties:
      • getAcrossThenDown() replaced by isAcrossThenDown()
      • getDistinct() replaced by isDistinct()
      • getFormatGroupsWithMultipleColumn() replaced by isFormatGroupsWithMultipleColumn()
    • interface SubreportProperties:
      • getOnDemand() replaced by isOnDemand()
    • interface ValueProperties:
      • getAllowFieldClipping() replaced by isAllowFieldClipping()
      • getReverseSignForDisplay() replaced by isReverseSignForDisplay()
    • class Chart, additional methods:
      • getDataAxisFormatProperties(), setDataAxisFormatProperties(ChartFormatProperties dataAxisFormatProperties)
      • getItemLabelFormatProperties(), setItemLabelFormatProperties(ChartFormatProperties itemLabelFormatProperties)
      • getFontLegend(), setFontLegend(Font font)
      • getTextFontColor(int textFontCode), setTextFontColor(int textFontCode, int ccColor)
      • getTextRotationXAxis(), setTextRotationXAxis(double arc)
      • getUseTransparency(), setUseTransparency(boolean newValue)
  • removed API:
    • Area.getDropShadow(), Area.getDropShadowFormula, Area.setDropShadow(boolean), Area.setDropShadowFormula(FormulaField)
    • Element.getIsOncePerReport() and Element.setIsOncePerReport()

i‑net Crystal-Clear - Java Viewer

New features

  • New: Look and Feel
  • New: Modular, highly customizable structure with new API
  • New: Multiple reports can be displayed in tabs with the same viewer
  • New: Exporting and/or printing reports is possible at the same time.
  • New: Multiple Pages View (1, 2, or up to all pages of the report on the screen at the same time).
  • New: Continuous View - Scrolling down through all report pages using the mouse wheel or scroll bar.
  • New: Progress Bars show exact extent of progresses such as printing or export.
  • New: Text selection from the report, copying to the clipboard supported.
  • New: Image snapshot from the report, copying the snapshot to the clipboard.
  • New: Search the complete report using options such as “case sensitive”, “regular expression” or “whole word”, highlight a search result within the report.
  • New: Transparent images supported.
  • New: Automatic Zoom Types “Page Width”, “Page Height”, and “Whole Page”
  • New: TTF Font embedding supported - only the needed parts of the font are transmitted to keep data transfer minimal.
  • Highly improved: prompt dialog with list of prompts on the left, support for multiple default values, prompt descriptions, range values, etc.
  • Improved: Layout of text, font auto scaling
  • Improved: export dialog.
  • Support for Java SE 6.0 added.

API changes

  • New Java Viewer API
  • All major components such as the toolbar or status bar are modular and can be exchanged for own components, or customized and expanded on.
  • Sample class “ReportViewerBeanWrapper” (in Samples) demonstrates how the old features of ReportViewerBean can be mapped to the new SwingReportViewer.

i‑net DesignerXML

New features

  • New: Report Wizard for simple and quick creation of tabular reports.
  • New: Dialogs to configure i‑net Crystal-Clear Data Sources.
  • New: Text field will be added as a column heading for each database field that will be dragged from the Field Browser into the report design.
  • New: Prompt dialog with improved functionality (multiple default values, prompt description …).
  • New: Look and feel of the dialogs.
  • New: Export formats can be enabled / disabled for each report.
  • New: Group Tree can be enabled / disabled for each report.
  • New: Printing and/or Export can be enabled / disabled for each report.
  • New: Group Property “Also within Group Footer”.
  • New: Column labels or column description will be shown if defined in database.
  • New: Editing of text fields new implemented.
  • New: Report structure view show all elements of the report and in which section they are used.
  • New: Sub report links dialog: You can now select an existing prompt of the sub report to be linked to the main report.
  • Support for Java SE 6.0 added.

Fixed bugs

  • The page layout dialog did not show the correct width/height for landscape reports.
  • The settings for the properties of JavaBeans could be lost.
  • Section heights of inserted sub reports had been overwritten with the default section heights
  • A report could not be saved if a previous save was not successful because of an invalid file name.
  • The documentation of strcmp was erroneous - strcmp returns a number, not a boolean.
  • Not all pictures were visible after loading of a report.

API changes

  • Signature of DesignerDataModel.openParameterDialog() changed to not return a PromptField anymore.

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.