Question Re: Reference for CrystalReports.Engine.ReportDocument object class in Technology Q&A

Reference for CrystalReports.Engine.ReportDocument object class

mbenigni — Wed, 22 Feb 2023 16:28:14 GMT

Hello, all.

I'm trying to build a simple VS2022 test application integrating the trial version of CR2020. There is effectively one line of code:

Dim CrystalReportSource1 As New CrystalDecisions.CrystalReports.Engine.ReportDocument

Which is returning an error:

BC30002 Type 'CrystalDecisions.CrystalReports.Engine.ReportDocument' is not defined.

I need to know what reference to add or Import in order to be able to use this ReportDocument object class (or an alternate object class name, if this has changed to something outside the CrystalDecisions namespace.) I've tried a number of Crystal Reports 14.0 references that looked promising but didn't help. And in previous (CR2008) versions of this same project I had successfully used the following Imports statements, but the targets are no longer found:

Imports CrystalDecisions.Shared
Imports CrystalDecisions.CrystalReports.Engine
Imports CrystalDecisions.ReportSource
Imports CrystalDecisions.CrystalReports.Engine.ReportDocument

Thanks in advance!

Re: Reference for CrystalReports.Engine.ReportDocument object class

mbenigni — Wed, 22 Feb 2023 21:05:40 GMT

Apologies, I may have just answered this question myself. The following Imports appears to work:

Imports CrystalReportSourceLib

Allowing use of this new object class:

Dim CrystalReportSource1 As New CrystalReportSourceLib.PSReportFactory

I do have a follow up question, however. My project builds, but this line:

CrystalReportSource1.FileName = oFile.Name

Throws an exception at runtime:

Public member 'FileName' on type '_ComObject" not found.

I have been unable to find any documentation on the class hierarchy that's not already out of date. Can you provide any information on how to assign a filename to a CR2020 object in VB.NET?

Thank you!

Re: Reference for CrystalReports.Engine.ReportDocument object class

DonWilliams — Wed, 22 Feb 2023 21:29:30 GMT

Crystal Reports installer no longer includes the .NET runtime.

You need to get it from here:

https://wiki.scn.sap.com/wiki/display/BOBJ/Crystal+Reports%2C+Developer+for+Visual+Studio+Downloads

Download the CR for VS 2022 or above EXE, it will prompt at the end to install the 32 bit runtime, click OK.

Note you must install using Run as Administrator by right clicking on the EXE.

Don

Re: Reference for CrystalReports.Engine.ReportDocument object class

mbenigni — Thu, 23 Feb 2023 13:34:02 GMT

Thank you for your reply, Don!

I've already installed CR for VS2022. I believe I would have selected a 64-bit runtime however (if there was an option), since I'm running CR2020 and not CR2016.

Is there some way to confirm that this is configured properly? And should I be looking for specific reference(s) to add in my VS project? Note that the project does currently build with the CrystalReportsSourceLib Imports statement.

If it would help, I could also post my VB.NET source code. A very simple example would illustrate the functionality I'm trying to duplicate from our old CR2008 application.

Best,
Marc

Re: Reference for CrystalReports.Engine.ReportDocument object class

DellSC — Thu, 23 Feb 2023 15:20:54 GMT

With Crystal for VS, you need to reference the version 13.x.x.x assemblies in your application, not the version 14.x.x.x assemblies.

-Dell

Re: Reference for CrystalReports.Engine.ReportDocument object class

mbenigni — Thu, 23 Feb 2023 16:33:19 GMT

Thank you, Dell - this is really valuable information! Can you tell me which references (and corresponding Imports statements) I should be using, or direct me to documentation?

The (formerly working) CR2008 code I'm trying to replicate simply opens source files and exports in various formats. Here's a simplified version:

Imports CrystalDecisions.Shared
Imports CrystalDecisions.CrystalReports.Engine
Imports CrystalDecisions.ReportSource
Imports CrystalDecisions.Windows.Forms

Public Class Form1
Private Sub Form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim CrystalReportSource1 As New CrystalDecisions.CrystalReports.Engine.ReportDocument

CrystalReportSource1.FileName = "\\Server\Templates\test.rpt"
CrystalReportSource1.SetDatabaseLogon("UserName", Environment.GetCommandLineArgs(1))
CrystalReportSource1.ExportToDisk(ExportFormatType.CrystalReport, "\\Server\Results\test.rpt")
CrystalReportSource1.Close()
CrystalReportSource1 = Nothing
End Sub

End Class

Re: Reference for CrystalReports.Engine.ReportDocument object class

DonWilliams — Thu, 23 Feb 2023 18:00:15 GMT

Hi Marc,

See my Blog for upgrading, it answers a lot of your questions:

https://blogs.sap.com/2020/10/30/upgrading-a-visual-studio-2008-2019-.net-project-with-the-latest-cr-.net-sdk-packages/

