Shulou(Shulou.com)06/01 Report--

FineReport report software aims at complex format report data and Web report display, through multi-source slicing, irregular grouping, two-way expansion to easily drag and drop reports in complex format, making reports from then on to get rid of complex SQL and expressions, without programming, greatly improving the efficiency of report production.

Compared with Crystal report (Crystal Report), FineReport report has obvious advantages in report design, data display, form, application integration and so on.

Report design

In terms of report design, the advantages of FineReport report tools are mainly reflected in the following aspects:

Multiple data sources

FineReport report design naturally supports multiple data sources (sets). The data of the same report can come from multiple data tables, multiple different databases, or multiple different user-defined data views at the same time, and then directly operate with each other in the report to form the final report.

And there are a variety of ways to connect data sources, supporting JDBC,JNDI data sources, such as Oracle,DB2,SQLServer,MySQL and other mainstream databases, custom program data sources, text data sources, Hibernate data sources, Remedy and so on. At the same time, data sources have unlimited expansibility and can support WebService,SOA and other standard data.

Crystal report (Crystal Report) theoretically supports only single data sets, while the support for multiple sets depends on the computing power of the database (cross multiplication and federation or write stored procedures), and it is generally difficult for multiple databases to support. Another way to deal with it is to organize multiple data sources into a single data source in disguise, and then do other operations, which is not multi-data sources in the real sense.

Adjustment of grouping, incomplete grouping

Grouping is the most common way in report data. The grouping of FineReport report tools is based on cells, so delete grouping, change grouping fields and other operations only need to operate on cells, independent of other data in the report. In addition, in many cases, the data is not enumerated completely grouped, but in the form of fixed rows or segments. FineReport reports provide user-defined grouping, which only needs to add some conditions to achieve the purpose of irregular grouping.

Crystal report (Crystal Report), all the data are divided into striped models, delete the grouping will delete the relevant grouping summary unit, adjust the grouping field can only be deleted and rebuilt, the whole operation is more tedious, and will lead to repetitive work. On the other hand, irregular grouping, in Crystal Report, only modifies the group name and cannot modify the calculation of other following data.

Data extension and crosstab

The data expansion of the FineReport report tool is bi-directional, that is, the rows and rows are symmetrical and the horizontal and vertical directions are the same, so it is convenient to make cross reports (multi-tiers) and complex headers like row tables.

Crystal report (Crystal Report) makes cross reports by using a special crosstab model, and its header is automatically generated according to the wizard, which lacks flexibility.

Report slicing

In the complex report, the phenomenon that the report is divided into multiple pieces is very common, that is, the whole report is a large regular report, but it can actually be divided into several irregular small areas, and there seems to be no connection between each area. but the data can actually be related to each other. Because FineReport supports multiple data sources and the expansion of rows and rows of data, it supports independent repetition or mutual operation of each piece of the report, and allows the mixing of fixed and variable fragments.

The single table model of Crystal report (Crystal Report) does not support fragmentation. For fragmented reports, one method is to prepare the data by programming in advance, and the other is to rely on the splicing of subreports. The processing is quite tedious, and these two processing methods can not meet the requirements every time, and design the required report format.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.