i-net Crystal-Clear runtime

i-net DesignerXML

New property: “OnError_ExecuteSQL_WithoutSF” has been added. With this property it is possible to stop the report execution after an error has occurred while fetching the data with an invalid Record Selection Formula.

New property: “UseSetPageDevice” has been added. This property specifies if the setPageDevice operator will be used for the postscript export.

The record selection formula: ”{table.field} = {?multi_value_prompt}” is now executed on the database (using a WHERE clause) as table.field in
(element1,element2,…).

Problem with accumulate variables in formulas was fixed. Now a formula is guaranteed to execute only once per row.

Now the client language (locale) and not the server language is used by default for Page N of M, Page N, Crosstab Labels, number system format, date time system format, boolean system format, function toWords(), function WeekdayName(), function MonthName() and function ToText().

Resize of sub elements of a crosstab will cause changes of all dependent elements (e.g. setting the width of a FieldElement will resize the row of this element … )

Full Outer Join is now supported.

Charts: Summary operations for formula fields now supported.

Database: Now it is possible to combine each join type with each link type. A join can also have multiple links from different type now. (see API changes)

PS Export: Pictures are now saved only one time in the exported .ps file (postscript level 2 and 3).

Data Export has been added (init=data). With this export type it is possible to export only the report data in a .csv file. The .csv file contains the column names in the first row.

CSV and Data Export: Properties “delimiter” and “quotechar” has been added. With these properties it is possible to set the column delimiter and the text qualifier.

HTML Export: Export of the complete report into a single HTML file is supported. The property “layout” specifies whether the HTML page should contain the Page Header and Page Footer or not.

PDF Export: Boxes with curved corners are supported (rounding).

XLS Export:

PDF Export:

RTF Export: A problem displaying Unicode characters.

Using Mode(String) as summary function in cross tab showed nothing instead of 0.0 if no records present.

The following summary functions returned null when all data of the column on which the summary function is executed was null. : sum, average, sample variance, sample standard deviation, population variance, population standard deviation, correlation, covariance, weighted average and median.

Database Connection:

Java Viewer:

A bug with the data type memo (long varchar) used in reports designed with Crystal Reports has been fixed.

The regression in version 5.1 with Running Total: “On Change on Group” and Reset “On Change on Group” has been fixed.

Crosstab: A bug with the function CurrentFieldValue has been fixed. Now it is possible to configure the crosstab cells depending on the current field value.

A bug with ResetPageNumber and TotalPageCount has been fixed. The TotalPageCount was wrong after the last reset in the report.

A NullPointerException has been fixed. The exception has occured e.g. if the classes of the JDBC driver has not been found.

