How to share same database connection within a report

system_migrated

Hi,

We need to run "alter session ..." statement for each report to set NLS_COMP and NLS_SORT for Oracle database. It seems birt report is opening a new connection for each dataset in the report - even though they all use the same data source. We currently don't use the connection pool, but I guess it will be the same issue even then. Few questions,

1) Is there a way for a report to use the same connection for all its datasets?

2) Is there a way to for multiple table objects to share the resultset from the same dataset, i.e, if two tables are using the same dataset I don't want the sql to be run twice - just run once and use the same resultset?

3) How to alter session for the whole report? I was thinking to add a hidden table at the top of the report and alter session in its dataset? Would that work? Is it possible to do this at Data Source level (inside afteropen method) as a script?

If this is not the right forum for these questions, please redirect me to the right place.

Thanks,
-vivek