Robert martin wrote:

>You are right, some of the SQL produced by the visual linker is
>terrible. I have written a stored procedure to produce the correct
>results for the report mentioned and now performance is improved to
>about 20s max, with no 'locking up' of Firebird. However we have about
>1000 reports I don't mind if 0.5% of our reports take 20s to run, I just
>don't want them to freeze FB.
>
>Rob Martin
>Software Engineer
>
>phone +64 03 377 0495
>fax +64 03 377 0496
>web www.chreos.com
>
>Wild Software Ltd
>
>

Rob,

I use Crystal (the old version 7) and take a close look on how Crystal
are generating the SQL's, I found some very bad queries, as told by
others, when you have a complex report (generally with lot of outer
joins) try to make a view for this particular case you will be safer and
in control of what's SQL go to the server.

Writing the SQL by hand not solve all the problems since I got problems
when tried to add other fields or change de record selection expression,
something nasty occurs in this case, I can't remeber well, but I avoid
to write the SQL manually, because I had problems earlier.

But, to solve you problem, I think you need to use CS.

see you !


--

Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br



--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.8.2/29 - Release Date: 27/06/2005