generating report or chart by analysing record from database

hi everybody,
Do you have any ideas for generating report and chart?? please tell me! I am boring for generating report and chart for a long time.
The chart and report must be generated from analysing database and it can be integrated or embeded into JSP or may be involved with EJB. please tell me if you have any ideas and as well as the softwares or tools are free.
Best regards,
benjamin