Crystal Reports fail after SQL 2005 database conversion

Posted on 2007-07-23
Last Modified: 2010-05-18
We have converted a SQL Server 2000 Database to SQL Server 2005. Now all the Crystal Reports that we have written that use Stored Procedures will not work. For some reason all Stored Procedures, when looking at them in Crystal Reports have a ";1" added to the name. This is only with the Stored Procedures, not Tables or Views. Pls Help, we have over 200 reports that were written against the SQL 2000 database that now do not work.
Question by:CochiseCounty
    LVL 42

    Expert Comment

    Were you using any repository data in your reports?  If so, you may have clobbered the repository when you did your upgrade - hopefully you took a backup first?

    Also, what version of Crystal are you using?  AFAIK, only XI has been tested with Sql 2005 - earlier versions haven't been tested for compatibility.

    Finally, security might be an issue but I'm assuming you've already looked at that?  Also, I am assuming that the server location and instance name haven't changed?

    Author Comment


    We are not using any repository data. All of your assumptions are correct. We are using Crystal Reports Pro XI. It seems that Crystal Reports only sees stored procedures with the added ';1' behind the name even though the SQL Server Management Studio does not show the stored procedures with the ';1'.

    LVL 42

    Accepted Solution

    If you open one of the existing reports in the designer will it execute there correctly?  If not, will it execute after performing a 'Verify Database'?

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    Suggested Solutions

    Title # Comments Views Activity
    SQL Date from a string 4 41
    Help with SQL joins 9 32
    SQL Server Degrading on Write 13 50
    ms sql + top 1 for each customer 3 22
    So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    737 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