I-net Clear Reports Designer

1. I Net Seven
2. I-net Clear Reports Designer Software

i-net Clear Reports (formerly known as i-net Crystal-Clear) is a Java-based cross-platform reporting application providing a report designer and a server component to create reports in numerous output formats like PDF, HTML, PS, RTF, XLS, TXT, CSV, SVG, XML, as well as being viewable in a Java applet or Swing component.^[1] Application programmers can integrate i-net Clear Reports using the public API which spans over 200 classes.^[2] Starting with release 11.0 i-net Clear Reports also supports the .NET programming language and offers a public API for further integration in other products.

History[edit]

Clear Reports is an elegant way to access your i-net Clear Reports template repositories and run your reports while on the go. These reports can be either i-net Clear Reports templates or Crystal Reports templates. I-net Clear Reports is a feature-rich and powerful Java reporting solution which can run Crystal Reports templates or templates designed in the free i-net Designer. The i‑net Designer is the default report designer for i‑net Clear Reports which can be used as a standalone application without installation. There are additional Ad Hoc clients for quick reporting results that run in your browser. Report Designer. Ad Hoc Reporting. I-net Clear Reports. This application uses cookies to allow login. By continuing to use this application, you agree to the use. Clear Reports is an elegant way to access your i-net Clear Reports template repositories and run your reports while on the go. These reports can be either i-net Clear Reports templates or Crystal Reports templates. I-net Clear Reports is a feature-rich and powerful Java reporting solution which can run Crystal Reports templates or templates designed in the free i-net Designer.

In Version 11.0 i-net Crystal-Clear was renamed to i-net Clear Reports. At this time it also gained .NET integration as a major feature.

i-net Crystal-Clear was primarily designed to read Crystal Reports templates. It had to be capable of reading the RPT report format and producing a reasonable output. For exporting and saving reasons a new file format had to be created later on, enabling Crystal-Clear to save the API results back and make them editable by a designer.^[3]

In 2002 the first version of i-net DesignerXML, the report designer, was written using Java Swing. The editing concept is slightly different from some other designers, using a band-oriented report template format, meaning that reports are designed based on rows of data.

The development efforts has changed in more recent years to a full reporting platform approach, rather than the developer-only, framework-based one.

True to its roots, i-net Crystal-Clear still has the ability to read and execute Crystal Reports report templates up until the latest versions of Crystal Reports.

Unlike Crystal Reports, however, the i-net Crystal-Clear report file format has always been an open format. Until version 9.0 it was an XML format. Since version 9, the report file format is in a zip-based format similar to OpenDocument.

Flexibility[edit]

Being a Java application, i-net Clear Reports has the ability to run on a variety of platforms and environments. There is virtually no restriction concerning data sources that can be used, as long as there is a JDBC driver available for accessing the data. For non-JDBC data sources, there are how-to's to write simple mini-drivers. With the new .NET API it got even more flexible and allows integration into .NET based applications.

i-net Clear Reports comes as a standalone server as well as a servlet which can be run on any Java EE application server such as Tomcat, Jetty, IIS, or Apache (via PHP).

Features can be added using the public API, or by adding custom JavaBeans which can be added to reports. User defined functions (UDF) extend the formula features of the embedded formula calculation routines.

Notes and references[edit]

1. ^'i-net Clear Reports / freshmeat.net'. May 15, 2009. Retrieved 2009-05-18.CS1 maint: discouraged parameter (link)
2. ^'i-net Clear Reports API'. May 17, 2011. Retrieved 2011-05-17.CS1 maint: discouraged parameter (link)
3. ^'Development Timeline'. March 17, 2011. Retrieved 2011-05-17.CS1 maint: discouraged parameter (link)

External links[edit]

i-net Clear Reports is a reporting solution which allows generation of reports based on dynamic data. To create a report you have to design the report template and specify where the data is coming from.

The following sections provide some details on the different elements that can be used in i-net Clear Reports and their common properties. If you are looking for more hands-on information you should take a look at the 'Getting Started Guide'.

What to know about i-net Designer

With i-net Designer you will get one tool to access, calculate and analyze your enterprise data and create challenging and feature-rich reports in a professional way. Benefit from following i-net Designer features:

• Data access to every data source accessible by JDBC or ODBC
• Report Wizard to assist you while creating report templates
• Simple and intuitive report design by dragging and dropping data, design and representation elements
• Many different data, design and representation elements such as charts, cross tabs, text elements, sub reports, special fields, images or lines and boxes
• Powerful but simple formula language for creating custom formulas and data transforms with more than 400 predefined functions, expressions, constants and control structures
• Flexible, dynamic, and interactive reports by use of parameter fields and setting report options by formulas
• Report and data arrangement by several footers, headers or grouping sections
• Export to several formats, such as *.pdf, *.html, *.xls or ...
• Reading capability for reports from Crystal Reports
• 100% Java product, free information delivery to all platforms

Designing reports

Designing a report with i-net Designer is a simple three step procedure:

1. Choose and configure your data source (if needed).
2. If needed, create custom elements such as SQL queries, formula fields or parameter fields
3. Drag and Drop elements from i-net Designer field browser and arrange them as you like it in i-net Designer design area.

