Solved

CrystalReportViewer ReadOnly

Posted on 2007-11-30
4
407 Views
Last Modified: 2012-06-21
Good Afternoon

Experts:

I am calling the CrystalReportViewer from my vb.net application and am running into a record locking issue.  When setting up the connection, how can I make it READONLY?  

I am using the ReportDocument as the ReportSource in the following line of code:
CrystalReportViewer.ReportSource = RD

So, I am looking at how to pass a setting to the Viewer as READONLY.  I thought I was onto something
with this:
CrystalReportViewer.LogOnInfo.IsReadOnly = True but that does not work since the Property IsReadOnly is ReadOnly.  

How can I tell the connection to be set as READONLY so my CrystalReports do not lock hundreds and thousands of records that don't need to be locked.

Thanks,
jimbo99999

0
Comment
Question by:Jimbo99999
  • 3
4 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 20385065
Crystal should be opening it read-only.  Crystal doesn't have the ability to update the database.

mlmcc
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 20385068
What version of Crystal?

mlmcc
0
 

Author Comment

by:Jimbo99999
ID: 20385155
Version 11

I am trying ot find the equivalent of running a SQL statement using with (nolock).  When running a report
with thousands and thousands of records Users are locking up other Users.  

Thanks,
jimbo99999
0
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 20385314
I haven't run into the issue so I don't know if there is a way.

mlmcc
0

Featured Post

MIM Survival Guide for Service Desk Managers

Major incidents can send mastered service desk processes into disorder. Systems and tools produce the data needed to resolve these incidents, but your challenge is getting that information to the right people fast. Check out the Survival Guide and begin bringing order to chaos.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It seems a simple enough task, yet I see repeated questions asking how to do it: how to pass data between two forms. In this article, I will show you the different mechanisms available for you to do just that. This article is directed towards the .N…
Today I had a very interesting conundrum that had to get solved quickly. Needless to say, it wasn't resolved quickly because when we needed it we were very rushed, but as soon as the conference call was over and I took a step back I saw the correct …

685 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question