Table with mixed data from jdbc and scripted data source

remo

I have two data sets A and B:
- A gets its data from a jdbc data source
- B gets its data from a scripted data source

My report consists of a table that displays data retrieved from A. So the data binding of the table is set to A. The individual data items do not have an explicit data binding.
Now I also want to display a few data items from B in the same table. On these items, I manually set the data binding to B.

The generated report looks fine, but takes a long time to execute. I realized, that the expensive "open" method of my scripted data source is being executed for each data item of B in the table, which is not what I want. I would have expected that the "open" method is executed only once per report generation.

How can I improve my report? Do I have to move the code from the data set's "open" method to the data source's "open" method?

Thanks for any advice.
Remo

mwilliams

Hi Remo,

Do you have a key between the two dataSets that you could create a joint dataSet on?