Re: [DUG] Crystal reports

[Rohit Gupta]

Robert,

we need one for development which is what gets linked in at 
designtime... so its not an issue

Robert martin wrote:

Thanks Rohit

But..  your example works by changing between DSNs  (my code also works for
that:) ).  I would have prefered not to have to create a DSN for every
database the software connects to.  However it seems I may have to o(
Rob Martin
Software Engineer
phone 03 377 0495
fax 03 377 0496
web www.chreos.com
----- Original Message ----- 
From: "Rohit Gupta" <[EMAIL PROTECTED]>
To: "NZ Borland Developers Group - Delphi List" <[EMAIL PROTECTED]>
Sent: Thursday, April 15, 2004 4:00 PM
Subject: Re: [DUG] Crystal reports

 

Excerpt from ours - it works with 8.5 and ODBC.  You do have to
have the ODBC alias setup correctly
           Tables.Propagate  := true;
           Connect.Propagate := true;
           { Connect to Database }
           if Connect.ServerName <> IB_Alias then
           with Connect
           do begin
              ServerName := IB_Alias;
              UserID     := IBNrm_User;
              Password   := IBNrm_Pwd;
              Propagate  := true;
           end;
   

Hi

I am working with an ODBC based crystal report. At runtime I want to be
     

able to change the DB
 

the report is looking at (without having multiple DSN's defined). The
     

crystal Help suggests this is
 

possible using the .connect properties however they seem to be ignored
     

when I set them.
 

var
cr : TCrpe;
cnt : Integer;
begin
cr := TCrpe.Create(Self);
try
cr.ReportName := 'C:\a.rpt';
cr.Connect.Clear;
cr.Connect.DatabaseName := '<CRWDC>DSQ=' + Edit1.Text;
cr.Connect.Propagate := True;
cr.Show;
while (cr.ReportWindowHandle <> 0) do begin
Application.ProcessMessages;
end;
finally
cr.Free;
end;
I have also tried 'Database' instead of 'DSQ' as suggested in the help
     

but to no avail. I am using
 

Crystal 8.5 and the Firebird ODBC driver. Any suggestions?



Rob Martin
Software Engineer
phone 03 377 0495
fax 03 377 0496
web www.chreos.com
     

Regards

   

 



_______________________________________________
Delphi mailing list
[EMAIL PROTECTED]
http://ns3.123.co.nz/mailman/listinfo/delphi