I have a report in Visual Studio which has a parameter of DrugID. This table contains over 158,000 drug ID's. Currently when the report is run the user selects the drop-down and types in say "W" to find Warfarin. There are several different types of Warfarin based on dosage. They have to scroll down the list FOREVER because the list is still loading ALL the DrugID's. I would like them to be able to have a progressive look up. So, say you type W-A-R and it takes you to all drugID's that start with WAR instead of having to scroll down to find the drug.
Is this something I create in Visual Studio or is this something I have to create in SQL?