Java EE (Java Enterprise Edition) General Discussion

Hi,

I am looking at developing a web application, I need to set up an application that would e-mail reports to business users by retrieving data from the database by using sql queries.

Now the reports have to be dynamic in the sense that the format of the data and the content of the report need to be altered...

I am looking at 2 possible solutions...

1) get the data and populate the appropriate velocity template and e-mail the report as html or a PDF file.

2) do the same thing using jasper reports.

I have personally not had a good time with velocity templates when it comes to webapps. so I would really like to know what you guys think?