Crossbar is an open source server-side reporting framework.

It can pull data from any JDBC accessible database. Ad-hoc queries, simple SQL based reports and more complex model-based reports are all handled by the same presentation layer.

Also, I came across iText, another Java based PDF generator - another is PJ Classic. I'll compare these if and when I need to generate PDF.