mutiple table one dataset

[malia]

Hello,

I have mutiple table  in the same report (6.4.2) based on one dataset , How to execute the query once for the report (not  for each table)

 

Thanks for help

[darth_fader]

That's a really good question. And valid. I think this may not be readily available within Jasper as the entire result set would have to be held in memory until all variations on displaying the data were "filled", and this would in essence bypass jasper's optimization for filling reports efficiently. Not a real problem on small result sets, but holding them in memory wouldn't be scalable.