I've got a few PostgreSQL databases that I would like to run daily queries against to create reports (how many logins, signups, emails sent,...). I was wondering if anyone can recommend a GUI type report building tool (open source to commercial ) that I can install on a Mac/Win7 machine which will connect to the DBs, pull the data and create daily reports. I know of pentaho but am looking for a lighter application initially, and then move into some heavier business intelligence type applications.
