How query Execution Happens in Crystal Reports When Using Both SQL Command and Direct Table?

[shibing]

Hello Everyone,

When I use both SQL Command and Direct Table in crystal server, I see the command query is executing in database independently without considering the other direct tables linked to the "Command Query" at the "Database Expert".

Any knowledge someone share will be very valuable ! Thank you all in advance !

@DellSC

[ido_millet · Accepted solution]

Yes, with mixed Command/Table scenario, Crystal joins to Command on the client side, which makes the process much slower.  To avoid this problem, use a single Command as the data source, or move the data logic to a VIEW or Stored Procedure on the back end.

[shibing · Accepted solution]

Many thanks for the quick response! Thank You.