There rarely is a single "best" of anything; it heavily depends on the circumstances and requirements (of which we know nothing). If JasperReports won't do, I'd probably look into Data Vision and Crystal Reports.
-header
-text
-itemizedlist
-tables
-imported figure etc.
-footer
Actually it is not needed that the reporting engine will execute the sql (maybe select 1 from dual is ok, I'm not sure). All the data will be as parameters.
The number one choice is currently
XML -> DocBook XML -> XSL-FO -> PDF,
but I want also to evaluate the high level reporting engines. The java version which is used is 1.4 or later maybe 1.5.