Which one is better for reporting tool: open source or charge?

Last Post 03 Feb 2009 10:42 PM by SQLUSA. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
freezea
New Member
New Member

--
21 Dec 2008 02:22 AM
After making reports for a long time, I found something strange recently. Various reporting tool vendors advertise by all means to attract users' attentions; however, programmers show great interests in Jsper report + ireport, the representatives of free and open source Java tool. You can find that it is discussed in full swing in almost all the forums with Java report board, and there are always a lot of questioners.

Why?

Jsper report + ireport are pure Java reporting tools. I believe that the reasons for users to choose them are as follows:
1. They are free, and this is the most important reason.
2. They are professional reporting tools.
3. They are pure Java.
It means that most people have realized that they should make reports with professional reporting tools, not coding, and this is a progress. Now, there are many pure Java reporting tools available, such as JATOOLS, RAQ Report, and Style report, etc. According to users' choice, you will find that free is the deciding factor.

Free and chargeable, which one is better?

It is obviously that free Jsper report + ireport bring us a lot, reporting tool with certain usability, open source code with flexible customization capability and complete control, and the most important, low cost.
But is this really the case?
1. In my opinion, the tabling capabilities of Jsper report + ireport are not very good.
2. Written too minutely, the Help documents of Jsper report + ireport are hard to read. And more important, all of them are chargeable.
3. The tabling logicalities of Jsper report + ireport are not very strong. Sometimes, you may find it very hard to make a complex report with them. For example, if there is a report can not be made directly, you have to write SQL statements troublesomely or ask your clients change their requirements unreasonably.
You can find a great number of consultation posts in forums, and the questioners usually have to wait for answers on line. However, maybe there is no answer to their questions, or there is no one to answer their questions by coincidence. You can count the time and labor cost spent on it. Then, whether it is advisable to buy a chargeable reporting tool?

The advantages of buying a chargeable reporting tool are as follows:
1. The tabling capability of a chargeable reporting tool must be better than a free one.
2. The Help documents are free.
3. When you have a question, you can consult the technical support directly; even ask them to come to help you.

Judging from the social trend, labor division will becomes more and more detailed, and work will becomes more and more professional. In report industry, the optimal condition is that professional reporting tool vendor is the peripheral R&D Center of other companies. Each company gives some money to the vendor for using the reporting tool, while the vendor is dedicated to solve the report problems of all the cooperators.
To sum up, making report is a professional job, and it is advisable for you to buy a chargeable reporting tool. With it, you can do your own job better.

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.
SQLUSA
New Member
New Member

--
03 Feb 2009 10:42 PM
Reporting Services is free with SQL Server 2005, more precisely it is bundled in. If you need support from Microsoft for it, that will cost money. You can get free support on various forums for SSRS like this one.

With Reporting Services, you can do very nice OLAP reports, multi-dimensional and interactive: drill-down and drill-throughs. Can you do it with the jsper report tool?

Kalman Toth, SQL Server 2008 Training
http://www.sqlusa.com


Acceptable Use Policy
---