Reports do not pull data from temporary global tables

[Former Member]

HI,

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.

[former_member11696 · Accepted solution]

Logon with Private info will work for you as Trista indicated but that API has not been migrated into the .NET SDK and as of CR 2008 RDC is no longer shipped. Only works using ODBC connection.

The issue may be that the data has not been committed. Check your DBA admin guide on how to configure the server to allow "Dirty Reads" or "uncommitted data" or "Transactional Data".

It's not recommended to use this feature though. Example is someone may have written a query to insert 1 million records into the db. If the commit command is not used and dirty reads are enabled your report will return that data.

If its not the issue with uncommitted data then your only option is to use the Private info API or better to use a record set as Trista suggested to support this going forward. Be aware there are limitation to active data as it does consume memory space and there will be limits.

Thank you

[Former Member]

Have you tried using an intermediary layer such as ADO? If you try retrieving the data into a recordset you can determine whether it's an issue with your app in general or with the Crystal runtimes specifically.

If you don't want to consider active data, there's also the LogOnServerWithPrivateInfo method off of the CRAXDRT.Database object, which allows for the reuse of database handles. This call was marked as deprecated and hidden some time ago, though, so I'm not sure whether it works with Crystal Reports XI R1 or R2. It should still work with CR10 as far as I know.