Verify database prompting Crystal 10 RDC

Posted on 2005-04-28
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
    LVL 9

    Accepted Solution

    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

    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?
    LVL 9

    Expert Comment

    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

    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 your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    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…
    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 …
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    729 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

    22 Experts available now in Live!

    Get 1:1 Help Now