Skip to Content
0
Former Member
May 09, 2008 at 05:50 PM

How can I stop Crystal reports from locking tables in our SQL db? PLEASE HELP!!!

252 Views

Post Author: kevans

CA Forum: Data Connectivity and SQL

I really need help with this and so far I've had no luck finding a solution on Crystal's knowledge base, forums our even outside of this site.

I recently upgraded from crw8 to crw10 and of course after converting reports and placing them into production I now discovered that crw10 will place locks (blocking) on the SQL tables it is using.

Is there a setting in crystal so I can turn this off? Someone said I can use a statement like ... "with (nolock)" but I can't seem to figure out the correct syntax to use, I'm not even sure if this works since I can't find info on it. I desperately need help!!!

Example - if this is my select statement how would I add the "nolock" to it?

(DateTimeToDate (PDMTimeToDateTime ({call_req.open_date})) >= {?Starting Date}) AND (DateTimeToDate (PDMTimeToDateTime ({call_req.open_date})) <= {?End Date}) AND (if {?Select_Group} <> "ALL" then {ca_contact.last_name} = {?Select_Group} else if {?Select_Group} = "ALL" then true) AND {call_req.type} = {?Type}