Isolation Levels Crystal Reports XI and OLEDB

• Richard Williams-416852

  Old Hand

  Points: 374

  More actions

  March 9, 2007 at 4:23 am

  #172635

  Hi,

  we have a large system running many hundreds of users with a relatively small amount of data entry but a vast amount of retrieval one avenue of which is via Crystal Reports XI. Reading round this (and believe me I have) CR always tries to get the highest isolation level when it runs a report which may be causing issues with our application as many of the reports touch data in EVERY table in the database - scary stuff.

  Now the question is, has anyone found a way of telling CR XI (R2) to go for the lowest possible isloation level when reading data? Or, could I be barking up the wrong tree. We do have evidence that when certain reports are run various parts of the application that access data central to the report are hanging until the report session terminates.

  Thanks in advance.

  Richard

• March 12, 2007 at 8:00 am

  This was removed by the editor as SPAM

• MohammedU

  SSCoach

  Points: 19644

  More actions

  March 12, 2007 at 4:48 pm

  #694535

  I don' t know much about CR but lowest leve of ISOLATION leve in SQL is READ UNCOMMITTED where default is READ COMMITTED...

  You may need to set the connection for READ UNCOMMITTED if it is possible in CR configuration...

   

  MohammedU
  Microsoft SQL Server MVP