Solved

Crystal Reports "Load report failed" error message after deploying windows application (visual studio .net 2003)

Posted on 2004-08-22
10
642 Views
Last Modified: 2012-06-27
Hi,
I keep getting the "Load Report Failed" error message when I try to view Crystal Reports on any machine other than the development machine. Anyone know how to fix this?

Some info:
Development was done using VB.NET, VS.NET 2003
I'm using the bundled version of Crystal Reports (About says "Crystal Reports for Visual Studio .NET")
MS Access database

At first, I tried to simply copy the .exe and Access database to the target machine and run it like that. Everything else works fine, but when I tried to view any reports, I got the "Load report failed" message. I then tried creating a Setup Project and included the following merge modules:
crystal_managed2003.msm
dotnetfxredist_x86.msm
Crystal_Database_Access2003.msm
Crystal_Database_Access2003_enu.msm
Crystal_regwiz2003.msm (also entered the license key)

Tried that but still got the error when I tried to view any reports. I searched the business objects site and ran regsvr32 "C:\program files\common files\Crystal Decisions\1.0\bin\CRQE.dll" like they suggested, but still got the error. I also tried manually copying dbghelp.dll and atl.dll but still no luck.

I finally ended up installing VS.NET on the other machine and copied my entire project over, then re-built on the other computer and still got the error. The only time I was able to successfully view a report was when I created a new report on the other machine (can't view any reports created on the first machine). Does this have anything to do with the path to the Access database? It won't let me set a relative path to the database, so I used the same path on both machines (eg c:\data\db.mdb). Still didn't work though. Why does it only work when I add a new report on the target machine? By the way, I created the reports using the VS.NET Report Expert and selected the database under "Database Files" if that matters.

Any help would be greatly appreciated! Thanks!
0
Comment
Question by:fidke
[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
  • 3
  • 3
  • 2
  • +1
10 Comments
 
LVL 18

Expert Comment

by:DotNetLover_Baan
ID: 11864788
0
 
LVL 18

Expert Comment

by:DotNetLover_Baan
ID: 11864798
Go ahead and deploy the whole application..
http://www.siue.edu/~dbock/cmis460/6-deploy.htm
0
 

Author Comment

by:fidke
ID: 11865018
I already tried following the instructions listed in crnet_deployment.pdf but it didn't work.  For some reason I can't even view reports when I re-build the project on the target machine (I installed vs.net and copied the entire project folder over to the target machine). The only time I could successfully view a report was when I added a new crystal report to the project on the target machine.
0
Independent Software Vendors: 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!

 
LVL 27

Expert Comment

by:planocz
ID: 11873647
0
 
LVL 27

Expert Comment

by:planocz
ID: 11873658
0
 

Author Comment

by:fidke
ID: 11898851
Thanks for the replies everyone, for some reason changing the reports to not embedded resourse fixed it.
0
 
LVL 18

Expert Comment

by:DotNetLover_Baan
ID: 11899009
Please explain a bit more.. exactly what you did.  That would help a lot of people... :)
0
 

Author Comment

by:fidke
ID: 11919478
I'm not too sure what happened either ......... all I did was change the report build action from "Embedded Resource" to "None", then included all the reports in the setup project and it worked. Thinking real hard now, the problem might have been caused by the reports not having the correct path to the database though. I'm using a local Access database and have no idea how to set a relative path to it in Crystal Reports, so I just used an absolute path. To be totally honest, I'm not sure if changing the build action really fixed it or not. The real fix might be that I just happened to change the path to the correct one in the reports when I changed the build action. Either that, or is it possible that when I had the reports as an Embedded Resource, they didn't get updated during compilation since the only thing I changed was the path to the database? That might be why it worked after I changed the build action to "None"? Sorry if this caused any confusion, I was tired and pissed at the time so I don't remember much else :)
0
 

Accepted Solution

by:
ee_ai_construct earned 0 total points
ID: 12006449
Closed, 300 points refunded.
ee_ai_construct (replacement part #xm34)
Community Support Moderator
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

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

Article by: jpaulino
XML Literals are a great way to handle XML files and the community doesn’t use it as much as it should.  An XML Literal is like a String (http://msdn.microsoft.com/en-us/library/system.string.aspx) Literal, only instead of starting and ending with w…
A while ago, I was working on a Windows Forms application and I needed a special label control with reflection (glass) effect to show some titles in a stylish way. I've always enjoyed working with graphics, but it's never too clever to re-invent …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

749 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