Link to home
Start Free TrialLog in
Avatar of Steve Marshall
Steve MarshallFlag for United Kingdom of Great Britain and Northern Ireland

asked on

Crystal Reports With Visual Studio - Issues After Upgrade

Hi all,

We have a bit of a strange issue after an upgrade of SAP Crystal Reports for Visual Studio. All applications have build issues after the upgrade because all of the "CrystalDecisions" DLL's seem to have disappeared after the upgrade.

We were running Version 13.0.10.1385 and all was fine with the DLL's all being located and available for referencing. We upgraded to 13.0.21 and all of the DLL's no longer exist on the machine, and all applications using Crystal Reports now have build errors due to the fact that the CrystalDecisions.CrystalReports.Engine.dll, CrystalDecisions.ReportSource.dll, CrystalDecisions.Shared.dll have all disappeared!!

I tested further by removing the new version and replacing the older version and all the issues went away and all was good again. I then reinstalled the new version and the issues come back. There is no error from the install, and it claims that all was successful. I have searched the entire machine and there are no CrystalDecisions DLL files anywhere, so it's not that they have moved them.

It is all very strange ...

Steve
Avatar of Éric Moreau
Éric Moreau
Flag of Canada image

Avatar of Steve Marshall

ASKER

Thanks for that Eric. I will try a repair to see if that addresses my issues.

Steve
I had the to do a repair only on computers where I was deploying the app - not on my development computer.
Ah okay.... I seem to lose all of the DLL's on my development machine after the upgrade.

Steve
Avatar of Mike McCracken
Mike McCracken

How did you do the upgrade on the development machine?

mlmcc
I installed CR 13.0.21.2533 from the downloads, and it said that it would upgrade the existing installation of 13.0.10.1385. That's about it ... The install then ran through, reported success (I did not install the run-time when prompted), and all my DLL's were gone!

Steve
Are you running the installation with admin privileges? Can you do a test of shutting down your Anti-virus for the time of the installation?
Yes, installed from an account with full Admin privs. Will retry with AV shutdown and report back.

Steve
No difference. DLL's gone.

WIth 13.0.10.1385 installed, all of the Crystal Reports DLL's were located in directory

C:\Program Files (x86)\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Common\SAP BusinessObjects Enterprise XI 4.0\win32_x86\dotnet\

One example is CrystalDecisions.CrystalReports.Engine.dll

After the update to 13.0.21.2533 the path exists in the most part, but the final "dotnet" directory is gone. I have searched the entire development PC for CrystalDecisions.CrystalReports.Engine.dll and it does not exist. Obviously this means that any application that has a prior reference to this file (and the others) is now stuffed.

I am going to have to go back to 13.0.10.1385 and stay there. This new version simply does not work on our machines for some reason.

Might even dump CR totally after this nightmare ...

Steve
>>Might even dump CR totally after this nightmare ...

I have been a long time CR user and I am looking into it as well!

Are you installing the developer package from http://downloads.businessobjects.com/akdlm/cr4vs2010/CRforVS_13_0_21.exe?_ga=2.61065964.176562282.1507824215-283503354.1507824215
Yes ... that's the one. I am back at the old version now, but that is what I was installing.

Steve
Okay - update. We have now started the process of dumping Crystal Reports.

The solution is now a .Net application to deal with the interface and all of the grunt work, SQL Server to store the data, and Microsoft Access to generate reports.
 
With surprisingly little effort we have coded a small routine in .Net that takes two parameters - one of the Report Name, the second of the Parameters to that report. The routine looks up the report in a table to determine the location of the Access Database, and then the code of the routine simply interfaces with the Access database via the Microsoft.Office.Interop.Access library. It instantiates an Access Application object, sets the Default Printer Object (which does not affect the user's Default Printer), opens the report, prints it, and then closes down. This all happens very quickly indeed - certainly no slower that Crystal.

In Access all that exists are linked tables, and the report (left set to Default Printer) so that we can override by user.

This is all just proof of concept at the moment, but with about half-an-hour's work we have migrated a report, and have a generic interface to running reports via Access.

I know and accept that this will not be everyone's ideal solution, and that I will likely get lambasted by some, but one thing that Microsoft Access is VERY good at is reports - why not use it for that?

When I have tidied the solution a little I can post example code if anyone is interested, but it definitely works, and works well.

Steve
Good for you. But that wouldn't work in my case because I am not using Access as the database. I am thinking of migrating to another engine like Telerik Report from which I have heard good things.
Hi Eric,

We are not using Access as the "database", purely as a reporting engine in this case. The data is in SQL Server tables, to which the Access database has links. Luckily we have licenses as we do have Access applications in other areas.

Steve
ok that make sense in your scenario
ASKER CERTIFIED SOLUTION
Avatar of Steve Marshall
Steve Marshall
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Workaround. Problem never solved.