How embed SAP Crystal Reports in ABL application?

Posted by Piotr Tucholski on 28-Jul-2014 07:17

Hi. I have a question how to embed CR 2013 reports in OE 11 apps? I heard SAP does not support OCX anymore (although after CR installation there are OCX controls in AppBuilder).

Maybe it is possible with .NET?  Is there any proven reporting tool and a way of embedding the reports in ABL apps that could be presented to Progress customer?

Kind regards,

Piotr

OpenEdge Development - Forum
Posted by Brian K. Maher on 28-Jul-2014 08:27

 
Piotr,
 
I have pointed multiple customers to that code.  It is a shell.  It works and you can customize it as needed.
 
Brian
 
[collapse]
From: Piotr Tucholski [mailto:bounce-piotrtt@community.progress.com]
Sent: Monday, July 28, 2014 9:14 AM
To: TU.OE.Development@community.progress.com
Subject: RE: [Technical Users - OE Development] How embed SAP Crystal Reports in ABL application?
 
RE: How embed SAP Crystal Reports in ABL application?
Reply by Piotr Tucholski

Thanks Brian. Have you checked that solution as reliable so we could advise it to our customers?

Stop receiving emails on this subject.

Flag this post as spam/abuse.

[/collapse]

All Replies

Posted by Brian K. Maher on 28-Jul-2014 07:22

Piotr,
 
Search the online knowledgebase for "How to add the .NET Crystal Reports Viewer into a form?".
 
Brian
 
[collapse]
From: Piotr Tucholski [mailto:bounce-piotrtt@community.progress.com]
Sent: Monday, July 28, 2014 8:18 AM
To: TU.OE.Development@community.progress.com
Subject: [Technical Users - OE Development] How embed SAP Crystal Reports in ABL application?
 
How embed SAP Crystal Reports in ABL application?
Thread created by Piotr Tucholski

Hi. I have a question how to embed CR 2013 reports in OE 11 apps? I heard SAP does not support OCX anymore (although after CR installation there are OCX controls in AppBuilder).

Maybe it is possible with .NET?  Is there any proven reporting tool and a way of embedding the reports in ABL apps that could be presented to Progress customer?

Kind regards,

Piotr

Stop receiving emails on this subject.

Flag this post as spam/abuse.

[/collapse]

Posted by Piotr Tucholski on 28-Jul-2014 08:13

Thanks Brian. Have you checked that solution as reliable so we could advise it to our customers?

Posted by Brian K. Maher on 28-Jul-2014 08:27

 
Piotr,
 
I have pointed multiple customers to that code.  It is a shell.  It works and you can customize it as needed.
 
Brian
 
[collapse]
From: Piotr Tucholski [mailto:bounce-piotrtt@community.progress.com]
Sent: Monday, July 28, 2014 9:14 AM
To: TU.OE.Development@community.progress.com
Subject: RE: [Technical Users - OE Development] How embed SAP Crystal Reports in ABL application?
 
RE: How embed SAP Crystal Reports in ABL application?
Reply by Piotr Tucholski

Thanks Brian. Have you checked that solution as reliable so we could advise it to our customers?

Stop receiving emails on this subject.

Flag this post as spam/abuse.

[/collapse]

Posted by Piotr Tucholski on 28-Jul-2014 08:34

Thanks again, Brian!

Posted by Piotr Tucholski on 28-Jul-2014 11:18

Does it matter if I use Crystal Reports 2013 or 2014? With 2014 I get 1 assembly: CrystalDecisions.Data.AdoDotNetInterop

Is it enough?.

I ask as I am getting error compiling the class.

DEFINE PRIVATE VARIABLE crystalReportViewer1 AS CrystalDecisions.Windows.Forms.CrystalReportViewer NO-UNDO.

Line 7: Unable to resolve type information for type CrystalDecisions.Windows.Forms.CrystalReportViewer for field crystalReportViewer1

Regards, Piotr

Posted by Brian K. Maher on 28-Jul-2014 11:23

 
Hi Piotr,
 
I don't know. 
 
First I would browse the class and see if they simply renamed the object or changed the fully qualified class name.
 