As Dell noted, don't mix CR runtime. Version 13 is standalone and version 14 if connecting to BOE/CR Server. No longer can connect to those using CR 13 runtime, not needed if you don't.

Main thing to note is you must set all Copy Local to False, clean out your \bin folder of any CR dll's that may have been left over, mixing runtime will cause problems.

Also note with VS 2022 your app.config file should no longer be adding CR references and CR runtime is for you platform and not the OS.

Also, when adding the CR Viewer to your Windows Form be sure you are selecting the right version, I also recommend not browsing to the assemblies but using the Extensions tree in VS to select them

Don

Re: Reference for CrystalReports.Engine.ReportDocument object class

mbenigni — Thu, 23 Feb 2023 18:07:35 GMT

Thanks so much for all of this information, Don! There's a lot to process here, but I'll do some homework and report back.

Best,
Marc

Re: Reference for CrystalReports.Engine.ReportDocument object class

mbenigni — Thu, 23 Feb 2023 20:38:46 GMT

Hello again,

I've followed through your blog article, and a number of other articles linked from there. I did make some progress: it looks like I hadn't properly installed SAP Crystal Reports for Visual Studio after all. After remedying that problem, I now have the following in Programs and Features:

SAP Crystal Reports 2020 SP3 Patch 1
SAP Crystal Reports Runtime Engine for .NET Framework (32-bit)
SAP Crystal Reports Runtime Engine for .NET Framework (64-bit)
SAP Crystal Reports, version for Microsoft Visual Studio (64-bit)

All older versions (Crystal Reports 9, Crystal Reports 2008) have been uninstalled.

However, I'm still not seeing an available COM reference with which to replace/upgrade CrystalDecisions.CrystalReports.Engine, so I'm effectively stuck.

Note I'm trying to build to .NET 6.0 in VS2022 in order to best future-proof this work. Is this platform not supported?

Best,
Marc

Re: Reference for CrystalReports.Engine.ReportDocument object class

DellSC — Thu, 23 Feb 2023 21:14:28 GMT

Those references are correct.

Looking at your code, instead of setting .FileName, you may want to try CrystalReportSource1.Load("\\Server\Templates\test.rpt").

Definitely look at the conversion information at the URL that Don posted below.

-Dell

Re: Reference for CrystalReports.Engine.ReportDocument object class

mbenigni — Fri, 24 Feb 2023 16:48:06 GMT

Thank you, Dell!

When you say "those references are correct", are you referring to the four Imports statements at the top of my code? On build, VS reports that these namespaces cannot be found. As a result, there is an error as soon as I try to create the new CrystalDecisions.CrystalReports.Engine.ReportDocument object. I think the fundamental problem is that I'm not finding the CrystalDecisions.CrystalReports.Engine reference when I try to add a v13.0 COM reference to the project. Is there something about this combination of products (CR2020, VS2022, .NET 6.0) that is not supported?

Best,
Marc

Re: Reference for CrystalReports.Engine.ReportDocument object class

DellSC — Fri, 24 Feb 2023 17:26:17 GMT

You cannot add the COM components directly! They're no longer licensed for direct access from your code. Instead,

1. Right-click on "References" in the Solution Explorer pane and select "Add Reference" to bring up the Reference Manager.

2. Click on "Extensions" on the left. It may take a bit, but you will then see the Crystal Decisions assemblies.

3. Select the 4 assemblies that you have in your Using clause. It will look something like this:

4. Click on "OK".

5. For each of the CrystalDecisions assemblies that you've added, select it under "References" and look at its properties. Make sure that the "Embed Interop Types" property is set to False.

-Dell

Re: Reference for CrystalReports.Engine.ReportDocument object class

mbenigni — Fri, 24 Feb 2023 20:09:29 GMT

Thanks again, Dell! I've made some progress; I think I'm close to having this completed.

I had been struggling because the contents of References Manager looked very different than yours and Don's. It turned out I'd built my project from the WPF Application template rather than the WPF App template. After creating a new project with the latter, VS presents an Assemblies group in Reference Manager. From there, all of the references were available (and Embed Interop Types was False for each by default.)

At this point my code will build without errors or warnings, and it will run all the way through the ExportToDisk method call. (Both my original FileName property setting or your recommended Load method replacement appear to run fine.) However, the app throws an exception on ExportToDisk, indicating:

CrystalDecisions.CrystalReports.Engine.InternalException: 'Failed to open the connection.'

This is strange since SetDatabaseLogon is successful, and any other connection information is embedded in the report. Can you shed any light on this? Are there other required steps that have been added as of CR2020?

Best,
Marc

Re: Reference for CrystalReports.Engine.ReportDocument object class

DonWilliams — Sun, 26 Feb 2023 12:35:52 GMT

Hi Marc,

You don't need to manually install the MSI packages on your DEV PC.

When you install CR for Visual Studio SP33 64b installer (VS 2022 and above) it will install the 64 bit MSI but not show it in Programs and Features. At the end of the install it will prompt if you want the 32 bit runtime, Click OK and install it.

