Crystal reports accessibility lost within my VB 6.0 application.

I have an application written in VB 6.0 using the built-in crystal reports from 4 yrs ago.

Since then:
Installed CR 8.5 on my PC (developer edition)
Installed VS .NET (which has CR 9.0 I believe)
Ran a CR 8.5 SP2 upgrade which did a lot of unregistering dll's and installing SP2 (via Computer Associates Software Delivery tool, script written in house; I believe it was mainly used to distribute the necessary run-time libraries, but I wanted to try something to fix my problem;  it may have made it worse!)
Ran an install of 8.5 (developer edition) from the actual CD to try and clean up the installation.
Have manually went into the .dsr and replaced the GUID from the 6.0 to the 8.5 version.

When I try to run my app within the IDE, I get "Errors during load.  Refer to [the report].log for details."  This is one step closer than not even being able to load the project cleanly.

I've tried numerous "stabs in the dark" but would like some thoughtful suggestions.  I am not above recreating the reports from scratch, although this would be *several* hours worth of work.  But I at least need to be able to view the details of the current reports.  ".dsr" files cannot be opened within the "real" crystal reports environment, only within the VB IDE which I cannot get to work!

Help!!  Thanks, Emory.
LVL 6
KingDumbNoAsked:
Who is Participating?
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.

JamesPMCDCommented:
One of the great features of Crystal reports is the inablility to use older versions of reports with the newer components. They changed a lot of the backgroud dll components and this tends to mess up every thing else.

We found that the only way to ensure that the reports created in a version prior to CR8 would work was to open each report into the 8.5 environment, verify it and save it in that version. Then repeat the same process in CR9

As for the Source code, you have to remove the references to the dsr files and recreate them on a machine configured with CR9.

0
KingDumbNoAuthor Commented:
When I try to open the .dsr file from within CR8.5, it refuses with the very helpful "invalid TLV" error.  The reports were initially created entirely within the VB 6.0 IDE, if that helps.
0
JamesPMCDCommented:
This is bad. the TLV error is the connection object which could fail anywhere from the password to the formating of the sql command that retrieves the data.

do you have the reports  <reportname>.rpt files saved anywhere?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

mlmccCommented:
What version of CR were the dsr files created with?

The best thing to do is to uninstall CR then reinstall and try again.

When you installed CR8.5 did you update the application references and components?

mlmcc
0
KingDumbNoAuthor Commented:
The log file created by VB when I try to run the application is this:
Line 2: Property OleObjectBlob in crActivityRpt could not be set.
Line 2: Cannot load control crActivityRpt.

Thanks for the help so far.  Any more suggestions?
0
KingDumbNoAuthor Commented:
The initial version of CR was 6.0.  Since everything was done from within the VB IDE, I do not believe there are any other files to turn to.  I have .dsr, .dsx, and .dca files.
0
JamesPMCDCommented:
If you have access to another machine,

Reconfigure it with CR6 and open the project in this version.
Run the report(s) and export them as crystal report.
Take the report to the new system and upgrade them to 8.5. then to CR9.


0

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
KingDumbNoAuthor Commented:
The powers-that-be are building me a new machine as we speak.  I should have it by tomorrow morning, and will update this thread with the results of the lastest instructions.  Thanks.
0
mlmccCommented:
There was a major change in report formats between CR6 and CR8.5.  I believe you can open the reports in CR8.5 and save them as CR8.5 reports.  Then import them into the application as DSRs.

mlmcc
0
KingDumbNoAuthor Commented:
Okay...a day and a half later...

I just got the new PC with VB 6.0 installed and nearly nothing else.  It looks like CR 6 isn't installed, and they are just putting 8.5 on it.  Hopefully that will work since the machine doesn't have VS.NET on it.  We'll see...
0
mlmccCommented:
Glad i could help

mlmcc
0
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
Visual Basic Classic

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.