Jasper Report Tabel Element: passing foundset to dataset

Questions
1

Hi everyone,

I’m trying to get the jasper element “table” running. These tables require a dataset to get their data from.
I tried the same way as with normal variables and just passed the foundset from servoy which is based in a DB table and the parameters.

function onActionReportTable(event) {
 	plugins.jasperPluginRMI.runReport(foundset,'Report_A4_Landscape.jrxml',null,'view',vParameters)
}

This however does not work for tabel elements in jasper. Neither the foundset nor the parameters make it to jasper.
Is there a way to convert the servoy foundset into a jasper dataset or to pass it in another way without getting the data directly from the database?

Cheers
Alexander

2

Hi Alexander,

For a table I normally use a subreport.
The subreport consists of a header (column titles), body (just one row height containing dataproviders) and optionally a footer.

3

Hi Marc,

I’m not sure if I can make it work with just variables in a subreport. The reason is, that the table in the DB is created dynamically, so I don’t know the amount or names of columns in every situation. According to the guides in jasper this can be solved by tables/crosstabs as they can build based on whats in the jasper dataset. But the problem remains of how to pass the foundset into the dataset without accessing the DB directly.