Can I Set Read Uncommitted in Crystal without a stored procedure?

[sue1127]

I am using Crystal Reports 8.0 on Ms Sql Server 7.0.

Many users will be viewing a Crystal report on the web, so I need to SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED in order to prevent locking. I know I can do this if I run it as a stored procedure. I would need to convert several already existing reports to run as stored procedures.

Can I SET TRANSACTION... in a regular Crystal report so that it can be used before I am able to convert all the reports to use stored procedures?

Thanks.

Sue

 

[vidru]

A whitepaper on this:

http://support.businessobjects.com/library/kbase/articles/c2006930.asp

-dave

 

[sue1127]

Dave,

Thanks for getting back to me. I looked at the whitepaper you mentioned. My version of Crystal is 8.0.0.395. I don't know if that is appreciably different from 8.0.0.371 that is referred to in the article.

The article seems to be saying that the default in Crystal is an uncommitted read, but that doesn't seem to me to be the case because locks are being set on a Select statement. Also, it sounds as though the solution is to download a dll that will change the Isolation Level for all Crystal Reports. I just want to change it for a few specific reports.

I'm not sure I'm understanding what's involved. I'm not a dba. I was kind of hoping I could just modify the sql by typing in a command to change the isolation level.

Sue

 

[lyanch]

The "read uncomitted" is the default for crystal, however other things can overide that. If you are running SQL that the server can't run in uncomitted, then the server wins. For instance, read uncommited didn't used to work for tables without primary keys in Sybase. So, whenever those table were used, Crystals "read uncommited" didn't work.

I would test the SQL outside crystal and see if you can get the uncommitted read..

Lisa

 

[sue1127]

Lisa,

I actually have run it as a stored procedure outside Crystal, and the locks were still being set. Do you know if there is somewhere that I can learn what might make sql server insist on "read committed"?

I just found out about the SET TRANSACTION ISOLATION LEVEL command, and haven't tried it yet. I'm assuming, from what I've been told, that issuing this command will force a "read uncommitted". But I would like to be be able to do it from a regular Crystal report, not just CR running a stored procedure.

Sue

 

[lyanch]

I would try the SQL server forum. I only have a few scattered reports that I run on SQL right now so I am not up on all the ins and outs. If it is a database reason that the reads aren't dirty then no matter what you do in crystal won't matter. I know I wanted to add the read uncommited command, but it has to be at the start of the SQL which you can't edit in 8.0 (you can edit it, but it won't stay).

Lisa