i-net Clear Reports

i-net Crystal-Clear runtime

New Features / Improvements

  • New API methods:
    • FieldElement.setBaseURL(String). It is now possible to set the “Base URL” for field elements interpreted as HTML. This causes any relative links in the element to use the base URL as the base.
    • ReportProperties.setReportLocale(java.util.Locale). It is now possible to set a locale that is different to the server locale and that will be used for formatting CDbl, ToText etc.
  • New Formula functions:
    • UnixTimeStampToDateTime: Converts a UNIX timestamp into a date/time object.
    • ActualPageNumber: Returns the actual, current page number.
    • SelectionLocale: Returns the servers default locale used to generate the current report.
  • Excel export: The Option “fit print output to page width” is set for excel export. Thus if the width of the sheet content doesn't fit the page width, the sheet content will be automatically scaled to fit the page width.
  • Postscript export: Compression of monochrome blob images supported.
  • HTML export: Attributes 'scope' are written in crosstab column- and row headers for 508 Compliance.
  • Property “Clear On New Request” added. If the value is true the whole cache will be cleared on next request.
  • Chart:
    • Combined Charts (Dual Axis Charts) supported.
    • A new flag added to legend properties. This sorts the legend labels ascending or descending depending of the sort order of the second group.
  • Trailing white spaces in char columns are truncated (in version 8.2.385).

Changed Behavior

  • If the maximum number of errors was reached, the last error causing the canceling of the report is now displayed.
  • Faster string comparison when rendering with multiple threads.
  • If rendering was stopped (engine.stop) then data fetching and sorting will be stopped, also.
  • Database Meta Data Cache: Availability of values improved.
  • Formula Functions:
    • Function TextFromFile supports URL's with protocols other than “file”, e.g. “http”.
    • If the result of a logical operation is determined by the left operand, the right one will no longer be evaluated. Note, that even operations, that modify any data will not be executed in that case!
    • Function Color now also accepts 4 parameters, the 4th being the alpha value of the color. Alternatively you can use the function RGBA.
    • New parameter types added to the formula function toText so that they can use the system default formats.
    • Reading very long formulas has been accelerated (in version 8.2.422).

