ColdFusion Report Options

Question

We are currently using Report Builder with ColdFusion. This report builder did not see any Adobe developments after about 5 years and does not look like he will see it soon.

I need a scalable reporting solution that will work in the cloud without huge licensing implications. I looked at Crystal (which I don't understand the price or what I need) and JasperReports with iReport, and I believe that Microsoft SQL Reporting is also an option.

I would like to get some recommendations about what people use and how you integrated it into ColdFusion. I appreciate that this may not be as easy as a report builder.

We are using Windows 2008 R2 with SQL Server 2008 in the cloud infrastructure.

Whatever solution we come up with, the final report output should be PDF.

Answer 1

I used Crystal Report, SQL Report Builder and ColdFusion Report Builder.

Crystal and SQL Report Builder are much better than ColdFusion Report Builder. As you said, CF is not going anywhere and for me really is a buggy.

The crystal is large, but it becomes very expensive when you want to publish reports on the Internet. A standard product requires a report viewer that installs locally. If you need to publish online, it is much more expensive.

SQL Report Builder is a really good option. Version 3.0 is really good and makes it easy to write advanced SQL queries or call SP and publish on the Internet.

I am a pretty big fan of SQL Report Builder.

Hope this helps.