BookmarkSubscribeRSS Feed
rodrigo_pereira
Obsidian | Level 7

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

 

3 REPLIES 3
TejaSurapaneni
Lapis Lazuli | Level 10
Hi,

Instead of Dropdown, use List Control.

Thanks,
Teja
rodrigo_pereira
Obsidian | Level 7

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

c_clay
Calcite | Level 5

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.

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
Tips for filtering data sources in SAS Visual Analytics

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.

Discussion stats
  • 3 replies
  • 949 views
  • 1 like
  • 3 in conversation