Transaction is read only Error in Crystal reports

[Former Member]

Hi,

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?

[Former Member]

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.

Ian

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