Comparison between RAQ Report and Crystal Report

Overview:

In Java environment, RAQ Report has obvious advantages in deployment, integration, application and application program interface as a pure Java reporting tool.

In non-Java environment, both RAQ Report and Crystal Report operate in the independent report service mode. Therefore, there is no much difference.

In report design, RAQ Report is obvious more convenient in report plotting than Crystal Report. More important, the data models of RAQ Report make its ability of making complex reports much better than that of Crystal Report. Therefore, the report design efficiency of RAQ Report is much higher than that of Crystal Report.

In report display, there is no much difference between RAQ Report and Crystal Report. RAQ Report only has a few details better than Crystal Report.

Detail Comparison:

Item	RAQ Report	Crystal Report
Deployment and Integration (Java Environment)
Application Integration	Embed applications directly.	Need to deploy an independent server.
Load Balance	Use the load balance system of application server directly.	Need to deploy an independent load balance system.
Database Connection	Use the connecting pool of application server directly.	Need an independent database connection, and this may be a performance bottleneck.
Server Deployment	Pure Java and cross-platform application. There are many successful cases in Unix, Linux and Windows.	Platform-dependent and the configurations in different operating systems will be complex.
Application Program Interface	Abundant, complete and well knit J2EE application program interfaces.	Non-J2EE interface and it connects through network protocol, and statistical chart often adopt the old CGI mode.
Deployment and Integration (Non-Java Environment)	Like Crystal Report, operate in the independent report service mode.	Operate in the independent report service mode.
Report Design
Simple Data List	Support.	Support.
Group Report	Support.	Support.
Cross-tab Report	Support and the cross-tab report can mix or have all kinds of changes like other report types.	Support, but the cross-tab report can not mix with other report types or have any change as an independent type.
Chart	Support.	Support
Horizontal Expansion	Support	Very difficult.
Main-Sub Report	Available and do not need the concept of sub report.	It needs the concept of sub report, and data can not communicate.
Sub Report	Support with unlimited layers, Gridlines can align and zoom. Both horizontal report and vertical report can position automatically.	Support, but it is usually two layers. Horizontal report can not position automatically.
Gridline	Excel-like operations.	Fussy and difficult.
Preformatted Paper Printing	Simple and easy with the base image drawing mode.	Fussy and difficult with the precision measure mode.
Import Excel File	Support, and previously made spreadsheet reports can be used directly.	Non-support, and previously made reports need to be made again.
Report Display
·Display in HTML Mode	Support.	Support.
·Precise Print	Support.	Support.
·Export to PDF File	Support.	Support.
·Export to Excel File	Support distortionless export.	Export data only, and it is difficult to use them.
·Text with Format	Support.	Non-support.
·Print with Page or Column Break	Support both vertical and horizontal print with page break. Page break is forcible.	Support vertical page break only, and can not make column break.
·Other Print Control	Print several pages on a piece of paper. Supplement empty rows. Zoom.	Zoom.
Input	Powerful input function which supports all kinds of control, like drop-down calendar.	Absolutely non-support.

As the comparison is made according to the materials we have got, there may be some inaccuracies in the description of other product’s function. Therefore, it is provided for your information only.

This post is from freezea's blog. You are welcomed cc it anywhere, and please indicate the source.
If you would like to read more articles about reporting tool, you are also welcome to refer to my blog.