Jasper Reports and Servoy Datasets

Hi,
Is there a way to pass a dataset to the jasper reports plugin ? It would save me recreating the SQL in Jasper ? I saw it somewhere on the forum I’m sure ?
Regards

wvitpr:
I saw it somewhere on the forum I’m sure ?

I think you have seen this thread http://forum.servoy.com/viewtopic.php?f=13&t=12409&st=0&sk=t&sd=a

Can’t help you much further as I have no experience on this…

Phillip,

The latest servoy-jasperreports-plugin from google code supports running reports on a foundset, it does not run reports on a dataset.

If you create the dataset by a query you can use that query in your report…
There is also a possibility to have the entire query as a report parameter and run the report with that.

Rob

rgansevles:
The latest servoy-jasperreports-plugin from google code supports running reports on a foundset, it does not run reports on a dataset.

Will this be possible in the (near?) future?

Passing a query as an argument like you described is nice, but what about - for example - valuelistvalues?
We use a customized method like the one in the ‘svy_utl_valuelists’ module. This is quite a query itself (not even 1 query as well)

We’ve some other requirements (depending on businessrules) that will probably very hard (maybe even impossible) to establish in JasperReports.
Besides, within a SaaS solution we will have distributed code if we have to take care of it from within JasperReports.

If it would be possible to use a dataset this is all much easier, as we can just pass 1 set of data (manipulated from within the solution) to Jasper…

Please post an enhancement request at the google code site.