Skip to Content
Former Member
Mar 09, 2010 at 12:59 PM

Uncommited isolation level or With no lock for Crystal report


Hi, I have been working with Crystal report for 2005 since long time ago, I have developed a fair amount of reports, most of them not using SP or querys, I have used tables and relations so crystal report itself generates the sql.

Now, I have been told that seems like the reports are constantly locking the records in our database (sql2000) so we want to add the NOLOCK thing or change isolation level to uncommited..... but how can I do that to 200+ reports which are not comming from SP.

I'm usng OLEDB connection to our sql server ....

I appreciate your help!