Crystal Report

**EyeTalion** · Jun 6th, 2003, 08:14 AM

my reports run fine on my machine...I have Crystal 9 installed...but when I create a setup package and test them on an NT/XP box...I get and error...Load Report Failed...any suggestions?

thanks

**jcfowl** · Jun 6th, 2003, 09:12 AM

I'm guessing the report is embedded in the program. Does the machine have the crystal APIs? As a workaround you may want to try accessing the .rpt file instead of embedding it in the program.

**jhermiz** · Jun 6th, 2003, 09:15 AM

Originally posted by jcfowl
I'm guessing the report is embedded in the program. Does the machine have the crystal APIs? As a workaround you may want to try accessing the .rpt file instead of embedding it in the program.

Not to change the subject here..but I too am using just .rpt files..im not embedding the reports and Im still having problems.

See the post:

http://www.vbforums.com/showthread.p...hreadid=248393

For a better description...maybe someone could help!

Jon

**EyeTalion** · Jun 6th, 2003, 10:15 AM

I'm in DLL HELL...

**jhermiz** · Jun 6th, 2003, 10:16 AM

Originally posted by EyeTalion
I'm in DLL HELL...

I am too

**jcfowl** · Jun 6th, 2003, 10:21 AM

I'm sure you've tried this but it might work
if you copy the dll from the machine that
works to the machine that doesn't. This
probably isn't the problem either but you
should make sure it has the ODBC also.

**EyeTalion** · Jun 6th, 2003, 10:29 AM

not sure what you mean by the ODBC..check if the driver is there?
I'm using OLE Data Provider...jchowl, did you go to HVCC?

**EyeTalion** · Jun 6th, 2003, 11:00 AM

jhermiz, here's a link I found from crystal decsions...it's a fix for 98/ME...I'm using NT/XP, but I still registered the DLL...still the same error

**jcfowl** · Jun 6th, 2003, 11:16 AM

Originally posted by EyeTalion
not sure what you mean by the ODBC..check if the driver is there?
I'm using OLE Data Provider...jchowl, did you go to HVCC?

WOW. you don't know what an ODBC is and you
are asking me if I went to Harvard on the Hudson?!

It was 2 suggestions that I figured you already tried.
Check the date on the dlls for the machine that works
and the one that doesn't.

And check the machine to see if it has an ODBC
connection (thats what we use). I had problems
with the ODBC in the past.

**jhermiz** · Jun 6th, 2003, 11:38 AM

Originally posted by EyeTalion
jhermiz, here's a link I found from crystal decsions...it's a fix for 98/ME...I'm using NT/XP, but I still registered the DLL...still the same error

where is it?

**jhermiz** · Jun 6th, 2003, 12:22 PM

I seriously cant believe no one else has run into this problem???

Mark...if you're out there...maybe you could help...
Surely someone has a listing of the DLL's needed to be packaged, and what DLL's need to be registered!

This is bugging me so bad...I hate reports!

I need to get this thing rolling and everywhere I've looked there has been no info. Someone help me out here...

Jon

**jcfowl** · Jun 6th, 2003, 12:25 PM

some links:

http://www.crystaldecisions.com/prod...s/features.asp
http://support.crystaldecisions.com/library/kbase.asp#
http://www.tek-tips.com/gthreadminde...ev2/4/lev3/100

**jhermiz** · Jun 6th, 2003, 12:28 PM

Originally posted by jcfowl
some links:

http://www.crystaldecisions.com/prod...s/features.asp
http://support.crystaldecisions.com/library/kbase.asp#
http://www.tek-tips.com/gthreadminde...ev2/4/lev3/100

UMM *** is that?

I need support here..not a link on how to join tek-tips. Good lord...the whole point of posting in this thread is to get someone who knows how to help us..not someone giving us a crystal reports site. I know where crystal is and tek tips...trust me ive posted at both of those.

Jon

**jcfowl** · Jun 6th, 2003, 12:29 PM

well good luck.......

**jhermiz** · Jun 6th, 2003, 12:30 PM

Originally posted by jcfowl
well good luck.......

There's a winner...
LOL

**jcfowl** · Jun 6th, 2003, 12:33 PM

Everyones been so nice lately.
Its easy to type tough......

**EyeTalion** · Jun 6th, 2003, 12:33 PM

jhermiz ...try updating these two .DLL's in

C:\Program Files\Common Files\Crystal Decisions\1.0\Bin

CRPE32.DLL
CRQE.DLL

**jhermiz** · Jun 6th, 2003, 12:35 PM

Originally posted by EyeTalion
jhermiz ...try updating these two .DLL's in

C:\Program Files\Common Files\Crystal Decisions\1.0\Bin

CRPE32.DLL
CRQE.DLL

When you say update do you mean package / register / include??

Jon

**EyeTalion** · Jun 6th, 2003, 12:36 PM

jhermiz ...try updating these two .DLL's in

C:\Program Files\Common Files\Crystal Decisions\1.0\Bin

CRPE32.DLL
CRQE.DLL

