Skip to Content

Transaction is read only Error in Crystal reports


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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Apr 20, 2018 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.


    Add comment
    10|10000 characters needed characters exceeded

    • 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 .