Temporary table persisting across subdatasets

[contentengineer]

Any advice on the following:

 

(a) Create temporary table of transactional data at beginning of report (in master query?)

(b) Create four separate cross tabs based on queries of temporary table

 

Will the data persist across the subdatasets - i.e. is a new connection made to the database each time?

 

Using Japserserver1.2.0+patch, iReport 1.3.0, SQL Server 2005, jtds/jdbc driver based connection

 

THanks

[contentengineer]

Solved this one.

[chill_work]

Excellent!

 

We recently solved this too. The same connection does persist for all subreports or subdatasets. I have not tried with multiple crosstabs but with multiple subreports; it works. The only thing that we are concern with is doing this for all our reports. If there are 1000+ users using a website, I know that each would get there own connection but couldn't this be detriment to the database? At some point when it can't fit anymore temp tables in memory, it will start caching to disk. This will definitely defeat the performance gain when using temp tables. For now, we are only using them where we know we get a huge performance increase. Any thoughts on this?

 

Calvin