Skip to Content
0
Former Member
Aug 12, 2009 at 02:47 PM

How can I change connection information using CrystalReport VCL for Delphi?

101 Views

Hello.

We are using CrystalReport XI with Delphi CRPE VCL component. The database connectivity used within the report is ADO. The follwing is basically what we are trying to do:

var

CRPEReport: TCrpe;

begin

CRPEReport:= TCrpe.Create(Self);

try

CRPEReport.ReportName := ReportPath;

if CRPEReport.HasSavedData then

CRPEReport.DiscardSavedData;

CRPEReport.Connect.ServerName := 'New Server';

CRPEReport.Connect.DatabaseName := 'NewDatabase';

CRPEReport.Connect.UserID := 'dbo';

CRPEReport.Connect.Password := 'dbopass';

CRPEReport.Connect.Propagate := True;

CRPEReport.Show;

finally

CRPEReport.Free;

end;

end;

The preview shows data from database that the report was desgined with and it completely ignores the connectivity setting that I put in the code. What am I doing wrong??? Please help. Thanks.