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.

  1. Create a variable.
  2. Insert a lookup object.
  3. Double-click the lookup object and click Perform action when icon is clicked in the Format dialog.
  4. Select Select element as the action type and Lookup click as the action mode.
  5. 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.
  6. 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.
  7. 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")