Solved

Adding a Crystal Reports 8.5 report to VB6 crashes it

Posted on 2004-09-27
20
932 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
  • 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
 

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
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

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…
Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

747 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

12 Experts available now in Live!

Get 1:1 Help Now