I've been working with Pentaho for a while - it has most of the stuff that you want for reporting, but for more advanced stuff, it gets fairly complicated. There's no real CLI, but it has a scheduler built-in for report generation, no need to use cron. Matt -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Sven Aluoor Sent: Monday, June 28, 2010 1:57 PM To: oracle-l@xxxxxxxxxxxxx Subject: Open Source and UNIX based alternative to "Crystal Reports" from SAP Hi folks I am searching for an Open Source alternative to Crystal Reports and found those: - JasperReports (http://jasperforge.org/projects/jasperreports) - OpenRPT (http://www.xtuple.com/openrpt) - Pentaho Reporting (http://reporting.pentaho.org/) - DataVision (http://datavision.sourceforge.net/) Which project do you recommend me? What are you using? my criteria - should run on Solaris - should have CLI interface for automation (daily reports generated via cron job) - should be simple to use/learn - beautiful visualisations cheers Sven -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l