Fixed Bugs

  • In some cases the configuration was unnecessarily read twice during startup of i-net Crystal-Clear. This slowed down the performance of the startup and has been fixed.
  • Exception occurred while using number format property formulas in cross-tab cells, which contains the keyword “currentfieldvalue”.
  • “Can Grow” fields with trailing spaces would show up with an unwanted line break.
  • It was not possible to translate the “Total” label in cross-tab using language resources.
  • Connection leak has occurred if database connection was set with method setConnection and parameter field values were requested from the Java viewer.
  • Formula function MIRR: Result of the formula function was wrong.
  • ClassCastException occurred if property “Log Database Data” (CCcore file creation) was enabled.
  • In case the text interpretation was set dynamically and changed throughout the report, a rare “ClassCastException: com.inet.report.PageBreakInfo cannot be cast to com.inet.report.layout.ric.RichHtmlPageBreakInfo” could occur.
  • In rare cases lines and boxes were rendered incorrect if they are included in the page header or page footer of a report and that was added as sub-report.
  • In rare cases, a report could have been saved incorrectly which then caused the report to be able to be loaded, but not saved again.
  • Query files not found if they were set using UNC names.
  • Round-up has not worked correctly for small values and all values of the Rounding property.
  • It is no longer necessary for the SQL query for dynamic prompt default values to have the value and description columns be columns 1 and 2. Rather you can now name the columns “value” and “description” and their order can then be as desired.
  • Database Meta Data Cache does not used database connections set with method setConnection.
  • Regression: An incorrect error was thrown after the same engine was executed twice.
  • PDF export: Representation of blank content was wrong. Page in PDF file was blank if total page element was empty.
  • RTF export: Windows Metafile show correct line stroke with extended pen. This GDI-object is used now instead of simple pen.
  • Record Selection Formula: Fix for in-Array operations used in the record selection formula. The in-Array operation will now return always false if the array is empty. This has an impact on an empty multi-value prompt for instance, which returns an empty array as well.
  • Chart:
    • Incorrect label of data axis by continuous date chart.
    • Outline of Doughnut 2D chart was always drawn.
    • The separators of ring 2D were not defined by items outline.
    • The color order of chart items was dependent from legend.
    • The list of legend labels from second group is now sorted by sort order of this group.
  • SVG Bean (com.inet.report.beans.SVG): NullPointerException occurred.
  • Sometimes a section disappeared if the Page Footer section was suppressed depending on a formula.
  • RuntimeException: Field is null occurred while opening a report designed with Crystal Reports.
  • Line styles of a box in a sub-report was sometimes used for a box in the main report, also.
  • Web server stops responding after some errors in the record selection formula had occurred.
  • TXT export: Chinese data were shifted sometimes if the data contains the Chinese character “VIII”.
  • ODBC driver for Excel mark all sheets as SYSTEM TABLE. Therefore no objects has been displayed in the Visual Database Wizard.
  • Drill Down not worked because of an encoding problem if script language like ASP or PHP used.
  • TXT export: Chinese data were shifted sometimes.
  • Wrong result of DateDiff function with a DayOfWeek offset occurred if the difference was a multiple of seven days.
  • IllegalArgumentException occurred while opening report file after parameter field type has changed (fixed in build 8.2.245).
  • Because of an exception occurred while reading sproc parameter values for a store procedure (e.g. on Informix) the value for some stored procedure parameters was null (fixed in build 8.2.247).
  • Non-ASCII characters in parameter field names are not displayed correctly in the HTML Parameter Request dialog. (in version 8.2.305).
  • Endless loop occurred if Underlay Following Section was enabled for a large section (fixed in version 8.2.422).
  • StackOverflowError occurred if nested if-then-else statements used in formulas (fixed in version 8.2.436).
  • An endless loop could occur in rare cases if metadata cache was enabled. (fixed in version 8.2.441).
  • Security issue: Using a modified report URL, it was possible to download files from the i-net Crystal-Clear web context, if the file crystal.war was unpacked (fixed in version 8.2.445).
  • Excel Export:
    • Cross-Tab in the .xls file was incomplete. The the first column was not exported (fixed in version 8.2.445).
    • Position of the '%' symbol has not been set for log level less the WARNING (fixed in version 8.2.519).
  • Data export:
    • It has occurred that columns of the exported csv file contains records of multiple database fields or special fields, e.g. Page Number (fixed in version 8.2.540).
  • Property “OnError_ExecuteSQL_WithoutSF” was ignored if an error occurred during execution of Order By and Where clause (fixed in version 8.2.540).
  • Endless loop occurred because of java.util.WeakHashMap, which a non-thread safe object.
  • Security fix to prevent cross-site scripting (XSS) (fixed in version 8.2.959).

API Changes

  • Added Methods
    • FieldElement.getBaseUrl()
    • FieldElement.setBaseURL(String)
    • FieldElement.getBaseUrlFormula()
    • FieldElement.setBaseUrlFormula(FormulaField)
    • ReportProperties.setReportLocale(java.util.Locale)
    • ReportProperties.getReportLocale()

i-net Crystal-Clear - Java Viewer

New Features / Improvements

  • It is supported to change the language of the Java viewer by changing the Locale.
  • NEW API: SwingReportViewer now has two new methods: setPrinterDefaultFormatHandling and getPrinterDefaultFormatHandling. Changing the default handling enables you to have a report designed for Letter, but printed on an A4 printer (or vice versa), have the paper size set to the printer default by default rather than to the paper size designed in the report. See the API documentation for more info.
  • Russian translation of the GUI added (in version 8.2.305).

Changed Behavior

  • It is possible to scroll between pages with the mouse wheel. This behavior was optimized to not switch pages with such a high sensitivity.
  • Excel export: The option “fit print output to page width” is set for excel export. Thus if the width of the sheet content doesn't fit the page width, the sheet content will be automatically scaled to fit the page width.
  • Parameter Fields directly placed into the report now use the “ToText” function for their string representation, which especially improves the representation of date range prompts.

