Crystal Report - Query in Server

Try to use Crystal Report in these few days. Below is an example of passing parameter to a SQL command to ensure the query is done in server side.

There is no significant different in performance while "where" is used instead of "on".

However, if using "Selection Formula --> Record", all records will be send to client station before records selection and it will cause serious performance downgrade if number of records is large.