"For reporting, I would use Jasper Reports (can produce PDF or Excel output). You can run it from within JSP web pages (which run in Tomcat and shown in the browser)."