Hi Bevan
I thought that also but tried the code every way I could think of before
posting. The servername property seems to work but databasename was
ignored. I think I will try the File DSN (sounds like what we want :) ).
Rob Martin
Software Engineer
phone 03 377 0495
fax 03 377 0496
web www.chreos.com
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, April 15, 2004 5:12 PM
Subject: [DUG] Re: DUG Crystal reports
> Hi Rob,
>
> Perhaps it's the order of your calls that's the problem? As Rohit showed,
I also set the Propagate before any of the other connection information.
>
> Regards,
>
> Bevan
>
>
> -------Original Message---------
>
> From:"Robert martin" <[EMAIL PROTECTED]>
> To:<[EMAIL PROTECTED]>,
> "NZ Borland Developers Group - Delphi List" <[EMAIL PROTECTED]>
> Cc:
> Subject:Re: [DUG] Crystal reports
> Date:Thu, 15 Apr 2004 16:28:12 +1200
>
> 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
> >
> > Rohit
> >
> > ======================================================================
> > CFL - Computer Fanatics Ltd. 21 Barry's Point Road, AKL, New Zealand
> > PH (649) 489-2280
> > FX (649) 489-2290
> > email [EMAIL PROTECTED] or [EMAIL PROTECTED]
> > ======================================================================
> >
> >
> > _______________________________________________
> > Delphi mailing list
> > [EMAIL PROTECTED]
> > http://ns3.123.co.nz/mailman/listinfo/delphi
> >
> >
>
> _______________________________________________
> Delphi mailing list
> [EMAIL PROTECTED]
> http://ns3.123.co.nz/mailman/listinfo/delphi
>
----------------------------------------------------------------------------
----
> _______________________________________________
> Delphi mailing list
> [EMAIL PROTECTED]
> http://ns3.123.co.nz/mailman/listinfo/delphi
>
_______________________________________________
Delphi mailing list
[EMAIL PROTECTED]
http://ns3.123.co.nz/mailman/listinfo/delphi
