Solved

CrystalReportViewer ReadOnly

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

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

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…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

776 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