Forum Discussion
Error when passing multiple values to a parameter in report builder
I have a report builder report that uses an Azure SQL database stored procedure for it's dataset. In this report I have 2 parameter that are single value only and I now want to add a third parameter...
Try, do not use "Parameters" page in DataSet configuration (left this empty), and enter parameter name directly into SQL "Query" like this
AND CandidateId IN (@CandidateId)