MySQL Stored procedure use in subreport

[benu]

Hi, Folks,

 

I've been using stored procedures as data sources for my JasperReports for some time now and they've worked great. However, I'm now trying to use a stored procedure for a subreport, with the query on the main report passing a key value to a subreport parameter. The main report query is a simple select statement. The subreport is located in the detail section of the main report.

 

When I run the report - for the first time! - it works: the subreport prints fine. The second and subsequent runs of the report fail with an "invalid SQL" error, source is the subreport.

 

The reports are on JasperServer 1.2.1. The DB is MySQL. I'm using iReport 2.0 to design.

 

Any thoughts? Thanks, Ben