Hi Mike,

Thank you for your suggestion, I got a friend suggested me to use conditional statement and I found it works properly.

I firstly create a non-queried parameters called FruitQuery with the information below:

Lable: Value:

ALL A

Apple AP

Non-apple NAP

IF @FruitQuery = 'A'

BEGIN

[SQL query]

END

ELSE IF @FruitQuery = 'AP'

BEGIN

[SQL query]

END

ELSE IF @FruitQuery = 'NAP'

BEGIN

[SQL query]

END

Do you think this can be used in this situation as well?

Thanks,

Bruce