Replacing a combo box with a lookup object
In some cases, lookup objects have advantages over combo boxes. Lookup objects are particularly useful with Select Element actions.
- Create a variable.
 - Insert a lookup object.
 - Double-click the lookup object and click Perform action when icon is clicked in the Format dialog.
 - Select Select element as the action type and Lookup click as the action mode.
 -  
		  In the Inputs section, specify this information: 
		  
- Global list
 - Select the list to be displayed by the lookup object
 - Select element
 - Select the variable that you created in Step 1.
 - Display format
 - By default, element captions are displayed. Optionally, select a different format.
 - Enable multiselection
 - With this option you can select multiple elements
 - Element limit
 - You can specify a maximum number of elements to display for selection. Specify a number or a formula. Or specify No limit.
 - Dialog title
 - The default title is Select Element. You can instead display the name of the global list, or specify a user-defined string. To change the title dynamically, use a formula.
 
 - In the Parameters section, select the variable that you created in Step 1 as the parameter name, and specify =Actions.Result.Text as its value and click OK.
 -  
		  In the Value field of the Format dialog, specify a formula to display the list that is displayed when you click the lookup 
		  This example MEMBERGET formula displays the Product list:
=MEMBERGET("BestPracticesOlap", "analysis", "[product]",ReportVariables.selection.Text, "self") 
Related topics