Help with parameter query

[Enea]

I have created a query similar to the following:

SELECT *
FROM CUSTOMERS WHERE VISITED = {?City1} and
CUSTOMER_ID IN(SELECT * FROM CUSTOMERS WHERE VISITED = {?City2});

The query works. I saved it.
I then created a report based on my query, but it does not prompt the user for the paramenters, not even when the user hits refresh?

Why?

 

[DallasAggie]

Did you publish it to Crystal Enterprise? If so, go into CMC and check out the paramater properties...it could be that when you loaded it, it set some default parameters...just go in and set them to 'none'.

Other than that...no idea.

 

[DallasAggie]

UPDATE:

go to Report - Process - Parameters -- > Check "Clear the current parameter value(s)" --- Click "Submit