Skip to Content
Former Member
Jul 22, 2008 at 11:01 PM

Reports do not pull data from temporary global tables



I am currently converting our VB5.0 application from using CRPE32.dll to using the RDC. We have work out most of the issue, but we are having an issue with reports that we dynamically build. The user supplies the parameters through a VB gui and we then build the SQL needed to populate the report. The data is being stored in a temporary global table in oracle.

When the report is displayed through the crystal viewer there is no data in the report, but when I run the SQL that is generated in sqlplus I do get back data from the database.

I believe the issue is that the data in the temporary global tables is only available in the current session, and I think crystal is stepping out the current session.

Has anyone experienced a similar issue or have a possible work-around.