[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 880
  • Last Modified:

crystal reports 12, delphi

I have spent 3 days searching the web, following links that eventually lead to nowhere.
All I want is to use crystal reports 12 with delphi 2007/2009

The functionality needs to :
Print/preview a report
Pass selection criteria
be able to change the database/server/username/password of the report.

I have yet to find a solution.
I have tried :
Using the VCL for Crystal 11, modified to not blow up on the dll version. (error running the report, changing the connection settings did not work)

Importing the Type library for crystalActiveXReportViewerLib12 and writing code for the viewer (again, cannot set the login parameters)

I do not have the .net version of Delphi, only the VCL version.
Has anyone found a solution to this?
Does anyone have any ideas on how to at least make the vcl work?

0
CoCoMcB
Asked:
CoCoMcB
1 Solution
 
Geert GruwezOracle dbaCommented:
not that this will help, but i gave up on Crystal Reports due the same issues
0
 
jswebyCommented:
Did you get anywhere with this? I've just moved up from Delphi 6 where the Crystal 7 VCL was working quite happily. Although I've got the Crystal 7 VCL to work in D2009, we'd now like to move to a newer version of Crystal Reports.
0
 
mlmccCommented:
CR 12 or CR 2008 doesn't provide support for .COM technology.

mlmcc
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
eNarcCommented:
try this
Crpe1.ReportName := 'c:\data6\testdata\custcont.rpt'
Crpe1.Connect.ServerName := '.'
Crpe1.Connect.UserID := '';
Crpe1.Connect.Password := '';
Crpe1.Connect.DatabaseName := 'TestData';
Crpe1.Connect.Propagate := true;
if Crpe1.Connect.Test then
Crpe1.Execute
else
ShowMessage('Error Connecting');

https://forums.sdn.sap.com/thread.jspa?threadID=1244923


this question really should be finalized.
0
 
Richard QuadlingSenior Software DeverloperCommented:
mimcc, so you can't supply a runtime distribution of CR12 / 2008 like you can with the developers edition of CRXI (I currently use CRXI + PHP + COM to create reports at runtime from our simple web based reporting tool).

Sure don't want to lose this if I upgrade.
0
 
mlmccCommented:
As far as i know, you can't.  CR XI is the last version that supports a COM interface.

mlmcc
0
 
Richard QuadlingSenior Software DeverloperCommented:
I was about to suggest using Delphi to talk to the .NET developer library, but it seems Delphi 12 doesn't support .NET

http://en.wikipedia.org/wiki/Embarcadero_Delphi#Versions

"Embarcadero Delphi 2009
Delphi 2009 (Delphi 12, code named Tiburón), added many new features such as completely reworking the VCL and RTL for full Unicode support, and added generics and anonymous methods for Win32 native development. Support for .NET development was dropped from the Delphi IDE. A new product, Delphi Prism, was offered for .NET development in its place. Delphi Prism is a Visual Studio language plug-in, and does not include a RTL or VCL for porting code."

and Crystal Reports only support .NET and Java (http://www.sap.com/solutions/sap-crystal-solutions/developers/index.epx)



I'm looking at a similar problem with PHP+COM+Crystal Reports, but PHP has the ability to load .NET assemblies. The .NET object is mapped through the COM interoperability layer provided by the .NET runtime.

Is this mechanism something that could be emulated in Delphi?

http://www.drbob42.com/examines/examin36.htm suggests that this is a possibility, but I'm guessing you'd need to do a lot manually.

0
 
mlmccCommented:
This question has been classified as abandoned and is being closed as part of the Cleanup Program.  See my comment at the end of the question for more details.
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now