On Mon, 27 Jun 2005 18:46:44 +0300, lysander_fb
<lysandersyahooadress@...> wrote:

> --- In firebird-support@yahoogroups.com, Robert martin <rob@c...> wrote:
>> auto generated by Crystal reports FB (SS 1.5.1.4481) seems to go up to
>> 99% CPU utilization. When this occurs out FB application essentially
>> appears to come to a halt.
>
> I can only confirm what Miroslav was writing. Do NOT use the visual
> query-designer of CR for Firebird-databases. Write your own
> SQL-statements and enter them into the "new command"-field in the
> database assistant of CR.
>

Or do it like me ;) - all SELECT statements with all joins, unions and so
on go into several VIEWs and make the final view which gives you
appropriate data for reporting. Then in Crystal Reports use only that view
and it will generate something like SELECT <list of fields> FROM
VIEW_MY_COMPLEX_REPORT WHERE <some filter>. We have about 300 such views
:) and almost everything works fine.

Cheers,
--
Miroslav Penchev