Resources For IT Professionals

United States (English) Drop down arrow

Россия (Pусский)中国（简体中文）Brasil (Português)

Post an article

Wikis - Page Details

First published by Carla Sabotta (eMicrosof)
When: 13 Sep 2013 4:56 PM
Last revision by Maheshkumar S Tiwari
When: 13 Sep 2013 5:00 PM
Revisions: 4
Comments: 1

Options

Subscribe to Article (RSS)

Can You Improve This Article?

Positively! Click Sign In to add the tip, solution, correction or comment that will help other users.

Report inappropriate content using these instructions.

Must Declare Scalar Variable Error, in SSRS

There are various circumstances that may result in a "must declare the scalar variable" error when you try to run a report.

If you know of other circumstances and the associated workarounds, please contribute this information to this article.

Must Declare Scalar Variable Error and Multi-Value Parameters

When you create a multi-value parameter for a report, you add a variable to the dataset query. The text for the query variable must include the IN operator, as shown in the following example.

WHERE
Production.ProductInventory.ProductID IN (@ProductID)

If you don’t include the parentheses around the variable as shown above, the report fails to render and the “must declare the scalar variable” error is displayed.