Solved

Adding a Crystal Reports 8.5 report to VB6 crashes it

Posted on 2004-09-27
20
967 Views
Last Modified: 2008-01-09
Hi
VB 6 crashes every time I'm trying to add a report I have created using Crystal Reports 8.5 to a project.

Any ideas?
Thanx
0
Comment
Question by:Etzie
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 11
  • 7
20 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 12159650
Have you added the appropriate Crystal dlls to the VB application?

Which edition of Crystal 8.5?

Is Crystal installed on the machine?

Was a previous version of Crystal on the machine?

What method are you using to connect to the report?

What OS?

mlmcc
0
 

Author Comment

by:Etzie
ID: 12159724
-Edition: 8.5.0.217
-Crystal Reports is installed on the machine
-No prevoious editions of Crystal Reports were installed on the machine
-I'm not connecting to the report I'm just trying to add it to my project
-OS: Windows XP Professional

Thanx
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 12160625
Which edition - Professional or Developer?  You need the Developer edition to run Crystal from an application.  The professional edition doesn't include the required ddls.

mlmcc
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:Etzie
ID: 12166755
Developer edition.
I have done it before in previous VB projects hence my confusion.
I'll try to re-install Crystal maybe that will do the trick.

Thanx
0
 

Author Comment

by:Etzie
ID: 12166793
Developer edition Upgrade.
Still, it has worked in the passed.
0
 

Author Comment

by:Etzie
ID: 12166885
Quick update:
I've Uninstalled Crystal and reinstalled it but still no good.

The dlls I'm referencing in my VB project are:
Crystal Reports 8.5 ActiveX Designer Design and Runtime Library
Crystal Reports 8.5 ActiveX Designer Runtime Library
Crystal Reports 8.5 Library
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 12174796
You only need 1 of these
Crystal Reports 8.5 ActiveX Designer Design and Runtime Library
Crystal Reports 8.5 ActiveX Designer Runtime Library

My recommndation unless you need the design features (royalty required) select the Designer Runtime.

That shouldn't be the cause.

DO the reports open in the designer?

mlmcc

0
 

Author Comment

by:Etzie
ID: 12210491
Designer as in Crystal Reports application?
Yes - I've created it in it and now just want to add it to the VB project
0
 

Author Comment

by:Etzie
ID: 12210504
I've experimented a bit and it's not just adding an existing report to a VB project -
VB crushes even when I try to add a new blenk Crystal Report to it.
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 12211366
Looking at the dlls again, I think you are missing one.

CRVIEWER.DLL


mlmcc
0
 

Author Comment

by:Etzie
ID: 12211684
I've added it and removed the Designer Design and Runtime Library.
Still no joy.
It's doing my head in!
It useed to work without any problem in the past and I can't think of anything I have changed.

Thanx
Guy
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 12212197
Is it crashing when you add the report not when you run the project?

If so I would uninstall both CR8.5 and VB.  Reboot.  Reinstall VB.  Reboot.  Reinstall Crystal.

Something must have changed.  

mlmcc
0
 

Author Comment

by:Etzie
ID: 12225120
When I try to add the report.
I agree - something must have changed.
I'll start uninstalling and reinstalling the lot of them :(

Thanx mate
0
 

Author Comment

by:Etzie
ID: 12284199
Hi again
I've uninstalled and reinstalled VB and Crystal Reports yet VB still crashes when I try to add a report to it.
I'm out of ideas at the moment.
Last time I've added a report successfully to a VB project  my OS was Windows 98 and now I use XP pro. Could that effect it?

Thanx
Guy
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 12344144
Could be CR8.5 wasn't tested on XP.  It is supported.  You may have to change the code.

Have you installed the latest CR8.5 service pack?
http://support.businessobjects.com/communityCS/FilesAndUpdates/cr85devwin_en.zip.asp

Here are the latest database drivers
http://support.businessobjects.com/communityCS/FilesAndUpdates/dbexdrvrwin_en.zip.asp

mlmcc
0
 

Author Comment

by:Etzie
ID: 12345024
Hi mlmcc
I've updated to the latest hotfix but still no joy :(

Thanx a lot for trying mate
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 12354265
Do you happen to have a machine you can do a clean install of Win XP then SP2 (if you wish), then VB and the service packs, and finally CR8.5 and the updates.  If this allows you to build applications and add reports then there is something wrong on your machine and a rebuild of it my be needed.

mlmcc
0
 

Author Comment

by:Etzie
ID: 12355360
The strange thing is, I can load a report into a different VB project (older one which has about 4 reports in it - as I said the problem never used to exist) and it's all good.
I've checked and both projects have the same refferences.

Any way, I'm tired of spending time on the problem - I've found a workaround - I open the report by code from within the project:
"Set CrxReport = CrxApp.OpenReport(App.Path & "\Monthly Orders Report.rpt")"
which works fine for me.
I would like to find out one day what the was the problem but I guess it won't be today...

Thanx a million mlmcc
Take care
0
 
LVL 1

Accepted Solution

by:
GhostMod earned 0 total points
ID: 12528682
PAQed with points refunded (500)

GhostMod
Community Support Moderator
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

1. Set up your parameter at the report level as usual, check the box Multi-value, and set the Data Type to String 2. Set the Stored Procedure Parameter to varchar(max)  --<---- This part here is the key to it's success Example:    @cst_key var…
Hi, I am very much excited today since I'm going to share something very exciting Tool used for Analytical Reporting and that's nothing but MICROSTRATEGY. Actually there are lot of other tools available in the market for Reporting Such as Co…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

740 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