Sql/ Reporting, Jasrper or Birt


New member
Hi All,

I have two different databases which have mutliple tables. I am currently able to use all tables by using the Datasources plugin. however I would like to be able to generate reports and plot graphs of data queries across tables present withing each database.

Is there a way to use sql query withing jasper without using ireport to generate jrml/jasper files(ireport only supports 1 database at a time, used to generate the reports)

How would you suggesst I go about solving this problem and what are there any better options for reporting in grails?