How to use Multivalue Parameters in Report Editor?

Hello, 

I am a completely new user with this software and I did not find the answer in the documentation/google/youtube so I would need some help, pretty please. 

I received a task to put together some reports in Report Editor.

I'd like to create a "user prompt" with "multivalue" parameter and use it in the "Condition section" on tab "Data sources".

Problem: my report shows no results if I select more than one value but works if only one value is selected.

Here is a copy/paste of my condition (tab Data Sources): 

UID_PersonHead IN (

  SELECT UID_Person 

  FROM Person

  WHERE

    CompanyMember IN (@CompanyParameter) -- multivalue parameter

    AND PersonnelNumber NOT IN ('XXX', 'TEST')

)

Not sure if it matters but I selected "List of permitted values" in the "Parameters --> Value definition". 

Hope anyone can provide some insight on how can multivalue parameters be  used like in the example above. 

Thank you!! :) 

Parents Reply
  • Hi. 

    Thank you for your reply and the link. 

    It definitely looks like a step towards solution but I checked the link and can't figure out how to change the query to make it work. 

    Should I enter plain SQL replace function in it to replace Char(7) with comma? 

    Here's what I have tried: 

    UID_PersonHead IN (

        SELECT UID_Person 

        FROM Person

        WHERE

            CompanyMember IN (REPLACE(@CompanyParameter,char(7),','))

            AND PersonnelNumber NOT IN ('XXX', 'TEST')

    )

    What am I missing? 

Children