Problem with PSql Stored Procedure

[MzKitty]

I'm using Crystal 10 sevice pack 6. My report is using an ODBC connection to a PSql 9.5 stored procedure. The stored procedure creates a temp table and inserts records from 3 different ticket tables. It has one parameter in it that selects which location to load the table with. My report works fine as long as I don't try to put any of the fields from the temp table on the report. If I do, then I get the following error.

Failed to open a rowset. Details: 42000:[Pervasive][ODBC Client Interface][LNA][Pervasive][ODBC Engine Interface][Data Record Manager][SPEng][Pervasive][ODBC Engine Interface]Access denied to a READ-ONLY data source.

I found that this was an issue in Crystal 9.0, but nothing with cr 10.

Does anyone know of a work around or fix for this scenario??

Thanks - Cathy

 

[smcnulty2000]

If you can, try having your SP add an index to the temporary table after it gets built.

I've heard that this can help with access problems in Pervasive.