We are looking to include a quick reporting tool in our WebALDAS data analysis system. What we would like is for a user to be able to select an area of interest such as numbers attending a course, then select a differentiator such as Ethnicity. The tool will then realise that the best way of displaying this data is, for example, a pie-chart, which will be immediately shown to the user. The user would ideally then be able to interact with the pie-chart in some way, using mouse-overs for more detailed information, or exploding segments in order to highlight a point, etc. I would like them also to be able to print out a formatted report ready for meetings or brochures etc. If the user wanted to look at something different such as retention rates on courses differentiated by age group then a pie-chart would not necessarily be the best display mechanism and a stacked column chart might be more appropriate. The system should recognise this and display appropriately. Then the user might want to force a different charting tool to the one automatically selected by the system.
There are some excellent web-based reporting tools available, the best of which we intend to incorporate into WebALDAS as we try to increase its penetration into Government statistics analysis using our unique blend of separating data-analysis from data-management and highly tailored and personalised reports designed specifically for high level users who are short on time.
Tool 1: amCharts
This tool looks excellent and could be just what we need. It has a reasonable range of charting tools and some excellent special features which take advantage of the inherent interactive nature of computer based reporting. Features such as scrollers and the facility to zoom in on complex data, or zoom out for a better overview, all in a very fluid and responsive environment are particularly appealing. The big downside is the requirement for Adobe Flash which may make deployment a little more complex, or more worryingly may make things tricky when trying to provide a service to tightly controlled Government systems. However, this solution does look to be the best bet in most scenarios. The pricing is very good at €85 for a single licence. None of our existing Government clients have a ban on Adobe Flash on the machines we would expect to use this on so at this stage amCharts is looking like a good option.
Tool 2: LogiXML
This tool is extremely impressive. It is very powerful and provides state-of-the-art charting and reporting features. It seems it can create any report you can think of, and many you can’t. It can also deploy its reports using AJAX based HTML providing a rich, responsive experience without the addition complexity of relying on Flash. I am very much for taking away complexity from the user, and by not relying on Flash that is one less thing that can go wrong at the user end. The big problem with LogiXML is the price. It is phenominal and we’re talking in terms of 5 figures here. Also, it’s a little bit like Microsoft Corporate Licensing in that it’s virtually impossible for a mere mortal to get their head around it. For our requirements in this situation I currently think LogiXML is too comprehensive and too expensive. If we had a specific contract willing to pay to have a significant proportion of the power offered by Logi then that would be a different matter.
Another advantage of LogiXML is that it offers both .NET and Java based versions. As we deploy most of our web applications using Apache on Unix machines the Java option means we don’t have to fire up a separate .NET server.
Tool 3: ActiveReports
I have been a keen user of ActiveReports since its very first incarnation as an alternate to the truly dreadful Crystal Reports that was bundled with Microsoft’s Visual Studio. Activereports has always been very powerful and flexible and allows you to create whatever report you need. The charting tools are now pretty comprehensive and they have a Flash based viewer as well as a Web-report viewer. I have not seen any demos of how interactive the web-based viewers are and whether they have the same kind of responsiveness as amCharts. At this stage there is no need for me to look further into Activereports for 3 reasons; (i) they are .NET based and I would rather avoid adding an additional platform to WebALDAS purely to show reports when other options are available, (ii) Flash/Web Report Viewer is required (same as amCharts) so that is an additional negative and (iii) it costs more (the professional edition which has the web report viewer is £1057).
Tool 4: Crystal Reports
I have been through the learning curve of developing with Crystal several times. Each time I have been forced to return to it, because of some legacy app, I always have to go through the learning curve again such is its esoteric nature and unintuitive paradigm. It’s horrible and messy I’m afraid. Whenever we refer to it here we always say the name ‘Crystal’ as if we had a speech impediment such is this tool’s lack of ability to communicate. I really wonder how Crystal got the penetration it did. It’s as if Microsoft was the big kid it hung around with and developed its customer base by telling everyone it was ‘mates with Microsoft’.
Tool 5: Xcelsius
Xcelsius now called SAP Crystal Dashboard Design I think (I can never work out quite what Crystal and its derivitives are going on about) provides a powerful, user generated report designer whereby the user can create their own report from with a web browser. This would be very useful if we needed to give the user report creation facilities. However I think it is fairly well tied into the Business Objects environment and hence the horrible world of Crystal and, having spent some time researching all this, I am not convinced by the concept of giving users the ability to create their own reports as most users want just to see the reports, not to become developers themselves. The learning curve is such that they may as well pay us developers to use our years of experience and specialism to create the reports for them and integrate them into the systems ready to use.
Conclusion
I think we will try out amCharts because of its price and impressive output. There shouldn’t be too much effort involved in investigating how well we can integrate it and asking a few questions will find out if its reliance on Flash will be too much of a problem. LogiXML could be really useful, but at this stage would be overkill.
Let us know if you have any other reporting tools you would like to recommend that would fit the bill in this situation. I suppose our ideal would be amCharts using AJAX-rich HTML.