Open Source & Free Adhoc / End User Reporting Tool

reporting adhoc-queries
Santhanam picture Santhanam · Nov 19, 2009 · Viewed 9.1k times · Source

I am looking for an Open Source & Free Browser based Adhoc / End User Reporting Tool preferably based on Java (any other technologies are also welcome).

I have researched on JasperServer Pro, BIRT & Pentaho. Even though these are open source & free, the end user/adhoc reporting components needs to be paid annual license fees which is not quite affordable for us. So please tell you suggestions

Thanks In Advance.

Answer

gamma picture gamma · Jun 12, 2010

Mhm ... I'll throw in a paid one: i-net Clear Reports (used to be i-net Crystal-Clear). The reason I do this is simple: I think it fits your needs, but it's a one time investment if you're happy with what it offers. Its constantly being improved and the support is much better than of the most open source or free communities (that should be taken into account).

The product is entirely Java. It has a powerful ad-hoc reporting component that is made to be an easy-to-use thing for non-technical users. Your users won't have to know anything about reporting at all. They simply select the kind of report, the data et voila there is a report suiting the needs.

The reporting server has a great web GUI for ad hoc reporting (and much more), but you could also access a Java applet.

The end users will not need any training since the GUI is highly intuitive. All reports (depending on security settings) can be accessed via DAV our a report repository gui. The server supports different security settings on a per user or per group basis.

Disclosure: Yep. I work for the company who built this.

Related questions

The permissions granted to user ' are insufficient for performing this operation. (rsAccessDenied)"}

I created a report model using SSRS (2005) and published to the local server. But when I tried to run the report for the model I published using report builder I get the following error. Report execution error:The permissions granted …

Read More
SSRS expression to format two decimal places does not show zeros

I am using the following expression to format my value to show only two decimal points. Which Works fine if the value is not 0. However when the value is 0 it does not show 0. eg. Expression used =Format(Fields!CUL1.Value, "##.##") …

Read More
Passing parameter via url to sql server reporting service

I'm trying to pass a parameter via the url to SSRS and it appears not to work! I'm trying to pass a userId (string) via the url which will be passed to the database and used by the query. base …

Read More