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.

[DellSC]

See my blog here:  How to Speed Up Reports and Prevent Memory Crashes... - SAP Community for more information about how Crystal processes data and things you can do to speed up your reports.

Also, if you haven't already, see Best Practices When Using Commands with Crystal Re... - SAP Community for information about using Commands.  

-Dell

[shibing]

A very big thank you for the great and very interesting links ! Thank You very much.