If that doesn't work, I think you need to redirect this to SAP.  Ask them where you get can the .NET Report Viewer and reference the CrystalDecisions.Windows.Forms.CrystalReportViewer class explicitly.
 
Brian
 
 
[collapse]
From: Piotr Tucholski [mailto:bounce-piotrtt@community.progress.com]
Sent: Monday, July 28, 2014 12:19 PM
To: TU.OE.Development@community.progress.com
Subject: RE: [Technical Users - OE Development] How embed SAP Crystal Reports in ABL application?
 
RE: How embed SAP Crystal Reports in ABL application?
Reply by Piotr Tucholski

Does it matter if I use Crystal Reports 2013 or 2014? With 2014 I get 1 assembly: CrystalDecisions.Data.AdoDotNetInterop

Is it enough?.

I ask as I am getting error compiling the class.

DEFINE PRIVATE VARIABLE crystalReportViewer1 AS CrystalDecisions.Windows.Forms.CrystalReportViewer NO-UNDO.

Line 7: Unable to resolve type information for type CrystalDecisions.Windows.Forms.CrystalReportViewer for field crystalReportViewer1

Regards, Piotr

Stop receiving emails on this subject.

Flag this post as spam/abuse.

[/collapse]

Posted by Piotr Tucholski on 28-Jul-2014 14:57

Thanks for your advice, Brian. I will report when I get more info.

Regards,

Piotr

Posted by Piotr Tucholski on 31-Jul-2014 03:12

It is possible to install the package CrystalRepoers for Visual Studio but VS must be already installed...

SAP does not publish just the dlls.

I have found the crystaldecisions.windows.forms.dll here:

www.dlldll.com/crystaldecisions.windows.forms.dll_download.html

but registration fails...

Any comments to this would be very much appreciated...

Piotr

Posted by Peter van Dam on 31-Jul-2014 06:47

Not quite true.

The only thing we are just installing is the Crystal Reports Runtime CRRuntime_32bit_13_0_7.msi which contains all DLLs.

Only as a remember that particular version contains a wrong version of PrintControl.DLL so we fetched the right version somewhere else and install and register that separately. I suppose that has been fixed by now.

-peter

Posted by Piotr Tucholski on 01-Aug-2014 07:50

Thanks Peter. I will look for the file in the net.

Piotr

Posted by jdp@qad.com on 01-Aug-2014 10:30

You can download using below link:
Crystal Reports v. 9.1 to CRVS2011 Runtime Distribution & Supported Operating Systems




If I can provide more information or if you would like to discuss any of this further please don't hesitate to contact me.

Regards,
Jyoti Paikaray 
Software Architect, R&D


[collapse]
On 1 August 2014 13:51, Piotr Tucholski <bounce-piotrtt@community.progress.com> wrote:
Reply by Piotr Tucholski

Thanks Peter. I will look for the file in the net.

Piotr

Stop receiving emails on this subject.

Flag this post as spam/abuse.


[/collapse]

Posted by Piotr Tucholski on 01-Aug-2014 11:24

I installed Crystal Reports Runtime CRRuntime_32bit_13_0_8.msi

Seems to be OK. Thank you!

Piotr

Posted by Peter van Dam on 05-Aug-2014 11:12

Hi Piotr,

Sorry for the late reply. Simply add the following assemblies to your assemblies.xml:

o CrystalDecisions.CrystalReports.Engine

o CrystalDecisions.Shared

o CrystalDecisions.Windows.Forms

o CrystalDecisions.ReportAppServer.ClientDoc

o CrystalDecisions.ReportAppServer.Controllers

o CrystalDecisions.ReportAppServer. DataDefModel

o CrystalDecisions.ReportAppServer. ReportDefModel

This will make CrystalDecisions.Windows.Forms.CrystalReportViewer available.

-peter

Posted by Piotr Tucholski on 14-Sep-2014 14:38

Maybe you know if it is possible to run .NET Crystal Reports Viewer described in the below solution when you have not OE Dev Studio but just AppBuilder?

How to add the .NET Crystal Reports Viewer into a form?

This thread is closed