Solved

CrystalReportViewer ReadOnly

Posted on 2007-11-30
4
402 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Code works but I need to redo it and assign values to Model 7 33
Syntax Error 2 46
Turn on intranet settings 1 40
Not seen Link button 5 17
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…
This article describes relatively difficult and non-obvious issues that are likely to arise when creating COM class in Visual Studio and deploying it by professional MSI-authoring tools. It is assumed that the reader is already familiar with the cla…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

895 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now