<div>
Ok. That works. &lt;&gt;&nbsp;0 also worked<br />
Thanks
</div>


<div>
<div class="content wysiwyg-content">
I am returning a &nbsp;bit value field from a Stored Procedue to the report and using the expression<br />
=IIF(Fields!MyBitField.Val<wbr />ue = 1, &quot;Yes&quot;, &quot;No&quot;)<br />
and the report displays no for both 0 and 1<br />
How do I get the report to recognize the value?
</div>
</div>


I am returning a  bit value field from a Stored Procedue to the report and using the expression
=IIF(Fields!MyBitField.Value = 1, "Yes", "No")
and the report displays no for both 0 and 1
How do I get the report to recognize the value?

How do I get reporting services to recognize a bit field?

A database report is the formatted result of database queries and contains useful data for decision-making and analysis. Most good business applications contain a built-in reporting tool; this is simply a front-end interface that calls or runs back-end database queries that are formatted for easy application usage.