Solved

CrystalReportViewer ReadOnly

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

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

This document covers how to connect to SQL Server and browse its contents.  It is meant for those new to Visual Studio and/or working with Microsoft SQL Server.  It is not a guide to building SQL Server database connections in your code.  This is mo…
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 …
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

746 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

12 Experts available now in Live!

Get 1:1 Help Now