Filter not working???

[mayocraze]

I have this two detailed filter which are set to be required and before autoaggregation:
[To Currency]in('SGD','USD')
[Reference]<>''

However when I apply prompts to choose "reference" and "currency", in the prompt list, it's still showing all the blank reference and other currency like AUD etc...

Why is th case??? :-[ :-[ :-[

[Arsenal]

If you want the filters in your prompts, then you have to put the filters in the prompt query and not the main report query