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