How to write parameterized SQL in crystal report?

[Former Member]

I write the following SQL with crystal report parameter fields, and it is connecting to SQL 2005

Select Name from Customer where CustID = '{?CustID}'

The SQL profiler show that It is an ad-hoc query, how to write parameterized SQL which can reuse Execution Plan.

[former_member183750]

Transferring to Crystal Reports Design forum.

Ludek