Skip to main content
A
Anonymous
January 18, 2024

How do I take an existing combo box and make it multi-select?

  • January 18, 2024
  • 2 replies
  • 0 views

We have a combo-box for entity selection on a dashboard however, it only allows a user to select 1 entity at a time. How do I make that comb-box open to multi-select 2 or more entities? I do not see a multi-select true or false option on the combo box form.

Parameter:

abolyard_0-1705601349254.png

Combo Box:

abolyard_1-1705601442758.png

In Dashboard:

abolyard_2-1705601554363.png

 

 

 

 

    2 replies

    S
    sameburn
    January 18, 2024

    Hi. Please check formatting section of the combo box component (click Display Format ellipsis).  There is a multi select option there e.g True or False 

    S
    sameburn
    January 19, 2024

    Hi. As JackLacava  said we don't know your setup. So a lot of variables at play here.

    However from a theoretical point of view you can pass the resukt of that parameter into a list e.g E#Root.List([|!parameterValue!|]) and then pass that into your CV rows / columns

    A
    Anonymous
    January 18, 2024

    Thank you! The multi-select is there. When I select multiple entities the data disapears from the report. Do I need to add a business rule that tells the report to add values together as multiple entities are selected? 

    abolyard_0-1705611789226.png

     

    J
    JackLacava
    January 19, 2024

    Chances are that your report is simply placing that Parameter in the Cube View POV. You cannot have multiple members there, so it breaks.

    You will probably have to restructure the Cube View, at a minimum placing Entities on rows or columns, maybe adding some calculated rows for totals (look up CVC and CVR functions). No Business Rule required.

    A more complex alternative is to use a Pivot Grid instead of a CV, but you will need to create a Data Adapter to feed it, and that is a bit more complicated (not necessarily requiring rules, but you'll need to know your way around Data Adapters).

    Terms & ConditionsAccessibility statement