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

[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.