Last post Jan 21, 2012 10:37 PM by necro_mancer
Jan 11, 2012 05:47 PM|rhmayer|LINK
I have an ASP.NET 4.0 app developed in VS 2010 with several working Crystal Reports. With my latest report creation, I made a copy of an existing report, modified it by adding some sub-reports in the group footer and report footer, and verified that it
runs properly locally in VS. However, when I deployed it to the web server, it would just hang forever with no report viewer ever appearing on the page. After testing other report modifications with and without sub-reports and not encountering any issues,
I returned to the problem report and now I always get the infamous error message, "Load Report Failed". Restarting IIS and even rebooting the web server have had no effect.
I've run out of ideas of things to check. It's a fairly complex report and I really don't want to recreate it from scratch, but I have in the past run into cases where doing exactly this inexplicably fixed my problems.
Jan 12, 2012 01:39 AM|mayankpathakyours|LINK
is your server supports crystal reports. Because licence is required to run crystal reports on server. Ask your hosting providers for licence of crystal reports or your server supports crystal reports.
Jan 12, 2012 09:51 AM|rhmayer|LINK
Perhaps I wasn't clear enough, but I already have several reports that are working just fine on the web server, so yes, it does support Crystal Reports. I'm just baffled as to why this particular one won't run in that environment. BTW, this is on a company
intranet, not involving any external web hosting providers.
Jan 14, 2012 11:09 PM|necro_mancer|LINK
It is quite normal if you are experiencing issues when deploying Crystal Report 2010 on a server. Based on the error message you experienced, it seems that you have not properly setup/configured your Crystal Report on the PC/server:
1. If you see this error message: "Type 'CrystalDecisions.Shared.CrystalReportsException' in assembly 'CrystalDecisions.Shared, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304' is not marked as serializable", this is due to the fact
that your PC is unable to find the right Crystal Report version on your PC. Please try to UNINSTALL any previous Crystal Report version that you have on your system and then, please install Crystal Report for VS 2010 there. You can go tohttp://downloads.businessobjects.com/akdlm/cr4vs2010/CRforVS_redist_install_64bit_13_0_1.zip
(for 64 bit machine) ORhttp://downloads.businessobjects.com/akdlm/cr4vs2010/CRforVS_redist_install_32bit_13_0_1.zip
(for 32 bit machine) ORhttp://downloads.businessobjects.com/akdlm/cr4vs2010/CRforVS_13_0_1.exe (FULL package)
2. Once you have the CR installed on your system, please make sure you set your Crystal Report to operate on LOCAL SERVICE permission. Please check your application pool and make sure it runs under this permission
3. Please make sure the FULL TRUST read and write permission is set on your working folder
4. Please make sure you copy the CR aspnet_client folder to your working folder
Once you have done all the steps above, your crystal report 2010 should work fine. If you are still experiencing problems with your host, I would truly recommend you to migrate your service to asphostcentral.com.
This host has supported Crystal Report for VS 2010 and any earlier Crystal Report version.
If this post helps you, please mark it as an answer. Good luck!
P.S: Please always make sure you have one Crystal Report version running on your own server. If you have multiple different CR version, your report will not work!
Jan 16, 2012 12:22 PM|rhmayer|LINK
Sorry, but I don't see how any of this applies to my situation. I've already got about a dozen existing Crystal Reports that work just fine in this environment. However, since I've introduced this latest one, which is merely a clone of one of the existing
reports with a couple of sub-reports added, this new report won't run on the server (it works fine on my dev machine running through Visual Studio).
Jan 16, 2012 09:28 PM|necro_mancer|LINK
may I know whether you run your own dedicated server or do you host it on a shared server? If it works locally, it should work on the server and clearly, something is not setup properly on the server
Jan 17, 2012 10:04 AM|rhmayer|LINK
My application is running on a company intranet. I can only presume the setup to be proper since a dozen other reports run on it without any problems.
Jan 20, 2012 02:36 PM|rhmayer|LINK
After my third attempt to recreate my report, now it suddenly works on the web server. Unfortunately, I still haven't gained any insight into where the problem was. Yet another inexplicable case of Crystal weirdness.
Jan 21, 2012 10:37 PM|necro_mancer|LINK
it is good to know that your reports run ok now.
As an alternative to Crystal Report, you can always consider SQL Server Reporting Service (SSRS)