Does Jaspersoft support sharing temporary tables between the main report and subreports

[david_a_parker]

I am using Jaspersoft Studio 6.3.1 with Sybase SQL Anywhere 12.  When I create a Sybase temporary table by executing a procedure in a Main report, the Subreport cannot find the table.

This technique does work when I execute the procedure in a Java environment, just before generating an IReport with subreports that select from the temporary table.

Does Jaspersoft support creating temporary tables in a main report, for later use in a subreport?  If so, please refer me to documentation of examples and setup.

Thanks, David

[hozawa]

JasperReports just uses the datasource that's provided. Jaspersoft Studio is just a report design tool and not a report generator. Just create a report with Jaspersoft Studio and use Java to generate your report. Following page has a sample of creating a report with subreport.

http://jasperreports.sourceforge.net/sample.reference/subreport/