Multiselect in parameter query

(2 posts) (2 voices)

Tags:

No tags yet.

  1. Deepak, Member

    Hi,

    I have set up 5 user filters before executing the report,
    Launch Name:
    Business Unit:
    Major Brand:
    Minor Brand:
    Languages:

    All the parameter queries are within procedures for each type.
    For example if user selects launch name the other filter loads automatically based on the selection which is done by passing the mydbr_param values.

    I have now modified the input type of parameter query Major Brand as 'Multi-Select'. I have made necessary changes in my main procedure to handle multi-select values.
    When i initial click on the report i get "No parameters available" for the filter 'Minor Brand'. However when i select a value other than default value in 'Launch Name' the values are populated.

    If i change the Major Brand data type to 'int' in my main procedure "CREATE PROCEDURE sp_DBR_DEMAND_SYS_19_v1_11(inLaunchId int, inBusinessUnit int, inMajorBrand text, inMinorBrand int, inLanguageID int, inLogin varchar(30))" it does not display that message.

  2. myDBR Team, Key Master

    Hi,
    multiselect parameters with linked reports are unfortunately not yet supported.

    --
    myDBR Team


Reply

You must log in to post.