Solved

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

Posted on 2004-08-22
10
639 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
Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

 
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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

If you're writing a .NET application to connect to an Access .mdb database and use pre-existing queries that require parameters, you've come to the right place! Let's say the pre-existing query(qryCust) in Access takes a Date as a parameter and l…
1.0 - Introduction Converting Visual Basic 6.0 (VB6) to Visual Basic 2008+ (VB.NET). If ever there was a subject full of murkiness and bad decisions, it is this one!   The first problem seems to be that people considering this task of converting…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.

810 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