Skip to Content

Transaction is read only Error in Crystal reports

Apr 19 at 08:28 PM


avatar image
Former Member


I have created a Stored procedure which I need to access it in crystal reports.

The user I am using is already assigned with write access to the temp table.When I execute this procedure in Database it's working fine but when I try to access it in the Crystal reports it's giving me the error: Transaction is read only.

Can anyone suggest the the possible work around?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Ian Waterman Apr 20 at 08:12 AM

It is s separate right to access/create temp tables. It will be a permissions issue as Crystal works fine with SPs using Temp Tables.


Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

yes, I have all the access permissions required.

Figured out the issue,but for got to share.

Cause for the issue is, I have used table name in the stored procedure instead of referring to REFTABLE when inserting the values into the temp table.

Learning is we can only access the temp table via REFTABLE but cannot use it directly .