How to use 'Select Expert' to filter data from SQL 'Command Object'?

[Former Member]

I am using Crystal Reports 11.

I created a SQL Command Object under Database Fields, and am wondering:

Can I use 'Select Expert' to filter the fields/data coming from the SQL Command Object?

Or the only way I can do to filter the fields/data is to use SQL queris within Command Object (such as: ... where region="region1" and prodcut="product1" ...)?

Thank you in advance.

Good weekend.

[Former Member]

You should be able to add parameters to the command. Can you post your Sql command, as well as what you want

to select?

[Former Member]

Thnak you V361-V361,

I know how to add parameters to the command.