Comparison of Finereport reports and Crystal Reports

Finereport report software for the complex format of the report data and the presentation of the Web report, through multi-source sharding, irregular grouping, two-way extension to easily drag and drop to do complex format of the report, making reports from the complex SQL and expression, do not need programming, greatly improve the efficiency of the report production.

The Finereport report has obvious advantages over the Crystal report, whether it is in the form of report design, data presentation, or forms, application integration, etc.

Report Design

In the aspect of report design, the advantages of Finereport report tools are mainly embodied in the following aspects:

• Multi-data source

  Crystal Report report) In theory only supports single data sets, multi-set support depends on the database computing capacity (Fork and union, or write stored procedures), multi-Library is generally difficult to support. Another way of processing is to put multiple data sources in a disguised form into a single data source, and then other operations, not the real meaning of the multi-data source.

• Grouping adjustments, not fully grouped

  Grouping is the most common way of reporting data. The grouping of the Finereport report tools is based on the cell, so deleting the grouping, changing the grouping field, and so on, only needs to manipulate the cell, regardless of the other data in the report. In addition, in many cases, the data is not an enumeration of the complete grouping, but some fixed column, or in the form of grouping, Finereport report provides user-defined groups, only need to add some conditions, you can achieve the purpose of irregular grouping.

  Crystal Report, all the data are divided into strips of the model, delete the group will be related to the group Summary unit deleted, adjust the Group field can only delete the reconstruction, the whole operation is cumbersome, and will cause duplication of work. The irregular grouping, in the Crystal Report, simply modifies the group name and cannot modify other calculations that follow the data.

• Data expansion and cross-table

  Finereport Report Tool data expansion, is bidirectional, that is, the row and column symmetry, horizontal longitudinal direction of the ability of the same, you can easily make cross-report (multilayer), can be the same as the same table to make complex table head.

  The Crystal Report produces cross-reports in a specialized crosstab model whose headers are automatically generated by the wizard and lack flexibility.

• Report Shards

  In complex reports, it is very common that the report is divided into multiple pieces, that is, the entire report is a large, regular report, but can actually be divided into a number of irregular small areas, each region seems to have no connection, but the data can actually be interconnected. Finereport supports multiple data sources, as well as the column-to-row scaling of the data, so that the pieces of the report support independent duplication or mutual computation, and allow the blending of fixed and variable shards.

  The single-table model of the Crystal Report does not support sharding. For the report of the Shard, one kind of processing method is to prepare the data in advance, and the other is to complete by the sub-report stitching. The processing is quite cumbersome, and neither of these treatments can meet the requirements each time, designing the desired report format.

Comparison of Finereport reports and Crystal Reports