i-net Crystal-Clear Changelog

What's new in i-net Crystal-Clear 10.0.180

Sep 8, 2010
  • This release features a new file chooser and a new i-net Designer configuration dialog.
  • They complete the recent major release in terms of better integration of the powerful repository and ad hoc capabilities in the i‑net Designer, first introduced in i‑net Crystal-Clear 10.
  • This makes the i‑net Designer more powerful and feature-packed than ever, without losing its focus and simplicity.

New in i-net Crystal-Clear 10.0.132 (Jul 29, 2010)

  • New Features / Improvements:
  • URL parameter “timezone” added, to specify the timezone that will be used if “Use Client Timezone” on the server is true.
  • There is now an XML-RPC-based interface to i‑net Crystal-Clear servers. Features to this interfaces will be added in the coming versions, currently however, it is possible to request information about prompts in reports. See the interface InetXmlRpc for further information or contact our support if there is functionality you'd like to see offered by an XML-RPC interface.
  • New web-based report prompt dialog will be displayed when requesting a report with prompts in an export format with the URL parameter “init=< format >”, or when displaying a report with prompts in the web-based Ad Hoc service, or when exporting a report from the web-based Report Repository.
  • The formula functions DateDiff and DateAdd now supporting milliseconds.
  • The directory “crystalclear” has been replaced with directory “client” and the libraries in the directories have been reorganized (See more details about the libraries of i-net Crystal-Clear).
  • The Remote-Interface and the start page now displays the favicon.ico that is located in the client folder of the installation.
  • Single string prompts which do not have any length limit now accept null in addition to an empty string. In the prompt dialog, they have a “no value” option which can be toggled on and off for the string prompt. If you do not want to allow null values for string prompts, you can simply specify 0 as the minimum length of the string - note that in the designer, this is now the default setting when creating new string prompts.
  • HTML export: Positioning of elements (e.g. sub-reports, images etc.) improved.
  • New URL parameter “timezone”.
  • Windows authentication (NTLM) supported (see Login Type property).
  • API:
  • With the new API methods in the class BoxProperties, it is now possible to set the background color of a box dynamically using a formula.
  • There is a new get/set method in Engine called “setMetaProperties”. This allows the user to store arbitrary properts in a report which are stored and loaded when the report is saved and loaded. These properties are not interpreted or used in any way when rendering a report, however they can be useful for design-time settings and such. Note that property keys with the prefix “designer” are reserved for the i‑net Designer.
  • There is a new XML-RPC interface that the server provides. To see a list of the XML-RPC methods, visit the page ”/xmlrpc/” on your i‑net Crystal-Clear server. For version 10.0 there are six methods which can be called:
  • report.getPromptFields( string )
  • report.getSummaryInfo( string )
  • repository.listResources( string )
  • repository.listFolders( string )
  • server.getVersion()
  • server.getJavaVersion().
  • Changed Behavior:
  • The cluster feature of i‑net Crystal-Clear Plus has been removed. Operating system or application server cluster can be used, instead.
  • Reports created with Crystal Reports version 6 are no longer supported.
  • With the property 'show identifier' chart shows now the group name values in the item labels on the plot. Not an x axis value like in the past.
  • Error message improved, that will be thrown from the ASP.NET proxy if i‑net Crystal-Clear server is not running
  • Formula:
  • Case insensitive String comparison is now set to SECONDARY(more strict) strength instead of PRIMARY. This will honor different accented forms of the same base letter as well. Using case insensitive comparison, “è” and “E” for instance will not be equal anymore.
  • Numeric summary functions, which are used in formulas with an array as parameter, will now never return null. Instead 0 will be returned. This works only with summary functions, with a fixed return type of number, as there are: count, sum, correlation, covariance, distinctcount, average, weightedaverage, populationvariance and variance.
  • The output of the formula function DataTimeZone can now be directly used as an input for DateTimeWithTimeZoneOffset.
  • It is now possible to log-in with another user, if the guest account does not have the necessary rights to execute the report.
  • The section property “Suppress if Blank” is now ignored, if there is no dynamic content in the section.
  • API:
  • The class com.inet.report.RemoteInterface was removed from the API. The recommended solution for remote access are the PHP proxy and the ASP.NET proxy (see the samples).
  • The older methods AbstractValueElement.setRoundingDigits and AbstractValueElement.setRoundingType have been deprecated and are replaced by AbstractValueElement.setRounding. This method takes the number of digits to which to round. In order to round to a digit after the decimal point, use a negative number.
  • Fixed Bugs:
  • PDF export:
  • Sub-reports containing images, were sometimes not included in the created PDF file.
  • If the property 'Replace Missing Characters' was enabled, then sub-reports were sometimes not included in the created PDF file.
  • IllegalArgumentException sometimes occurred during the creation of a signed PDF file.
  • Unicode characters, containing some special byte values(0x28,0x29,0x5c), could not be displayed correctly in the bookmarks of the PDF file.
  • Borders and shadows of elements painted into the next section.
  • Position of a hyperlink in the PDF file was incorrect, if the hyperlink was created using a field with text interpretation “HTML (advanced)”.
  • Sometimes cache was hanging for 15 minutes after refresh button in Java report viewer was clicked, if embedded fonts were used.
  • N-datatypes of JDBC 4 (e.g. NClob) not supported, if Java 6 was used.
  • Translations in the report was not used for parameter fields (prompts) and formulas.
  • Sometimes error message has not occurred in case a basic formula did not assign the 'formula' variable.
  • Image export: The export of on-demand sub-reports has produced corrupt image files.
  • Borders and shadows of elements painted sometimes into the next section.
  • In rare cases an extra empty line in text fields including field parts and empty lines occurred.
  • For elements using basic HTML interpretation, justified bullet lists were not justified in the first line
  • RTF export: Not transparent images were not displayed in OpenOffice writer.
  • The “on demand” sub-report label formulas were not correctly read by the Report Reader tool.
  • A vertical line or box from the page header to group footer section was not drawn on a page, if it was the group footer of the last record, the group footer was on the top of the next page and there was no group footer on the current page.
  • The methods RDC.loadEngine(File file) and RDC.loadEngine(File file, xxx) could not read report templates that was saved as directory.
  • A line or box from the page header section to a group footer section was not painted, if it was the group footer of the last record and the group footer was displayed on a top of a new page (after page header).
  • Column for identical groups was added multiple times to the OrderBy statement.
  • When opening a report with two data sources, of which one was already registered as a data source configuration and the other was not, settings from the second data source could overwrite settings from the first.
  • HTML prompt request dialog: Property “Default values only” was not used.
  • The height of a section was increased to the default cross-tab height, if the section contains a very small cross-tab (smaller than the cross-tab default height) and if the height of the section was smaller than the default cross-tab height.
  • The character # was not quoted, if report was executed on a MySQL database.
  • Excel Export:
  • If the first group is invisible and the group header in the second group is suppressed and the group footer in the second group contains some data, the new sheets pro first group have not been created.
  • Text strings was formatted with STANDARD-Format instead of TEXT-Format. Therefore numbers and dates, that are written as text, was shown in Open Office with an apostrophe as first character.
  • No column was added to the XLS file for thin report elements (< 3mm).
  • API Changes:
  • Added Classes
  • com.inet.report.Region
  • Added Methods
  • com.inet.report.BorderProperties
  • isCloseBorderOnPageBreak()
  • getCloseBorderOnPageBreakFormula()
  • setCloseBorderOnPageBreak(boolean)
  • setCloseBorderOnPageBreakFormula(FormulaField)
  • com.inet.report.BoxProperties
  • getBackColorFormula()
  • setBackColorFormula(FormulaField)
  • com.inet.report.Engine
  • getMetaProperties()
  • setMetaProperties(java.util.Properties)
  • com.inet.report.Element
  • isCloseBorderOnPageBreak()
  • Methods and Constants deprecated as of Version 10
  • com.inet.report.config.datasource.DataSourceConfiguration
  • checkConnection()
  • com.inet.report.AbstractValueElement.
  • getRoundingDigits()
  • getRoundingType()
  • setRoundingDigits(int)
  • setRoundingType(int)
  • com.inet.report.RDC
  • loadEngineFromDir(File)
  • Removed Methods
  • com.inet.report.Cache
  • isTypeClusterCache()
  • com.inet.report.LicenseKeyInfo
  • isCluster()
  • getGroupNumber()
  • Removed Deprecated Classes, Methods and Constants
  • com.inet.report.AbstractFontElement
  • getBold()
  • getItalic()
  • getStrikeout()
  • getUnderline()
  • com.inet.report.AbstractLineElement
  • getExtendToBottomOfSectionWhenPrinting()
  • com.inet.report.AbstractValueElement
  • getAllowFieldClipping()
  • getReverseSignForDisplay()
  • com.inet.report.BorderProperties
  • getTightHorizontal()
  • setTightHorizontal(FormulaField)
  • com.inet.report.Chart
  • com.inet.report.ChartFormatProperties
  • getAllowFieldClipping()
  • getReverseSignForDisplay()
  • com.inet.report.CrossTabCell
  • getSubElements()
  • com.inet.report.DatabaseTables
  • getConvertDateTime()
  • isPasswordValid()
  • setConvertDateTime(int)
  • com.inet.report.Element
  • getCanGrow()
  • getCloseBorderOnPageBreak()
  • getDropShadow()
  • getSuppress()
  • getSuppressIfDuplicated()
  • getTextRotation()
  • getTightHorizontal()
  • setTextRotation(int)
  • setTightHorizontal(FormulaField)
  • com.inet.report.Engine
  • EXPORT_CSV_COM
  • EXPORT_CSV_COL
  • DEFAULT_PAPER_ORIENTATION
  • DEFAULT_PAPERSIZE
  • LANDSCAPE
  • pageSizes
  • PAPER_*
  • PATER_TABLOID
  • PORTRAIT
  • USERDEFINED_PAPER
  • getAcrossThenDown()
  • getFormatGroupsWithMultipleColumn()
  • getHorizontal()
  • getLabel*()
  • getMargin*()
  • getPaper*()
  • getVertical()
  • isFormatWithMultipleColumns()
  • setAcrossThenDown(boolean)
  • setData(ResultSet, boolean)
  • setFormatGroupsWithMultipleColumn(boolean)
  • setFormatWithMultipleColumns(boolean
  • setHorizontal(int)
  • setLabel*(…)
  • setMargin*(…)
  • setPaper*(…)
  • setVertical(int)
  • com.inet.report.FieldElement
  • getLineSpacing()
  • getLineSpacingType()
  • setLineSpacing(int)
  • setLineSpacingType(int)
  • com.inet.report.FontProperties
  • getBold()
  • getItalic()
  • getStrikeout()
  • getUnderline()
  • com.inet.report.GeneralProperties
  • CENTER_ALIGN
  • DEFAULT_ALIGN
  • JUSTIFIED_ALIGN
  • LEFT_ALIGN
  • RIGHT_ALIGN
  • ROTATE_*
  • getCanGrow()
  • getCloseBorderOnPageBreak()
  • getCloseBorderOnPageBreakFormula()
  • getDefaultPromptValues()
  • getDropShadow()
  • getDropShadowFormula()
  • getKeepTogether()
  • getSuppress()
  • getSuppressIfDuplicated()
  • getTextRotation()
  • setCloseBorderOnPageBreak(boolean)
  • setCloseBorderOnPageBreakFormula(FormulaField)
  • setDropShadow(boolean)
  • setDropShadowFormula(FormulaField)
  • setTextRotation(int)
  • com.inet.report.Group
  • getInstanceId()
  • getParentGroup()
  • removeGroupDirectionFormula()
  • setHierarchicalGrouping(boolean, Field, Field, int)
  • setInstanceId(Field)
  • setParentGroup(Field)
  • com.inet.report.LineProperties
  • getExtendToBottomOfSectionWhenPrinting()
  • com.inet.report.Paragraph
  • getLineSpacingType()
  • setLineSpacingType(int)
  • com.inet.report.Paragraph
  • getLineSpacing()
  • setLineSpacing(int)
  • com.inet.report.ParagraphProperties
  • EXACT_SPACING
  • MULTIPLE_SPACING
  • getLineSpacing()
  • getLineSpacingType()
  • setLineSpacing(int)
  • setLineSpacingType(int)
  • com.inet.report.PictureProperties
  • BOTTOM_ALIGN
  • CENTER_ALIGN
  • TOP_ALIGN
  • com.inet.report.PromptField
  • addDefaultValue(String,String)
  • addDefaultValue(Object,String)
  • getPromptValueDesciptions()
  • setDefaultPromptValues(Object[])
  • setDefaultPromptValues(String)
  • setDefaultValue(int,Object,String)
  • com.inet.report.RemoteInterface
  • com.inet.report.ReportComponent
  • getKeepTogether()
  • com.inet.report.ReportProperties
  • getAcrossThenDown()
  • getDistinct()
  • getFormatGroupsWithMultipleColumn()
  • com.inet.report.SortField
  • removeSortDirectionFormula()
  • com.inet.report.Subreport
  • getOnDemand()
  • com.inet.report.SubreportProperties
  • getOnDemand()
  • com.inet.report.SummaryField
  • SUMMARY_CROSSTAB_ROW
  • SUMMARY_CROSSTAB_COLUMN
  • com.inet.report.ValueProperties
  • TWELF_HOURS
  • getAllowFieldClipping()
  • getReverseSignForDisplay()

New in i-net Crystal-Clear 9.1.59 (Sep 21, 2009)

  • It is now possible to host a report repository on a running i-net Crystal-Clear Plus server.
  • Reports can be downloaded from and stored in the repository either by the i-net DesignerXML or the new Online browser.
  • There have been further improvements to the API and the overall behavior of the designer (e.g. keyboard shurtcuts and window positioning).
  • This release also features the new HTML display method, "advanced", which is derived from the JWebEnigne project and now supports absolute positioning of HTML elements.

New in i-net Crystal-Clear 9.0 RC (May 19, 2009)

  • Remote Configuration Manager
  • Formulas with Evaluation Time: WhileReadingRecords
  • Improved Report File Format
  • New export formats: BMP, GIF, JPG and PNG
  • New renderer for text interpretation: HTML (advanced)
  • Report URL parameters are disallowed by default
  • Underlay Following Sections
  • i-net DesignerXML

New in i-net Crystal-Clear 8.2 (Nov 26, 2008)

  • This release adds a lot of new API functions and a new chart function: combined charts. With combined charts, you can display different dataset charts within one graphic.