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

P.S. Re-posting in this forum as I'd posted in wrong one earlier