Crystal Reports SQL locks

[robbiehall]

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

[Moby-Dick]

do you have access to the underlying t-SQl in CR?

[robbiehall]

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.