Verify database prompting Crystal 10 RDC

Posted on 2005-04-28
Medium Priority
Last Modified: 2012-08-13
We are converting from crystal 8.5 to 10 using the RDC.  I just found out that the connectivity methods used are different and am working on coding the new one.  We programmatically connect to the appropriate datasource depending on the environment the app is being run in.  In much of the doc covering how to do this, after connecting to each table, they do a database.verify.  This command is causing parameter prompts to pop up on several of our reports.  

A - is it necessary to do this command and
B - if so, how do we do it in such a way that we aren't prompted?

Thanks so much for all your help in advance.
Question by:babybird
  • 2

Accepted Solution

cyberdevil67 earned 2000 total points
ID: 13890825
Hi babybird,

 If I read you right on this, you are programming the table properties of the report to change to the new datasource or connection info. If I have that info right, then no you don't need to do a verify report at all.


Author Comment

ID: 13890972
Yes, you are correct. I'm looping through the tables and deleting the existing connection info and setting the new.

What is the purpose of the verify report?  when would I want to use it?

Expert Comment

ID: 13891013
The verify report is more to check to see if the tables in the report match the tables in the database. And if the database has changed you can then use the verify report to make the database tables in the report upto date.


Expert Comment

ID: 26590208
We have hundreds of reports in a single folder.  Can we write a small program that will open each report and verify each report, accept the prompts on any report tables that have changed and then close.  It takes us at least an hour per client update we perform.

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

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

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…
Suggested Courses
Course of the Month14 days, 6 hours left to enroll

807 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