Result can be reviewed in an i-net Designer preview and exported to one of the export formats.

Installation requirements

The one and only requirement to run i-net Designer is a Java Runtime Environment 7 (or higher).

The following sections give you a short outline of some of the most important features of i-net Designer.

First, the above image 1 shows the graphical user interface of i-net Designer. In the frame on the right side you can see the report design area. Most report elements are taken from the field browser on the left side and are arranged in the design area by dragging and dropping them there. Further functionality is available from the menu or the tool bar.

Database Wizard

As soon as you have selected your report data source i-net Designer shows the Database Wizard to set up tables and table relations. As following image 2 shows, simply drag and drop field relations and set the relation type.

Page layout / sections

Every report may be divided into several sections. At the very least, each report has a report header and footer, a detail section, and a page header and footer. But this can be enhanced. As following image 3 shows, you can insert your own sections and customize every section for its own by using i-net Designer section properties.

If you have groups in your report (see section Grouping), there are group headers and footers as well.

Fields

Data fields are an essential part of every report to represent your enterprise data. In i-net Designer those fields are taken by dragging and dropping them from the field browser (see following image 4) and arranging them in the design area.

For every field there are a lot of options to set, such as font, border, color or format options. The following field types are available.

Database Fields

A database field represents data from a table column of your configured data source. Let’s assume there is a table with products and prices in your data source and you would like to have a report with products and prices. In this case, you’d configure this data source and drag the database fields to your report detail section.

Formula Fields

By using formula fields you can create your individual data calculations and transformations. To create these fields, i-net Designer provides a formula editor with a powerful formula language. There are more than 400 predefined functions, expressions, constants or control structures to make your custom formula field possible.

The above image 5 shows a very simple sample. Using the DateDiff operation from a database field 'Orders.OrderDate' the difference is calculated.

I Net Seven

Parameter Fields

I-net Clear Reports Designer Software

A parameter field allows interaction and gives the user more flexible and customized reports. By defining a parameter field for a report every time a user requests or refreshes this report the parameter will be prompted.

So if you designed a report about last year’s enterprise sales you could create a parameter field for the year and show sales only for the user prompted year. Another example is to suppress specific report elements corresponding to a given user prompt.

Special Fields

To add common information to your report, i-net Designer provides special fields. Examples are print date, page numbers, report author or report creation date. Currently there are 24 special fields available in i-net Designer.

Summary Fields

A summary field is a field that returns a calculated value from the records either of a group (for grouping see chapter 'Grouping') or of all report records. For example, if you have a list of your enterprise product sales, a summary field could calculate the total sales. Simply calculating a sum is one of the simplest summary operations, however. Currently there are 19 operations available such as average, median, covariance, nth largest or sample standard deviation.

SQL-Expression Fields

An SQL Expression field is a type of database field. The difference is that the SQL-Expression field is a link to a native SQL expression, not to a single table column. So, use for an SQL-Expression purpose would be applying non-standard functions of your specific database management system such as generating sequences. Another purpose would be for speeding up database queries. Using the SQL-Expressions editor, as seen in the following image 8, for creating SQL-Expression fields is quite simple.

Group Name Fields

A group name field is a design element that returns the name of a group (for grouping see chapter 'Grouping').

Elements

Representing data in fields is important but professional and effective reports need more than this. Therefore i-net Designer additionally provides the following powerful design and representation elements.

Cross Calculated Tables (Cross Tabs)

Using a cross tab is an effective way to represent and calculate complex data coherences. Each dimension of a crosstab can be determined by one or more variables resulting in one compound variable. For each pair of compound variables you can calculate a summary value which is printed at the corresponding location.

Charts

For graphical representation of your enterprise data, i-net Designer offers 46 different chart types. Every chart type may be customized by a multitude of settings. Example chart types are bar, line, area, 3d surface, radar or bubble.

Sub-Reports

A sub-report is a completely separate report as part of the main report. This is very helpful for creating reports with an 1:m correlation. The only difference to a normal report is the missing page header and footer. A sub-report may be marked to be rendered on demand, so that it is not really a part of the resulting report but a separate report reachable by a link.

Pictures, Text Fields, Lines and Boxes

Other graphical elements for customizing your report are pictures, text field, lines and boxes. Simply arrange them per drag and drop in your report.

Grouping

Another function to structure your data representation is grouping. Grouping means aggregating elements by a certain criterion. In the report you will get a number of bundled elements in a certain sort order. A simple example may be grouping enterprise customers by country, as showed in the following image 11.

But it is also possible to create a group hierarchy like grouping sales by countries and customers. If a group hierarchy exists in your report, so-called 'drill down' operations are possible. That means suppressing information from lower group hierarchy levels and drilling down to this information (making it visible) only when needed. Referring to the example grouping sales by countries and customers, customer sales would be suppressed by default, but a report user could drill down to these sales if wanted.

Customizing i-net Designer Settings per Formula

Formulas can not only be used for calculating or transforming your enterprise data but also for customizing nearly every setting for the various i-net Designer fields and elements.

The example in the following image 12 shows how simple it is to change font color of a field depending on a field value.

© Copyright 1996 - 2020, i-net software GmbH; All rights Reserved. Imprint