[Webinar] Streamline your web hosting managementRegister Today


Crystal Reports fail after SQL 2005 database conversion

Posted on 2007-07-23
Medium Priority
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
  • 2
LVL 42

Expert Comment

ID: 19547546
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

ID: 19547665

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

frodoman earned 2000 total points
ID: 19547702
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'?

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

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

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 …
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.

612 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