Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Adding a Crystal Reports 8.5 report to VB6 crashes it

Posted on 2004-09-27
20
Medium Priority
?
1,071 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 101

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 101

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
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 

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 101

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 101

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 101

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 101

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 101

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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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…
Hello, In my precious Article  (http://www.experts-exchange.com/Database/Reporting/A_15280-Create-Project-in-Microstrategy-Part-I.html)we saw the Configuration part for Microstrategy which included Metadata Creation and DataSource Preparation as …
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

618 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