Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

CrystalReportViewer ReadOnly

Posted on 2007-11-30
4
Medium Priority
?
421 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 101

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 101

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 101

Accepted Solution

by:
mlmcc earned 2000 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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Welcome my friends to the second instalment and follow-up to our Minify and Concatenate Your Scripts and Stylesheets (http://www.experts-exchange.com/Programming/Languages/.NET/ASP.NET/A_4334-Minify-and-Concatenate-Your-Scripts-and-Stylesheets.html)…
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
This course is ideal for IT System Administrators working with VMware vSphere and its associated products in their company infrastructure. This course teaches you how to install and maintain this virtualization technology to store data, prevent vuln…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
Suggested Courses

926 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