jchowl...that wasn't an insult to you, it was a question...your screen name sounds familiar...I know what an ODBC is, just wasn't sure by what you meant by checking it...ps, this is a .NET app..I'm not using an ODBC driver to connect, I'm using an OLE Data Provider...

**jhermiz** · Jun 6th, 2003, 12:39 PM

Originally posted by jcfowl
Everyones been so nice lately.
Its easy to type tough......

Im cracking up again...

**Emse Esde** · Jun 6th, 2003, 01:09 PM

I'm seeing double vision.....
http://vbforums.com/showthread.php?s=&threadid=248475

*RDoR - The Redundancy Dept of Redundancy

**EyeTalion** · Jun 6th, 2003, 01:26 PM

When you say update do you mean package / register / include??

if there not there reqister them...and make sure they are the right version you need, depending on the version of Crystal you used to create them...

and yes Emse Esde...I aslo have a post in .NET and still no solution

**jhermiz** · Jun 6th, 2003, 01:30 PM

Originally posted by EyeTalion
if there not there reqister them...and make sure they are the right version you need, depending on the version of Crystal you used to create them...

and yes Emse Esde...I aslo have a post in .NET and still no solution

Ok I understand packaging and registering are totally different things..but is someone going to tell me I'd have to go to each end user's pc and register these files??? That's ridiculious. I still dont have this working. Which files need to be registered? Just the craxdrt9.dll and craxddrt9.dll and the crviewer9.dll???
Thats all I have read about in the Crystals help...I know there are a lot more that are packaged (which I package) but I dont know if anymore need to be registred. This has been the worst part of development so far...I cant believe that crystal (or anyone for that matter) has a solid response..doesnt anyone else run into these issues? No one out there is using vb6, sql server, and cr9?
You've got to be kidding me.

Jon

**EyeTalion** · Jun 6th, 2003, 01:35 PM

jhermiz..I thought you were having the same issue as me..jsut went back and read your problem...disregard those DLL's...sorry

**jhermiz** · Jun 6th, 2003, 01:37 PM

Originally posted by EyeTalion
jhermiz..I thought you were having the same issue as me..jsut went back and read your problem...disregard those DLL's...sorry

o no...so imdoomed...no one will help me...i remember a mark that came into this forum...he was originally helping me ... now i dont know where he is

J
o
n

**ARPRINCE** · Jun 6th, 2003, 01:43 PM

Did you included CR9's MSM (merge modules) files when you created your package?

Also, very important, when packing your VB program with CR9, you need to package the right version of atl.dll file since this is OS Specific. If not, some of your dll's will not be registered when the setup runs.

**jhermiz** · Jun 6th, 2003, 01:45 PM

Originally posted by ARPRINCE
Did you included CR9's MSM (merge modules) files when you created your package?

Also, very important, when packing your VB program with CR9, you need to package the right version of atl.dll file since this is OS Specific. If not, some of your dll's will not be registered when the setup runs.

Prince...keep talking...what merge modules...where do I find these.

Also what version of atl.dll do I need. We're all running win2k, sql server 2k, vb6 and cr9.

Please let me know.

jon

**jhermiz** · Jun 6th, 2003, 01:48 PM

Originally posted by ARPRINCE
Did you included CR9's MSM (merge modules) files when you created your package?

Also, very important, when packing your VB program with CR9, you need to package the right version of atl.dll file since this is OS Specific. If not, some of your dll's will not be registered when the setup runs.

Do I need these merge modules since I did NOT embed my reports into vb. I am using the seperate .rpt files and calling them using a crystal reports object in vb. So I did not import them into my application. So do I still need these?

**jhermiz** · Jun 6th, 2003, 01:50 PM

Originally posted by ARPRINCE
Did you included CR9's MSM (merge modules) files when you created your package?

Also, very important, when packing your VB program with CR9, you need to package the right version of atl.dll file since this is OS Specific. If not, some of your dll's will not be registered when the setup runs.

I have 3 atl.dll files

one is inside WINNT/System32
another is in WINNT\Service Pack Files\i386
and the last is inside: C:\Program FIles\Adobe\Acrobat 6.0\Reader

Im guessing I need to package the first one ?

Do I need to register it on each machine or just package it ?

**ARPRINCE** · Jun 6th, 2003, 02:04 PM

This is for the MSM. Download the file cr9rdcmergemodules.zip if you are not using .NET.

In a nutshell, here is what it is all about:

Crystal Reports now includes merge modules (.msm files) to aid you in deploying the report components needed to run your application.

For trouble-free deployment of Crystal Reports components, it is recommended that you include the Crystal Reports merge modules in your installation. A merge module is a single package used to provide developers with a standard method of delivering all shared code, files, resources, shared code, registry entries, and setup logic. All necessary information required by a Microsoft Windows installer to install a shared component is included in the merge module. The installer package created by a Microsoft Windows installer (.msm files) consumes the merge module. You can then distribute the shared components required by Crystal Reports by including the appropriate .msm files in your .msi file.

http://support.crystaldecisions.com/...&CurrRecord=21

