Crystal Reports causing my tables to lock while executing.
How can I modify the report so the tables inside of my SQL Server 2000 Database do not lock? Is their an no lock option I can set inside of the Crystal Report to prevent this from happening?
This was a known issue and has been fix. Install all the patches. It may also be that your DB is setting exclusive locks on the database. Check with your DBA or refer to the DB manual.
You can possibly use a command object and the NOLOCK option depending upon your db driver but dirty reads are never a good thing (reporting off data that is being added to, deleted or changed at the same time).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.