multi select option is not working in report builder

Hemant Karnik 121

hi all

I am trying to generate report in report builder .
i have created a select list and have allowed multiple values to select
have created a filter with 'in' operator
however report builder is not selecting more than one item

can anybody help me ?

Dale Kudusi 3,236 Reputation points

2021-01-29T15:33:26.39+00:00

Hi, @Hemant Karnik
Was the issue resolved?
If any reply is useful for you, please accept it as answer.
If you have any issue or concern, please reply to us directly.
Best Regards.
Hemant Karnik 121 Reputation points

2021-01-29T16:15:56.82+00:00

not yet sir
I am trying a report using stored procedure
Williams, Jeffrey A 481 Reputation points

2021-01-29T17:55:11.323+00:00

If you use a stored procedure - you need to parse the multi-selected string that is passed in using either STRING_SPLIT (2017 or higher) or a custom string split utility. How you construct the SQL will depend on the actual query and the expected results.

Accepted answer

Dale Kudusi 3,236 Reputation points

2021-01-25T02:10:27.267+00:00

Hi,
Please refer to this instruction on

Add a multi-value parameter to a Report.

Please feel free to let us know if you need further assistance.

Best regards.

**
If the Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

multi select option is not working in report builder

0 additional answers

Your answer