Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
CrossTab and temporary tables
Migrateduser
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
There are no comments yet