Avatar of Angel02
Angel02
 asked on

Crystal Reports Load report failed

My web application use Crystal Reports to print reports. They have been printing fine but we recently set up a new production server with exactly the same configuration as an existing old server where the CR reports worked fine. The reports are throwing "Load report failed" when tried from the new production server.

Also, if I select the ASP.NET version 1.1 in the IIS on the new server, the reports print fine but if I set the ASP.NET version to 2.0, the reports throw the above error. On the old server though (which has the same configuration as the new one) the reports work fine with 1.1 or 2.0.

I need to use .NET 2.0 on the new server. Please advice.
Crystal ReportsASP.NETVisual Basic.NET

Avatar of undefined
Last Comment
Angel02

8/22/2022 - Mon
vasto

If you are using Crystal reports COM components they may not work with ver 2.0.
Angel02

ASKER
Can you please indicate how can I check that and what I need to do? Thanks.
vasto

What are the Crystal assemblies or dlls referenced in your asp.net project ? Do you have Interops in the bin folder ?
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
Angel02

ASKER
The following crystal dlls are referenced in my project from (C:\Program Files\Common Files\Crystal Decisions\1.1\Managed)

- CrystalDecisions.Crystalreports.Engine.dll (Version: 9.1.9800.23)
- CrystalDecisions.ReportSource.dll  (Version: 9.1.9800.5)
- CrystalDecisions.shared.dll  (Version: 9.1.9800.5)
- CrystalDecisions.Web.dll  (Version: 9.1.9800.10)
- CrystalDecisions.Windows.Forms.dll  (Version: 9.1.9800.10)

The Bin folder has just one interop unrelated to the CR. Its Interop.MSMask.dll
vasto

Mike McCracken

Agree.  SAP/Crystal had to release a special version of CR XI to be compatible with .Net 2.0.  I don't think any other versions are compatible partocularly versions before CR XI  R2 (v11.5)

Also if you are using CR9.1 tghat is probably VS2002 which I don't believe is compatible with .Net 2.0

mlmcc
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Angel02

ASKER
I tried everything as mentioned in the link that was given by Vasto but CR still isn't working.

@mlmcc
Do you suggest that we need to install CR XI R2 (v11.5) on the production server?

I must mention two things:

(1) The development server on which the project is built has .NET 1.1. When I pushed to production some of the features demanded .NET 2.0 so I selected ASP.NET 2.0 in the IIS. Do I need to build the project using .NET 2.0 in the development server? i am not able to open my project in any Visual Studio version other than VS 2003. how can i convert my project to .NET 2.0 if needed?

(2) When i first open the report on ym website, I get the error
"Query Engine Error: 'C:\WINDOWS\TEMP\temp_678d9f17-1f4b-4c8d-86a1-ac7b219e6b7d.rpt' " on ReportDocument.Export().
When I click on it again, the error changes to "Load report failed" at ReportDocument.SetDatabaseLogon.
Does this imply something?

Please find my code attached.
EE-Code.txt
Mike McCracken

Does it run on the development server?

What did you install on the production server?

mlmcc
Angel02

ASKER
Yes. It runs fine on the development server. In fact, it also runs fine on the production server if I select asp.net version as 1.1 in the IIS. (But I need to select 2.0 due to certain requirements)

On the production server, I installed .net 1.1, .net 2.0, visual Studio 2003 and
Crystal Reports for Visual Studio .NET    AAP50-GS00000-U7000RN
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
Mike McCracken

According to this link VS2003 does not work in .Net 2.0
http://forums.asp.net/t/1295526.aspx/1?VS+2003+and+net+framework+2+0+

mlmcc
Angel02

ASKER
OK. So should I build my project in VS 2005/2008 and then publish in production server (or) should i install VS 2005/2008 on Production server?
Mike McCracken

I don't know.  There should be something from VS2005 to install but I doubt it is a full VS2005 install.

mlmcc
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Angel02

ASKER
I installed VS 2005 run-time on the production server. Still no change. I get the same error "Load reports failed". The report works fine with ASP.NET version 1.1 but not with ASP.NET version 2.0. Is this some access issue? Is there any other way to troubleshoot? Please advise.
Mike McCracken

Did you update the program to use VS2005 Crystal?

DId you include the VS 2005 Crystal runtimes on the server?

mlmcc
Angel02

ASKER
I included the Crystal runtimes at C:\Program Files\Common Files\Crystal Decisions. Is this what you were asking about?

About updating the program to use VS2005 Crystal... how do I do that? Do you mean I should run the program using VS 2005? The program is currently built using VS 2003. I am unable to open the program using VS 2005, I believe due to incompatibility. Please advise.
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
ASKER CERTIFIED SOLUTION
Mike McCracken

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Angel02

ASKER
Can you please indicate how can I convert a VS 2003 project to VS 2005. When I try to open my project in VS 2005, it says "unavailable". Is it possible without re-writing the whole code?
Mike McCracken

I don't know.  I believe you can upgrade it but I haven't used VS2003 or 2005.

mlmcc
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Angel02

ASKER
Thank you for the links. I'll work on upgrading the project to VS 2005. Until then looks like the only option is to downgrade the .NET version on the server to 1.1. Thanks for all the help.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.