Temp Tables & BIRT Reports

Hi,

I'm using BIRT 2.3.2 and we need a report to be able to access a temp table.

We are having problems with BIRT trying to access data in a temp table that is getting built - like the sessions closes before BIRT is able to get the data from it. We basically get an error saying the table is not in the database.

Any help is appreciated.

Thanks,

Al

Find more posts tagged with

Comments

bhanley

How and where is the temp table getting created? Can you use a View instead to give the data structure a bit more permanency?

al91206

We are using a temp table because the data behind it is created by a multi-pass query. This is build when someone accesses the report. I don't believe a view will allow us the same flexibility - is that right?

We are on an Informix DB