Compare FineReport and Crystal Reports
-
FineReport reporting software for reporting data to show the complexity of the format and web reports by multi-source fragmentation, irregular grouping, two-way extension to easily drag and drop do complex formatting reports, production reports from out complex SQL and expressions, no need to develop programming, greatly improving the efficiency in the production report. Compare to Crystal Reports, FineReport statements either in report design，data presentation, or form, application integration, etc., Obviously has distinct advantages. Report Design In the report design, the advantages that FineReport reporting tool is mainly reflected in the following aspects: • Multi Data Sources FineReport report design naturally supports multiple data sources (set), with a report of data simultaneously from multiple data tables, multiple different databases, or multiple different user-defined data views, and then directly to operate and calculate with each other in the report to create a final report. And a way to connect data sources are also diversity, supports JDBC, JNDI data sources, such as Oracle, DB2, SQLServer, MySQL, and other mainstream database, custom data source program, the text data source, Hibernate data source, Remedy, etc. At the same time the data source has unlimited scalability to support WebService, SOA and other standard data. Crystal Reports only supports a single data set, in theory, support for multiple sets depends on the computing power of the database (fork by the joint or write stored procedures, etc.), multiple database support is generally difficult. Another approach is to disguise the multiple data sources into a single data source finishing, and then perform other operations, not multiple data sources in the true sense. • Packets Adjustment, imcomplete Separate packets Report data packets are among the most common way. Packet FineReport reporting tools, is built on a cell basis, so removing grouping, changing operations such as grouping field, you only need to operate the cell, independent of the other data in the report. In addition, in many cases, the data is not completely enumeration type grouping, but some fixed ranks, or other forms grouped by segment, FineReport report provides a user-defined groups, you only need to add some conditions to achieve an irregular grouping purposes. Crystal Reports, all of the data model is divided in the ribbon bar which, when you delete a packet grouping related summary unit will be deleted, adjust the grouping field can only delete the reconstru