JSP: The jsp file is no longer used as report file if the report file has not been specified in the url of the jsp file (e.g. http://...:sample.jsp).

A bug with setConnection(…) has been fixed that has occurred if i-net Crystal-Clear was used as servlet.

PHP: A bug with “SubreportsOnDemand” has been fixed. It has always displayed the main report instead of the subreport.

A bug that has occured if a summary field has based on a SQL Expression field has been fixed.

A bug with multicolumn reports has been fixed. It has occured if “Underlay Following Section” for the the “Group Header” has been enabled.

com.inet.report.DatabaseTables, the old join type has been split into join type and link type. With this change it is possible to combine each join type with each link type. It is also possible to set multiple different link types for one SQL Join.
→ deprecated:
public void addJoin(String fromTable, String fromColumn, String toTable, String toColumn, int type)
replaced by:
public Join addJoin(String fromTable, String fromColumn, String toTable, String toColumn, int joinType, int linkType)

com.inet.report.FieldElement, the methods setRoundingDigits(int digits) and getRoundingDigits() have been added to set the count of rounding digits.

Tool tips can now additionally be defined by a textbox.

Only column names are displayed for database fields in the EditorPage. The full alias names are shown in the tool tip.

Grid size can be changed in dialog “Designer Options”.

User defined formulas (UDF) are displayed in the formula editor in an own tree node under functions → user defined formulas and will also be highlighted in another color.

Resizing of all sub elements of a crosstab is now supported.

The grid lines of the crosstab are displayed in the design tab.

Chart Properties: The Number format can be changed even if “AutoRange” is enabled.

Suppressed Row or Columns is now visualized in design view.

It is possible to turn on / off the hatching of suppressed sections (Designer Options).

Added a feature to the DesignerDataModel so that it is possible to:

The option “suppressIfNoData” has been made accessible in the “Summary Info”→“Report Options”

The DesignerListener is now implemented and can be used to listen for the events thrown.

A new link dialog has been created to support the split of the old join type in join type and link type.

The properties dialog of a field now shows the type and name of the field in the title bar of the dialog.

The border properties can now be set for all borders (left, top, right, bottom) simultaneously.

In addition to Traditional Chinese, Simplified Chinese is supported as i-net DesignerXML language.

It is now possible to use command line parameters with the embedded i-net DesignerXML.

The field browser now shows where a field is used (e.g. in a formula or for sorting records)

The field browser now shows the type of the field (please see i-net DesignerXML help for the meaning of the icons)

A new option “hide system tables” has been added to the designer options. (Note: this setting can be overridden by the set DesignerDataModel)

A NullPointerException occurred if a report was to be reopened and the report did not exist anymore.

Now a double-click in the field browser is possible in order to edit the selected field. Deleting the selected field is also supported with the delete-key now.

After cancelling of a dialog, scroll position use to jump to the top of the report.

For csv-databases, files not matching *.csv and *.txt were shown in the database explorer.

The group name was not displayed properly in the field browser.

A double click on a line object in the Editor Page had no effect. (Brings up the property dialog now)

Borders of box object were sometimes drawn incorrectly.

Pictures could be inserted although cancelled by click with right mouse button.

Title of the report was not properly set in report window.

Changes to the i-net Crystal-Clear options only had an effect after a restart of the designer.

Lines in old CR reports were sometimes initialized incorrectly. (line style NO_LINE).

Summary fields could not be used for charts.

Editor was not refreshed if user defined paper size was changed.

Changes to the default unit in “Designer Options” needed a restart of the designer to have effect.

Dialogs were sometimes moved into the background if a switch to another application was made.

If a formula was incorrect and “discard changes” was selected then the changes were not discarded.

A chart could be added to the editor page without defining the data to display.

In the formula editor, the drag and drop from the field browser into the formula was not possible.

The snap to grid only worked with a zoom of 100%.

Drag and drop was not possible in the chart properties–>data- tab for the available fields.

Charts in group header/footer moved to report header/footer when the chart properties were changed in the chart properties dialog.

All stored procedures of Oracle databases are displayed again. Oracle functions which return a Cursor are supported as well.

Opening the database browser will be faster now.

The links created in the subreport link dialog can now be deleted with the DELETE-key.

The subreport link dialog could not be closed by pressing the X-button of the dialog.

The functions/operation trees in the formula editor were resizable to size 0.

The name of the subreport was drawn under the yellow subreport lines and was hard to read.

A ClassCastException in the field browser sometimes occurred.

Tables, views and stored procedures now appear sorted in the database browser.

A bug in the prompt properties dialog made a default value permanently incorrect.

The list which fonts can be used will now be created considering the value set for useNativeFonts in crystalclear.properties.

In the database browser, the tree always collapsed if the dialog was reopened.

A refresh problem with the field browser when opening a new report.

Refresh of a stored procedure in the visual database wizard works properly now.

Embedded designer changed the look and feel.

After cancelling a properties dialog in a subreport the wrong report tab was selected (not the subreport but the main report)

The last line of a text object was moved down in the viewer because of a bug in the designer.

The categories (database fields, formula fields) have been inserted sorted by name.

Two instances of the same report could have been opened.

Adding an oracle stored procedure in combination with the Oracle thin driver always failed with “invalid SQL statement” SQLException.

The last used directory is now saved when using File→Open and File→Save.

For the page header the option print at the bottom of the page could be set.

In the properties dialog the name of the font was not displayed if useNativeFonts was false and if the set font was no Java-font.

The scroll positions were not restored properly when cancelling a dialog.

Mailing label and multi column page layout could not be saved as default layout.

When deleting a section containing an currently opened subreport then this subreport was not closed.

A bug with property formulas has been fixed. It has occurred after a property formula was removed and the report was saved.

Debug log output (AdjustmentEvent) removed from the console.

Several copy&paste problems have been solved.

The popup menu for elements in the report could have been reduces after selection of multiple elements.

A dialog could have disappeared in the background.

Drag&drop now works in the sort records dialog.

A bug with the “Subreport on Demand” formulas “On Demand Label” and “On Demand Tab Label” has been fixed. The formulas were removed from the report after it was saved with i-net DesignerXML 5.2.