Acheiving Query Builder with Jasper

[jagbalan]

Hi. Before spending time on evaluation I would like to know whether the below requirement is feasible through Jasper.

 

The requirement is this, a web page allowing business user to use a metadata and define a query. This query would later be converted to SQL and used by the application. The meta-data should also include join informations.

 

Can Jasper help in acheiving this? I see the reports are finally stored as xml.

1. Are there any APIs that will help to get the data generated by this xml in java vectors or collection or something similar?

2. Will jasper allow dynamic creation of reports?

3. How does Jasper support web?

4. Is it possible to see the SQL related to with each report?

 

Thanks for your time

[jagbalan]

Please advice if this has to be posted somewhere else.