i-net Clear Reports (formerly known as i-net Crystal-Clear) is a Java-based cross-platform reporting application providing a
report
A report is a document or a statement that presents information in an organized format for a specific audience and purpose. Although summaries of reports may be delivered orally, complete reports are usually given in the form of written documen ...
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.
Application programmers can integrate i-net Clear Reports using the public
API
An application programming interface (API) is a connection between computers or between computer programs. It is a type of software interface, offering a service to other pieces of software. A document or standard that describes how to build ...
which spans over 200 classes.
Starting with release 11.0 i-net Clear Reports also supports the
.NET
The .NET platform (pronounced as "''dot net"'') is a free and open-source, managed code, managed computer software framework for Microsoft Windows, Windows, Linux, and macOS operating systems. The project is mainly developed by Microsoft emplo ...
programming language and offers a public API for further integration in other products.
History
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
Crystal Reports is a business intelligence application marketed to small- and medium-sized businesses by SAP.
History
Terry Cunningham and the Cunningham Group originated the software in 1984. Crystal Services Inc. marketed the product (origina ...
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.
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 have 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
The Open Document Format for Office Applications (ODF), also known as OpenDocument, standardized as ISO 26300, is an open file format for word processor, word processing documents, spreadsheets, Presentation program, presentations and ...
.
Flexibility
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
Java Database Connectivity (JDBC) is an application programming interface (API) for the Java (programming language), Java programming language which defines how a client may access a database. It is a Java-based data access technology used for Java ...
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
A Jakarta Servlet, formerly Java Servlet is a Java software component that extends the capabilities of a server. Although servlets can respond to many types of requests, they most commonly implement web containers for hosting web applicat ...
which can be run on any
Java EE
Jakarta EE, formerly Java Platform, Enterprise Edition (Java EE) and Java 2 Platform, Enterprise Edition (J2EE), is a set of specifications, extending Java SE with specifications for enterprise features such as distributed computing and web serv ...
application server such as
Tomcat,
Jetty
A jetty is a man-made structure that protrudes from land out into water. A jetty may serve as a breakwater (structure), breakwater, as a walkway, or both; or, in pairs, as a means of constricting a channel. The term derives from the French la ...
,
IIS, or
Apache
The Apache ( ) are several Southern Athabaskan language-speaking peoples of the Southwestern United States, Southwest, the Southern Plains and Northern Mexico. They are linguistically related to the Navajo. They migrated from the Athabascan ho ...
(via
PHP
PHP is a general-purpose scripting language geared towards web development. It was originally created by Danish-Canadian programmer Rasmus Lerdorf in 1993 and released in 1995. The PHP reference implementation is now produced by the PHP Group. ...
).
Features can be added using the public
API
An application programming interface (API) is a connection between computers or between computer programs. It is a type of software interface, offering a service to other pieces of software. A document or standard that describes how to build ...
, or by adding custom
JavaBeans
In computing based on the Java Platform, JavaBeans is a technology developed by Sun Microsystems and released in 1996, as part of JDK 1.1.
The 'beans' of JavaBeans are classes that encapsulate one or more objects into a single standardized ob ...
which can be added to reports. User defined functions (UDF) extend the formula features of the embedded formula calculation routines.
Notes and references
External links
i-net Clear Reports HomepageSample ReportsScreenshots
{{DEFAULTSORT:I-Net Clear Reports
Java platform software
.NET Framework software
Reporting software
Business intelligence software