3 Replies Latest reply: Aug 30, 2011 10:21 PM by mz*441207*ga RSS

    Multiple Default Values in a Multi-Select LOV Parameter?

    mz*441207*ga
      Hi,

      I have a report in BI Publisher standalone version 10.1.3.4. The report has a list of values called org_lov. This lov is attached to a multi-selection p_org_code parameter from which it is desirable to also have multiple default values.

      For example, if org_lov has the following values:
      100
      101
      102
      103
      104
      105
      106

      I would like to have 3 default values and have 100, 101,105 as the defaults if the user doesn't specifically select anything from the LOV. So far my testing has only allowed a single default value.

      Here are my settings:

      Data type = string
      Multiple Selection = checked
      Can select All = checked (all values passed)

      On the Default Value field, I have tried the following:
      1. 100, 101,105
      2. [100, 101,105]
      3. '100', '101','105'
      4. (100, 101,105)
      5. ['100', '101','105']
      6. ('100', '101','105')

      I don't need these default values highlighted in the LOV, I just need it passed correctly to the query (a data template).

      Thank you in advance for any input.