crosstab subdataset not returning data

[JSquire]

Hi,

 

iReport newbie and would appreciate any assistance.

 

I am trying to fill a crosstab in my subreport summary band using a subdataset (query to mysql - default datasource).

 

The subreport has parameters that I use in my subdataset query. In the crosstab properties I have:

- selected "Use a dataset ....."

- selected the subdataset I want from the drop down in the datasetrun.

- defined the subreport parameters as input to the subdataset (with no default value)

- used $P{REPORT_CONNECTION} connection expression to use the subreport data source.

 

The report compiles and runs but the crosstab does not return any data and no errors. The query itself is fine cause I can run it as the report query (same input parms) instead of a subdataset and I get the data I want.

 

Where am I going wrong?

 

Do I need to define a separate datasource for the subdataset? Tried a few options but cant get the syntax right - can someone please post an example data source expression and how to configure it?

 

Thanks in advance.

[lazyguru]

Did you ever find an answer on this? I am having the exact same problem.

[JSquire]

sorry - been off the radar a while.

Presume you have resolved this by now but just for other users ...... ensure you have defined the parameters feeding into the crosstab correctly.