Subject Re: [firebird-support] Crystal Reports - cross database queries
Author Alexandre Benson Smith
Hi Rob,

Robert martin wrote:

>I use Crystal as well (although not for cross DB queries). My
>understanding is Crystal pretty much only applies filters on the server
>if grouping is performed. See if you cant add some grouping in and make
>sure the 'perform grouping on server option' is selected.
>Rob Martin
>Software Engineer
>phone +64 03 377 0495
>fax +64 03 377 0496
>Wild Software Ltd
The perform grouping on server is active.

The probelm I tried to show is:
Does not expect Crystal do smart things for you, you should be careful
on how to write the "Record Filters" and check how the query will be
send to the server.

I had the wrong assumption that Crystal could evaluate it before and
prepare the where clause in accordance with it, it's NOT TRUE.

Simple filters like:
{SalesOrder.SalesManID} = {?SalesManID}

will be correct transformed in a where clause like:
SalesOrder.SalesManID = <SomeValue>

the more complexes (envolving formulas, etc.) will not be sent to the
server, even it could be evaluated and choosed between some paterns.

see you !


Alexandre Benson Smith
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil

No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.9.1 - Release Date: 01/04/2005