Results 1 to 3 of 3

Thread: Crystal Reports SQL locks

  1. #1
    Member
    Join Date
    Aug 2003
    Location
    Wellingborough, Northants
    Posts
    158
    Thanks
    7
    Thanked
    0 times in 0 posts

    Crystal Reports SQL locks

    How do I avoid locking a Sage SQL database when running Crystal Reports 2008?
    I am used to SSRS and Management Studio where I can put in a WITH (NOLOCK) statement, but how do you do it in CR?

    Cheers
    Rob
    The older I get, the faster I was.

  2. #2
    Administrator Moby-Dick's Avatar
    Join Date
    Jul 2003
    Location
    There's no place like ::1 (IPv6 version)
    Posts
    10,662
    Thanks
    53
    Thanked
    383 times in 313 posts

    Re: Crystal Reports SQL locks

    do you have access to the underlying t-SQl in CR?
    my Virtualisation Blog http://jfvi.co.uk Virtualisation Podcast http://vsoup.net

  3. #3
    Member
    Join Date
    Aug 2003
    Location
    Wellingborough, Northants
    Posts
    158
    Thanks
    7
    Thanked
    0 times in 0 posts

    Re: Crystal Reports SQL locks

    No I don't believe so, yo can view the SQL for the linked tables you have, and if you write a formula field you can write SQL, but I am just not sure what happens when the report runs in terms of the database locks on the (in this case Sage 1000) server.
    I am concerned that I may be creating an issue, and cannot even get Activity Monitor to run in Mngmnt Studio when the problem happens.
    The older I get, the faster I was.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Crystal Reports Replacement
    By eldren in forum Software
    Replies: 5
    Last Post: 24-03-2010, 05:34 PM
  2. Replies: 17
    Last Post: 15-07-2007, 03:59 PM
  3. SQL Server Connection string?
    By Stoo in forum Software
    Replies: 7
    Last Post: 04-05-2005, 05:48 PM
  4. Frozen Crystals for crystal clear sound?
    By Steve in forum HEXUS News
    Replies: 0
    Last Post: 10-12-2004, 05:22 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •