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