crystal reports 12, delphi

Posted on 2009-02-23
Last Modified: 2012-05-06
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?

Question by:CoCoMcB
    LVL 36

    Expert Comment

    by:Geert Gruwez
    not that this will help, but i gave up on Crystal Reports due the same issues
    LVL 4

    Expert Comment

    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.
    LVL 100

    Accepted Solution

    CR 12 or CR 2008 doesn't provide support for .COM technology.

    LVL 5

    Expert Comment

    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
    ShowMessage('Error Connecting');

    this question really should be finalized.
    LVL 40

    Expert Comment

    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.
    LVL 100

    Expert Comment

    As far as i know, you can't.  CR XI is the last version that supports a COM interface.

    LVL 40

    Expert Comment

    I was about to suggest using Delphi to talk to the .NET developer library, but it seems Delphi 12 doesn't support .NET

    "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 (

    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? suggests that this is a possibility, but I'm guessing you'd need to do a lot manually.

    LVL 100

    Expert Comment

    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Introduction The parallel port is a very commonly known port, it was widely used to connect a printer to the PC, if you look at the back of your computer, for those who don't have newer computers, there will be a port with 25 pins and a small print…
    In this tutorial I will show you how to use the Windows Speech API in Delphi. I will only cover basic functions such as text to speech and controlling the speed of the speech. SAPI Installation First you need to install the SAPI type library, th…
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    how to add IIS SMTP to handle application/Scanner relays into office 365.

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now