Crystal Reports Crystal Crashing When Extra Link Added


In Crystal Reports, when I add more than one table in order to add a link, I get the following error message:
Crystal Reports has stopped working.  A problem caused the program to stop working correctly.  Windows will close the program and notify you if a solution is available.

In order to add this other table, I created a new USER DSN and added that DSN to the report.

I took the steps called for, from the following URL, but they did not work:

Specifically, the reg key does not exist on the machine that I'm working on.

I, also, rebooted.  But, that did not solve the problem.

What is the fix, for this, then?

Thank you!

Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Sounds like you are trying to use multiple data sources.

Crystal doesn't really support that.  It can work but it is not recommended.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
TBSupportAuthor Commented:
Hi mlmcc:

I don't really have a choice.  I'm modifying a report that a customer created a long time ago.  Somehow, the data source name that has been used by the report is one that does not even reference the database that it claims to reference.

For example, the report's DSN references the SQL master database.  Yet, if you go to "Show SQL Query", a totally different database altogether is referenced.  

This is the database that I'm trying to bring into the report through this new DSN.  I'm trying to use this "second" DSN to bring in a new table from that database.  I cannot bring in this table through the "first" DSN that the report has always used.

TBSupportAuthor Commented:
Hi Again, mlmcc:

I figured it out, based on some research that I did.  It was along the lines of what you mentioned, and I have composed a short document on this as follows:

If Crystal crashes on you because you are trying to add multiple data sources due to, say, trying to add a new table, change the one data source that you have in the report to the new data source using the instructions below:

1.      Change the Datasource Connection:
1.      From the Current Data Source list (the top box), click once on the datasource connection that you want to change.
2.      In the Replace with list (the bottom box), click once on the new datasource connection.
Click Update.

Thanks, for your help!

It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.