i-net Clear Reports

Changes in Release 10.1

i-net Crystal-Clear runtime

New Features / Improvements

  • RTF export: JPEG images are supported.
  • Formula fields are now allowed to return array and range values. If an array result is used in the report, only the first element will be shown.
  • The formula function ToText now supports to convert ranges of any type to a readable form. For date, time, dateTime and number ranges a pattern can be specified as well.
  • It is now supported to use Joins between BeanDataSources. The data fetching includes now the data of all sub objects of bean which are not of Java primitive type, see the property “Data fetching depth in sub beans” of bean datasource.
  • i-net Crystal-Clear now supports “fixed” currency symbols. The currency symbol is then aligned to the side of the element while the value can be aligned on its own. i-net Crystal-Clear now supports the option “one currency symbol per page”. This will cause the currency symbol to only be printed once per page rather than for each record.
  • PDF export: JPEG images and some types of PNG images that are not modified through scale or crop operations are written in PDF file without conversion to the default PDF image format. This reduces the size of the created PDF file.
  • DatabaseBean now reads only the used columns.

Changed Behavior

  • RTF export: To reduce the memory usage and file size, static images are now written in PNG or JPEG format instead of using enhanced Windows metafile format.
  • The formula statements SELECT and cascading IF(Basic Syntax) can now be optimized which makes them executable on the database in some cases.
  • The before reading formula will be executed now always before the record selection formula.
  • HTML error messages are UTF8 encoded for localized error messages.
  • HTML export: Images for that an hyperlink was configured will be displayed without blue border.
  • The formula function datetime no longer supports the date pattern MM-dd-yyyy, since it is ambiguous to dd-MM-yyyy.
  • FormulaField.getValueType() no longer throws runtime exceptions. The method will return the cached value type or calculate the current one, if required. To re-calculate the value type of a formula field, call validate() on this field.

Fixed Bugs

  • GlassFish servers could experience a NullPointerException when shutting down, this is now handled correctly.
  • Report Reader:
    • Renamed stored procedure prompts in Crystal Reports templates were not correctly converted by the .NET-based Report Reader.
    • The Report Reader tool could show an error if it did not have the rights to log to a file. Even when it doesn't have rights to log, it no longer will show an error.
  • A possible deadlock in hard disk and database cache has occurred. In this case, the log output has contained the endless repeated message “wait for unlock in delete”.
  • Security Bug occurred: With the Header HTTP X-Forward it was possible to bypass the IP filter. Now it is also necessary to specify the address of a proxy.
  • Windows authentication has worked with Jetty application server version 7.2 but not with version 7.0.
  • Exception “Invalid render state. Page already finished.” has occurred for reports that show only a report header and have the “New Page After” property enabled for one of the suppressed sections.
  • Exception occurred during reading of column labels (aliases) of a command.
  • DatabaseBean has returned incorrect values if the subbeans were null.

i-net Crystal-Clear - Java Viewer

New Features / Improvements

  • Using the checkbox “Multiple” and “Select All” it is now possible in the dialog “Enter Prompt Values” to select multiple or all default values for a parameter field that allows multiple values.

Fixed Bugs

  • There was an issue with the standalone report viewer not correctly updating its cookie from the server which could lead to searching in a report not working correctly.
  • Copying text from a report in the report viewer would always have an extra line break at the end. This extra line break has been removed.
  • Print dialog ignores PrintService in PrinterJob if SwingReportView.showPrintDialog(Component, PrinterJob, HashPrintRequestAttributeSet) was called.

i-net Designer

New Features / Improvements

  • Formula Editor: It is now possible to define your own formula functions. These functions can be written in Crystal or Basic syntax and can be used in any formula like build in functions.
  • Number Property “One Currency Symbol per Page” supported.
  • Database Wizard: A replacement dialog will be displayed in the Database Wizard. It supports you by replacing and moving of tables and stored procedures, editing of commands and by adapting of the reports to the changed database structure after a refresh of the database connection.
  • Java Beans
    • Customizer component supported.
    • 2D Barcode JavaBean added.

Changed Behavior

  • When loading a report which uses a Java Bean that is not available in the current designer, a warning is now shown.
  • If the designed height of a section is greater than the page height, then the section background will be red and a warning will be shown in the section.
  • The formula editor in the i-net Designer now checks constant parts of the formula instantly. This will show for instance division by zero errors already at design time.
  • Database Wizard: It is now possible to modify the values of the stored procedure parameters using popup menu item “Change Parameters…”.
  • The file open dialog now allows to enter absolute or relative paths. Until now the user had to select the folder and type the filename.
  • The file name in the file open dialog of the i-net Designer will now be validated during typing.
  • SQL expression Field display an error if more than one column is returned.

Fixed Bugs

  • The SQL editor for queries has been slightly improved, minor quirks have been removed.
  • A NullPointerException has occurred, when the number category in the Property Editor was opened for multiple selected field elements with different settings in currency type.
  • Commands referencing a prompt with a default value could create an invalid SQL statement while refreshing the columns of the command.
  • When editing a report located remotely on a repository, the font box in the chart dialog did not display the fonts available on the server where the report was located but rather those available on the client.
  • Database Wizard: “Refresh Connection” has not refreshed the database objects.

Ad Hoc Reporting

New Features / Improvements

  • Ad Hoc reporting now ignores directories with a dot at the beginning of their name (invisible directories on unix/linux).
  • The Ad Hoc web GUI now prohibits to overwrite reports with an equal name by default. Overwriting can be enabled by a checkbox.
  • It is now possible to set the default rendering format of Ad Hoc reports in the Configuration Manager.

Fixed Bugs

  • It was not possible to load a saved Ad Hoc report correctly. It was necessary to select the Ad Hoc data view again.

Configuration Manager

New Features / Improvements

  • There are two new command line arguments you can use: -exportconfig <config> <file> exports the specified configuration to the specified file and -listconfigurations displays a list of the installed i-net Crystal-Clear configurations on the server.
  • Configuring Permissions: The remote configuration manager in the Remote Interface now also offers a list with already logged in users if the login type is set to Windows authentication.

Fixed Bugs

  • Changing the setting “Use Native Fonts” in the i-net Crystal-Clear configuration did not have an effect until the report server was restarted.
  • Configured roles of the system permissions haven't been restored correctly.

Setup

New Features / Improvements

  • Glassfish application server is supported.
 

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