Crosstab problem

rhcp

We am using a scripted data source. Now every time that a report is run, it calls the scripted data source multiple times. In most cases 5 times, but some reports it happens 7 times. I tracked the problem down. Not sure how to fix it. It is the crosstab. Since Data source is scripted, the script goes to java code, that hits the db and enriches the data in a loop. It then returns a vector of string[ ] to Birt. The data cube for the crosstab it seems the more groups I have in the data cube the more the we going back to the script and run the same java code again. The number of times this happens to depends on the number of groups we have in the data cube for the crosstab. This is not to say that we are just putting everything in the cube, just an empirical observation.
I would like to make it so that we are going to the db and enriching data just once.

Thanks in advance.

thuston

Each Table or Grid with binding set to a DataSet will probably rerun the query for each instance created. In some cases, you can avoid this by inheriting from a container.