As for the atl.dll, there are several version and as I have said it is OS Specific (9x,NT,2K). I just could not find the link where I found about this since resolving my deployment problem a month ago.

Anyway, the 9.x is around 74KB and the NT is 58KB in size.

**jhermiz** · Jun 6th, 2003, 02:05 PM

Also do I need these merge modules if Im using just vb6? Im not using Visual Studio / .NET or anything.

I read the following from Crystals:
-----------------------------------------------
This file contains the merge modules required for deploying Crystal Reports 9 applications using the Report Designer Component (craxdrt9.dll). These merge modules may be incorporated into MSI-based setup packages to include the appropriate runtime files.
------------------------------------------------

What is an MSI based setup package? How will I package these files? This is a 30 meg download?

Jon

**jhermiz** · Jun 6th, 2003, 02:07 PM

Ok Im downloading that file right now...

But how will I include these files with my application? Is there a specific way or do I include all of them?

For the atl.dll should I include the one from WiNNT\System32?

Thanks Prince...hopefully this will resolve everything.

Jon

**jhermiz** · Jun 6th, 2003, 02:15 PM

Ok unzipped it...its 5 .msm files??? What the heck do I do with these files? Do I just include these files in the packaging? Will they just install as .msm files on the end users PC???

Or do I need to do something else with these files?

Jon

**jhermiz** · Jun 6th, 2003, 02:28 PM

Prince..I read this:

If you are planning to use the Crystal Reports Merge Modules, you will need an installation tool that can create a Microsoft Windows installer file (.msi) to consume the merge modules. The installation tool will also have to support Side-by-side installation.

But what if Im already packaging my vb app using INO??? What do I do with these .msm files? I need to somehow include them??? Do I just package them as .msm files?

Please let me know since this is very urgent now!

Jon

**ARPRINCE** · Jun 6th, 2003, 07:28 PM

Just include them like dependencies upon packaging. So it does not matter whether you are using INO or the packager program that comes with VB.

Read what comes with the ZIP file. You may not need to package all msm files only those that are relevant to your project.

As for the ATL file, I got this somewhere and most probably from CR website. You need the right version of the atl file. Otherwise, a number of CR's dll's will not be registered upon deployment.

**jhermiz** · Jun 6th, 2003, 09:52 PM

Originally posted by ARPRINCE
Just include them like dependencies upon packaging. So it does not matter whether you are using INO or the packager program that comes with VB.

Read what comes with the ZIP file. You may not need to package all msm files only those that are relevant to your project.

As for the ATL file, I got this somewhere and most probably from CR website. You need the right version of the atl file. Otherwise, a number of CR's dll's will not be registered upon deployment.

Ive packaged all of those msm files using ino as well as my app and all those DLL's...This is still not working!!!!

When you say register do you mean "regsvr32 nameofdll.dll"???
Becuase I have registered "crviewer9.dll", "craxdrt9.dll" and "craxddrt9.dll" and this is still not working.

I seriously need to get this working...IM spending wayy too much time with this. Am I missing anything here?

Jon

**ARPRINCE** · Jun 7th, 2003, 12:21 PM

Yup...register the dll but not manually. This was my problem. several CR dlls was not registering during setup. It was only when I was able to change the atl.dll that it resolved my problem.

When you run your setup, document all errors you get (as in ALL ERRORS one-by one) so we might be able to get a better understanding on what's happening and probably give a resolution to your headaches.

**jhermiz** · Jun 8th, 2003, 08:46 PM

Originally posted by ARPRINCE
Yup...register the dll but not manually. This was my problem. several CR dlls was not registering during setup. It was only when I was able to change the atl.dll that it resolved my problem.

When you run your setup, document all errors you get (as in ALL ERRORS one-by one) so we might be able to get a better understanding on what's happening and probably give a resolution to your headaches.

Register the dll but not manually?

What do you mean?

I only have that one error message about active x. Can you post the link to atl.dll. Im having too many problems here!!!

Jon

**ARPRINCE** · Jun 9th, 2003, 10:10 AM

Both versions of Atl.dll can be found on the Crystal Reports cd:

For the Windows 9x Atl.dll (73 kb) go to:

<CD Rom drive>\Windows\System32\Redist\MS\System\Ansi\Atl.dll

For the Windows NT/2000 Atl.dll (58 kb) go to:

<CD Rom drive>:\Windows\System32\Redist\MS\System\Atl.dll

You need to register Atl.dll first using either your installation package or manually with the Regsvr32.exe utility.

**jhermiz** · Jun 9th, 2003, 10:25 AM

So are you saying lets say I have all these files (all the dll's etc). In a folder called "ToPackage" . That I should go into this directory and type:

regsvr32 atl.dll
regsvr32 crviewer9.dll
regsvr32 craxdrt9.dll
regsvr32 craxddrt9.dll

And then after i have registered on my PC then I should package my application?

Thanks,
Jon

Thread: Crystal Report

Thread Tools

Display

Crystal Report

umm..

Brought to you by the RDoR*

Posting Permissions