Dear sqlservercentral members,
Hello and a pleasant day.
I would like to ask how to create a dropdown list in which one choice will have the two possible values? In the report I am creating for a certain customer, they need to choose between USA and EUROPE, and BOTH of them…the customer who requested the report wants a <BOTH>, USA, EUROPE should appear on the dropdown choice. In my first work, I declare a parameter (the name is @Country) that allows multiple values, so the output of the dropdown is:
But like what I'd said, the customer wants a dropdown like:
So if the customer selects <BOTH>, it will be both USA and EUROPE.
By the way, here is the query I used:
SELECT * FROM tblInvoice WHERE COUNTRY IN (@Country)
Thank you for any advice that you may give.
"Listen to advice and accept instruction, and in the end you will be wise." -Proverbs 19:20