Hi @SQLIsGood-7036 ,
The issue is a little hard to narrow down.
Have you pass the value to the parameter?
Here is a blog about passing-multi-value-parameter-in-stored-procedure-ssrs-report for your reference.
Also recommend that you avoid using the sp_ prefix for naming stored procedures as this is a reserved prefix for system stored procedures.
Regards,
Zoe
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.
What can I do if my transaction log is full?--- Hot issues November
How to convert Profiler trace into a SQL Server table -- Hot issues November