Framework 4.0 & Crystal Reports: problem with SetDataSource method

Question

I have a dll build with target framework 3.5 that manage reports; this dll use the version 10.5.3700.0 of CrystalDecisions.CrystalReports.Engine

Now, I have created a new wpf application based on .NET framework 4.0 and I added the report dll reference to project.

I had to install the Crystal Reports for Visual Studio 2010 library (http://www.businessobjects.com/jump/xi/crvs2010/default.asp ) to build the application without errors...now it builds success, but the report print don't work.

It's generate an error when set datasource...the message is:

Unknown Query Engine Error Error in File C:\DOCUME~1\oli15\IMPOST~1\Temp\MyReport {4E514D0E-FC2C-4440-9B3C-11D2CA74895A}.rpt: ... Source=Analysis Server ErrorCode=-2147482942 StackTrace: at CrystalDecisions.ReportAppServer.Controllers.DatabaseControllerClass.ReplaceConnection(Object oldConnection, Object newConnection, Object parameterFields, Object crDBOptionUseDefault) at CrystalDecisions.CrystalReports.Engine.Table.SetDataSource(Object val, Type type) at CrystalDecisions.CrystalReports.Engine.ReportDocument.SetDataSourceInternal(Object val, Type type)

The problem is method ReportDocument.SetDataSource; if I switch my application to framework 3.5 it work, if I use framework 4.0 it generate a report exception. Why?!?!?

Answer 1

Anyone?

Answer 2

Same problem no sultion

---

Johan

Answer 3

Finally!

After 15 hours of debugging tracing i finally figured it out. After digging around in WinDbg i found out that the problem has it root in FW 4.0 Assembly bindning behavor. So to be able to load V1.1 compiled assemblies i needed to add the attribute bolted below to my *.config file.

<startup useLegacyV2RuntimeActivationPolicy="true"><supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.0"/></startup></configuration>

God luck!

---

Johan

Answer 4

exactly! I tried the same thing in these days and seems it works!

Answer 5

Works fine! Ty much man!

Answer 6

Thanks for the post. It definately saves me couple of hours. We moved from VS 2008 to VS 2010 and Crystal Report Document.

SetDataSource() started throwing this error. After I update the app.config file to include your setting, it work like a charm.

Thanks for very useful post.

HD

Answer 7

Thank you, Johan! That resolved similar problem that I was getting.

Answer 8

Hi Guys,

There are few other known issues also. Go to SAP's CR .NET SDK forum for more info and updates: http://forums.sdn.sap.com/forumfilter.jspa?forumID=313

 

When compiling your software use only x86 or x64, do not use AnyCPU and any platform. Issues with distribution packages and bootstrapping

You can not use c:\temp as your default temp folder, name it to anything else like c:\MYtemp. Causes the Database Expert Wizard and set location to crash VS 2010.

And more as we work through the kinks. Most of the issues have now been identified and should be resolved in Service Pack 1 or 2.

Thank you for your support of both VS and CR for .NET 2010.

Don

 

---

Don Williams

Answer 9

I'm kissing your legs :-) Thank you very much.

Answer 10

I have a problem when I refresh my Crystal Report in my Crystal Report Viewer I was invited to enter the parameter to my Crystal Report how could I send the parameters from the Crystal Report Viewer to my Crystal Report without having this interface of parameters   !!!

---

Everything is possible, nothing is impossible. Just try and you will find that.

Answer 11

This post is marked as answered, search first, you'll find sample links to set parameter values in code so it's not prompting you.

Don

---

Don Williams

Answer 12

What's the problem !! I have marked this question as an answer to have so interest  !!

---

Everything is possible, nothing is impossible. Just try and you will find that.

Answer 13

Hi,

 

I am also having the same problem. Above solution solved my problem.

 

Thanks allot!!

Cnu...