Solved

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

Posted on 2004-08-22
10
636 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
  • 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
 
LVL 27

Expert Comment

by:planocz
ID: 11873647
0
6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

 
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

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Well, all of us have seen the multiple EXCEL.EXE's in task manager that won't die even if you call the .close, .dispose methods. Try this method to kill any excels in memory. You can copy the kill function to create a check function and replace the …
Parsing a CSV file is a task that we are confronted with regularly, and although there are a vast number of means to do this, as a newbie, the field can be confusing and the tools can seem complex. A simple solution to parsing a customized CSV fi…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

758 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

17 Experts available now in Live!

Get 1:1 Help Now