<div>
Try this:<br />
<a href="http://www.dbforums.com/microsoft-sql-server/1626540-must-declare-scalar-variable-error.html" rel="ugc">http://www.dbforums.com/microsoft-sql-server/1626540-must-declare-scalar-variable-error.html</a>
</div>


Try this:
http://www.dbforums.com/microsoft-sql-server/1626540-must-declare-scalar-variable-error.html [http://www.dbforums.com/microsoft-sql-server/1626540-must-declare-scalar-variable-error.html]

<div>
Still no good, one of those refer to Access db formula?
</div>


Still no good, one of those refer to Access db formula?

<div>
Thanks, I was able to find more information with some of these links.
</div>


Thanks, I was able to find more information with some of these links.

<div>
<div class="content wysiwyg-content">
I am getting a scalar variable error when I try to run this.? I have other reports with a similar parameter that runs fine? I have tried = (@agency) in (@agency) = (?)<br />
<br />
one way or another it does not work.<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2011/02_w09/413970/Scalar-Error.bmp" target="_blank" title="Error (49 KB)"><img alt="Error" class="file-block lazyload" style="max-width: 795px;" data-src="https://filedb.experts-exchange.com/incoming/2011/02_w09/413970/Scalar-Error.bmp" /></a>
</div>
</div>


Scalar-Error.bmp

I am getting a scalar variable error when I try to run this.? I have other reports with a similar parameter that runs fine? I have tried = (@agency) in (@agency) = (?)

one way or another it does not work.



Scalar Error

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.