Hello guys,
I would like to apply a search on a drop-down control. Do you know if it's possible or the best workaround for this functionality?
The data on the Drop-down has too many elements and the user would like to do a search to find a specific element.
Thank you in advance.
Cheers,
Rorigo
Hello Teja,
thank you for your answer. I've already tried that before without success.
How can I search for a specific element in a List Control?
Regards,
Rodrigo
Work around:
Add a Text Input-control to your report. Create a parameter on this Text input (say Parameter1).
Add a filter to your Dropdown-object like this:
( LowerCase('ElementName'n) Contains LowerCase('Parameter1'p) )
As the user inputs text in the Text Input-control, the possible choises in the DropDown is limited to those elements that contains the inputted text. The full list of elements is showed in the Drop Down when the TextInput is empty.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.