Fixed Bugs

  • Various bugs regarding searching with regular expressions in the Java viewer have occurred.
  • HTML errors coming from the server are no longer shown in a garbled manner in the viewer's error dialog, but as an HTML-formatted error box.
  • If a prompt field was set to accept default values only but had no default values, it would show up as an not editable empty field. Now it accepts a user entry in this case.
  • When setting empty default values and “default values only”, some prompt issues could occur such as an empty prompt box.
  • Pressing “More Info” in an error box coming from the report viewer within the Designer has no effect.
  • A rare IndexOutOfBoundsException occurred in the viewer when attempting to fetch a report for which the client had no reading permissions.
  • Links to “file:” files in a report did not work in the viewer applet due to Java security issues. This has been fixed for Java 6.
  • Landscape reports were not printed correctly if “2 Pages per Sheet” was set in the print dialog of the Java report viewer.
  • In some cases the state of the PrinterJobProgress was wrong after an error occurred. Therefore the PrinterJobProgress has not returned the error.
  • A NullPointerException in RichTextLayouter could occur in rare cases for elements with mixed text and field parts extending over multiple lines.
  • A memory leak in the viewer occurred when opening and closing individual report viewers.
  • Prompt request dialog was not displayed after refresh, when using new URLRenderData, if “promptonrefresh=true” was given as a URL property instead of being set via API.
  • Screen location of the calendar element was wrong sometimes on systems with dual monitors.
  • NullPointerException occurred when export button is pressed (export dialog doesn't appear at all) (fixed in 8.2.385).
  • Attribut “Permissions” was missing in the manifest file of CC-Viewer.jar. This is required since Java 7 update 45.

API Changes

  • Added Methods
    • SwingReportViewer.getPrinterDefaultFormatHandling()
    • SwingReportViewer.setPrinterDefaultFormatHandling(int)

i-net DesignerXML

New Features / Improvements

  • Group Dialog:
    • Second original sort order “Original Order Collect Values” now available. This collects only the same values located nearby, and begins a new group whenever the value changes in the group field.
    • BySummaryOrder now accepts values in percent.
    • Error bar added to the status bar. The error bar shows the last errors which occurred when previewing the report.

Changed Behavior

  • The fonts that are located in the “Font Path” - directory for embedded fonts will be registered. Thus these fonts will be show at design time additionally to the installed fonts.

Fixed Bugs

  • It was not possible to open the Help dialog while it is already opened and minimized.
  • Under Linux, running the i-net DesignerXML with limited permissions would lead to a Preferences warning being printed to the log every 30 seconds.
  • Pressing “More Info” in an error box coming from the report viewer within the Designer has no effect.
  • In the German version of the designer, there were some English labels mixed in with German labels in the formula editor.
  • ArrayIndexOutOfBoundsException occurred if an opened sub-report was deleted and then this was undone.
  • A report with an error in a formula could be loaded in the designer with the formula having a green checkbox though it had errors.
  • Various L&F bugs with the Nimbus L&F were occurred.
  • Parameter Field dialog:
    • Various GUI issues occurred.
    • It was possible to define illegal parameter field default values in the Parameter Field dialog, leading to errors when attempting to run the report.
    • There were some localization issues for entering limit values in the designer prompt dialog.
    • When setting a dynamic prompt with a manual SQL statement for a report with more than one data source, the data source combo box for choosing the data source was not showing, forcing the query to be run on the first data source only.
  • Page Layout dialog: Various GUI issues occurred.
  • Property dialogs: If all border types were set via property formula, the dialog would still show the border as being same for all edges.
  • Number Format dialog: It was possible to select currency type for non-currency numbers.
  • Formula Editor: Error message was displayed if constant “AdvancedHtmlText” was used in a property formula.
  • Field reference was incorrect if field was used within an array in a formula.
  • i-net DesignerXML Help: tree with the search results contained duplicate entries.
  • ArrayIndexOutOfBoundsException occurred while opening a report.
  • NullPointerException (at com.inet.designer.o.componentResized) occurred at random situations.
  • Additional new lines and empty text parts were added to a text objects.
  • Regression: Method BasicDesignerDataModel.loadReport(Component) was removed from API.
  • Screen location of the calendar element was wrong sometimes on systems with dual monitors.
  • Group Dialog: Report error “Wrong group number” occurred when trying to remove groups in sub-report.
  • Designer did not start with JNLP (fixed in version 8.2.422).
  • Regression: It was not possible to open the Page Layout dialog for a sub report to configure multi-column or mailing label layout (fixed in version 8.2.469).
  • Error box occurred on Windows 7 during start of i-net DesignerXML if node “cominetdesignerclasses” does not exist in Java preferences (fixed in 8.2.807).

i-net Scheduler

Fixed Bugs

  • Adding a “cache action” while using memory cache was disabling the combo box. So it was necessary to leave the “add action” page to add another action. Now, this can be done in one step without going back.
  • Temporary files for email action were sometimes not deleted. Additionally these temporary files were created in the temp directory instead of the current working directory of the scheduler.
  • File Actions does not work because of an exception in the report cache (fixed in 8.2.464).

Changed Behavior

  • It is now possible to enable/disable the scheduler web interface without restarting the scheduler.
  • Error Handling improved.
 

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