CrossTab and temporary tables

Hi, I'm having a problem when using a Crosstab element with temporary tables.

The temporary tables are created by a stored procedure dataset also in the report.
To ensure my sp is executed I have a hidden data element on the top of the report.

It seems to me, the problem is that the dataset cube (source of the CrossTab) is always accessed BEFORE the sp execution. (Error preparing SQL statement. SQL error #1: The specified table (...) is not in the database...)

Any suggestions ?

Thanks in advance,
Rui Ferreira

P.S - I'm using BIRT 2.3.2 and Informix DBMS.

Find more posts tagged with

Comments

Hans_vd

Hi Rui,

I'm not familiar with Informix, but I know that when using Oracle transactional temporary tables, you should set the data source property Autocommit to False in order to keep the cursor data in memory.

Not sure if this will help you, but it's the only thing I could think of.

Regards
Hans