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
1 Answer:
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/