You should only see this for CR for VS, CR Designer doesn't matter for this install:

SAP Crystal Reports Runtime Engine for .NET Framework (32-bit)
SAP Crystal Reports, version for Microsoft Visual Studio (64-bit)

We don't support any higher framework than 4.8 is likely the cause, select 4.7 or 4.8 only.

Almost there...

Uninstall the 64 bit MSI and then repair the installer, because it's going to remove all of the runtime.

Thanks again

Don

Re: Reference for CrystalReports.Engine.ReportDocument object class

DellSC — Mon, 27 Feb 2023 15:29:51 GMT

Do you have any subreports? If so, are you explicitly using SetDatabaseLogon for each of them? If not, that could cause this problem.

Also, I think I recall hearing about an error at one point in time with either ExportToDisk or ExportToStream - the resolution was to use the the other one of these two methods instead. I don't remember which was the correct one, though.

-Dell

Re: Reference for CrystalReports.Engine.ReportDocument object class

mbenigni — Mon, 27 Feb 2023 17:14:40 GMT

Thanks, Don. Before I uninstall/reinstall anything, did you happen to see my reply to Dell's most recent comment above? I was finally able to build a WPF App (not WPF Application) project using .NET 4.7.2, and this exposes all of the correct COM references via the Assemblies tab in the Reference Manager. The only outstanding issue is that my report object's ExportToDisk method is throwing a "Failed to open connection" exception. Do you think that uninstalling the 64-bit CR for VS and reinstalling is likely to correct this?

Thanks again,
Marc

Re: Reference for CrystalReports.Engine.ReportDocument object class

DonWilliams — Mon, 27 Feb 2023 23:47:52 GMT

Hi Mark,

I hate this format, to many threads to follow, I like what every other Forum does, just post in a sequential stream so it's easier to follow the thread and whats been done.

OK, first thing is I don't suggest using the WPF viewer, it hasn't been developed as much as the Windows Form, and getting things fixed is tougher, it's not as robust as the Windows Form.

Open Connection is database client not being in the correct format, 32 or 64 bit, or if it's based on a PC type it tougher to find a 64 bit Client.

Uninstalling the 64 bit runtime doesn't patter at this point, it's the same one the EXE installs.

Single step through your app when you get to the database logon info and mouse over each collection and see what's missing in the collections/property bags.

Don

Re: Reference for CrystalReports.Engine.ReportDocument object class

mbenigni — Tue, 28 Feb 2023 13:49:32 GMT

Thanks for getting back, Dell.

No, there are no subreports - this is a very simple report with just one connection and one data table.

I tried replacing ExportToDisk with ExportToStream, but the latter method doesn't take any parameters relating to destination, filename, etc. Apparently all of this needs to be set up via other properties/ methods in advance, but I can't find any documentation or sample code to illustrate. For the moment ExportToDisk seems closer to working. If you can recommend or link to any documentation concerning ExportToStream I would be grateful.

Best,
Marc

Re: Reference for CrystalReports.Engine.ReportDocument object class

mbenigni — Tue, 28 Feb 2023 13:59:51 GMT

Hi Don,

I couldn't agree more about the non-sequential format of this page. For a couple of days I was convinced my comments were being deleted. 😮

I'm a little bit confused about your distinction between the WPF Viewer vs. Windows Form. My application is a VB.NET WPF Application, but I haven't explicitly added a form or a Viewer object; there is no report viewer or GUI at all. All of my code (and there isn't very much of it) runs at Application Startup and then the app closes.

I think your comment concerning bitness of the database client (data source is IBM DB2 via iAccess) may be relevant. We have both 32- and 64-bit versions of this driver installed. I assumed a 64-bit application would make use of the correct 64-bit driver, but perhaps this is not happening?

I can step through the code to a breakpoint and identify the line that throws the exception, but I'm not sure how to mouse over the collections relating to the database logon info to find missing properties. I'll keep working on this. Please let me know if you have any other thoughts in the meantime, and thanks again.

Best,
Marc

P.S. I made some progress this morning. I experimented with replacing ExportToDisk with Export, to no avail. Then I tried a different report with a different (MS SQL) data source, and that worked. Since I've had success with the IBM driver in the past, I have to assume the application is making the wrong connection (32-bit vs. 64-bit) via ODBC. Continuing to experiment.

Re: Reference for CrystalReports.Engine.ReportDocument object class

mbenigni — Tue, 28 Feb 2023 15:56:28 GMT

Hello again. Based on your last response, and the progress I made this morning, I'm inclined to guess that my ODBC driver is the issue. As I said, we have both the 32-bit and 64-bit System DSN's established - but CR2020 Designer only exposes the 64-bit DSN. Is a 32-bit DSN required in order for a .NET 4.7.2 application to function properly with a CR2020 report? If anything, I would have expected 64-bit to be required.

Best,
Marc