Multi value parameters

Posted by: mariekn0wles on 5 March 2019, 11:38 am EST

    • Post Options:
    • Link

    Posted 5 March 2019, 11:38 am EST

    Hi, I am new to using flex report designer and SQL and I’m struggling to find answers within documentation on this website.

    I am trying to set up parameters that work for multi values. I have a parameter for Customer Name, which is linked to the customer database. I can get it to work if you just select one customer, but if you select multiple even through multivalue is TRUE it comes up with ‘no value given for one or more parameters’. My main data source has this in the SQL statement:

    WHERE ([Customer Name] IS NULL OR [customer id] IN ([Customer Name]))

    I’m guessing that I need to do something else to convert the multi value into something that can be queried but I don’t really understand and can’t find any info

    Does anyone have any good documentation on flex report designer that could help so I can minimise the number of posts on here :slight_smile: ?

    Thanks

    Marie

  • Posted 5 March 2019, 7:43 pm EST

    Hello Marie,

    I have created the report with the multivalue parameter for you. Please refer to the attachment.

    Does anyone have any good documentation on flex report designer that could help so I can minimise the number of posts on here :slight_smile: ?

    Sorry to mention, we don’t have any other documentation. Please feel free to revert if you have any query, we are more than happy to help you.

    Thanks.

    MultiValueParameter.zip

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels