Forum Discussion

Seanan's avatar
Seanan
Icon for Solution Supplier rankSolution Supplier
2 years ago

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...
report builder
josef78's avatar
josef78
Icon for Memorable Member rankMemorable Member
2 years ago

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)